Crashed server

Support
1

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up the
database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the backed up
mysql data so as to have all my data till the day just before the crash, I
want after this I go resubmit all data from the tablets plus all collected
data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra 3
forms that where not backed up with server that they do not create other
tables in mysql?

2

I am not certain that I fully understanding your situation.

I think you have:

(1) an older snapshot of the server from a time when your ODK Aggregate had
5 forms on it.
(2) a current backup of your database, when ODK Aggregate had 8 forms on it.

If that is correct, then it is a fairly easy recovery process.

ODK Aggregate does not store anything in files on the system -- all form
definitions and data are stored in the database.

So the recovery process is:

(1) restore to the older snapshot; shut off Tomcat or do not start it.
(2) apply the database backup to update the database to the most recent
backup.
(3) start Tomcat

And, for reprocessing forms from the devices, you can go to the Send Forms
screen, long-press the Toggle button, and choose to view all forms (rather
than just the submitted ones), and resubmit all of them.

This will work as long as each filled-in form has a unique ID, which is
automatically provided by XLSForm. If your forms do not have unique
instance IDs, then you will get duplicates during this process.

··· On Sun, May 8, 2016 at 4:37 AM, Ayoub Kakande wrote:

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up the
database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the backed
up mysql data so as to have all my data till the day just before the
crash, I want after this I go resubmit all data from the tablets plus all
collected data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra 3
forms that where not backed up with server that they do not create other
tables in mysql?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

Thanks mitch
my worry is about the extra 3 forms which will not be on aggregate when I
apply the snap shot yet will b in mysql after applying the database backup.

··· On May 8, 2016 9:36 PM, "Mitch Sundt" wrote:

I am not certain that I fully understanding your situation.

I think you have:

(1) an older snapshot of the server from a time when your ODK Aggregate
had 5 forms on it.
(2) a current backup of your database, when ODK Aggregate had 8 forms on
it.

If that is correct, then it is a fairly easy recovery process.

ODK Aggregate does not store anything in files on the system -- all form
definitions and data are stored in the database.

So the recovery process is:

(1) restore to the older snapshot; shut off Tomcat or do not start it.
(2) apply the database backup to update the database to the most recent
backup.
(3) start Tomcat

And, for reprocessing forms from the devices, you can go to the Send Forms
screen, long-press the Toggle button, and choose to view all forms (rather
than just the submitted ones), and resubmit all of them.

This will work as long as each filled-in form has a unique ID, which is
automatically provided by XLSForm. If your forms do not have unique
instance IDs, then you will get duplicates during this process.

On Sun, May 8, 2016 at 4:37 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up the
database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the backed
up mysql data so as to have all my data till the day just before the
crash, I want after this I go resubmit all data from the tablets plus all
collected data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra 3
forms that where not backed up with server that they do not create other
tables in mysql?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

OK. Yes, Not a problem.

Just restore the database. All will be good.

··· On Sun, May 8, 2016 at 11:43 AM, Ayoub Kakande wrote:

Thanks mitch
my worry is about the extra 3 forms which will not be on aggregate when I
apply the snap shot yet will b in mysql after applying the database backup.
On May 8, 2016 9:36 PM, "Mitch Sundt" mitchellsundt@gmail.com wrote:

I am not certain that I fully understanding your situation.

I think you have:

(1) an older snapshot of the server from a time when your ODK Aggregate
had 5 forms on it.
(2) a current backup of your database, when ODK Aggregate had 8 forms on
it.

If that is correct, then it is a fairly easy recovery process.

ODK Aggregate does not store anything in files on the system -- all form
definitions and data are stored in the database.

So the recovery process is:

(1) restore to the older snapshot; shut off Tomcat or do not start it.
(2) apply the database backup to update the database to the most recent
backup.
(3) start Tomcat

And, for reprocessing forms from the devices, you can go to the Send
Forms screen, long-press the Toggle button, and choose to view all forms
(rather than just the submitted ones), and resubmit all of them.

This will work as long as each filled-in form has a unique ID, which is
automatically provided by XLSForm. If your forms do not have unique
instance IDs, then you will get duplicates during this process.

On Sun, May 8, 2016 at 4:37 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up the
database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the backed
up mysql data so as to have all my data till the day just before the
crash, I want after this I go resubmit all data from the tablets plus all
collected data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra 3
forms that where not backed up with server that they do not create other
tables in mysql?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

5

I.e., the 3 forms will be there.

··· On Sun, May 8, 2016 at 11:47 AM, Mitch Sundt wrote:

OK. Yes, Not a problem.

Just restore the database. All will be good.

On Sun, May 8, 2016 at 11:43 AM, Ayoub Kakande akakande@gmail.com wrote:

Thanks mitch
my worry is about the extra 3 forms which will not be on aggregate when I
apply the snap shot yet will b in mysql after applying the database backup.
On May 8, 2016 9:36 PM, "Mitch Sundt" mitchellsundt@gmail.com wrote:

I am not certain that I fully understanding your situation.

I think you have:

(1) an older snapshot of the server from a time when your ODK Aggregate
had 5 forms on it.
(2) a current backup of your database, when ODK Aggregate had 8 forms on
it.

If that is correct, then it is a fairly easy recovery process.

ODK Aggregate does not store anything in files on the system -- all
form definitions and data are stored in the database.

So the recovery process is:

(1) restore to the older snapshot; shut off Tomcat or do not start it.
(2) apply the database backup to update the database to the most recent
backup.
(3) start Tomcat

And, for reprocessing forms from the devices, you can go to the Send
Forms screen, long-press the Toggle button, and choose to view all forms
(rather than just the submitted ones), and resubmit all of them.

This will work as long as each filled-in form has a unique ID, which is
automatically provided by XLSForm. If your forms do not have unique
instance IDs, then you will get duplicates during this process.

On Sun, May 8, 2016 at 4:37 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up
the database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the
backed up mysql data so as to have all my data till the day just before the
crash, I want after this I go resubmit all data from the tablets plus all
collected data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra
3 forms that where not backed up with server that they do not create other
tables in mysql?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

6

Thanks mitch so much
have restored system.

··· On May 8, 2016 9:47 PM, "Mitch Sundt" wrote:

I.e., the 3 forms will be there.

On Sun, May 8, 2016 at 11:47 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

OK. Yes, Not a problem.

Just restore the database. All will be good.

On Sun, May 8, 2016 at 11:43 AM, Ayoub Kakande akakande@gmail.com wrote:

Thanks mitch
my worry is about the extra 3 forms which will not be on aggregate when
I apply the snap shot yet will b in mysql after applying the database
backup.
On May 8, 2016 9:36 PM, "Mitch Sundt" mitchellsundt@gmail.com wrote:

I am not certain that I fully understanding your situation.

I think you have:

(1) an older snapshot of the server from a time when your ODK Aggregate
had 5 forms on it.
(2) a current backup of your database, when ODK Aggregate had 8 forms
on it.

If that is correct, then it is a fairly easy recovery process.

ODK Aggregate does not store anything in files on the system -- all
form definitions and data are stored in the database.

So the recovery process is:

(1) restore to the older snapshot; shut off Tomcat or do not start it.
(2) apply the database backup to update the database to the most recent
backup.
(3) start Tomcat

And, for reprocessing forms from the devices, you can go to the Send
Forms screen, long-press the Toggle button, and choose to view all forms
(rather than just the submitted ones), and resubmit all of them.

This will work as long as each filled-in form has a unique ID, which is
automatically provided by XLSForm. If your forms do not have unique
instance IDs, then you will get duplicates during this process.

On Sun, May 8, 2016 at 4:37 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi all,
I have ODKAggregate mysql and tomcat
been having the server up for 1 year now
i backed up the server(snapshot) amd had a cron that was backing up
the database daily.
by time I backed up server I had 5 forms, as of now have 8 forms.
these extra 3 forms' data is backed up.
my server has crashed I want to pull the snapshot plus import the
backed up mysql data so as to have all my data till the day just before the
crash, I want after this I go resubmit all data from the tablets plus all
collected data that was not submitted but was collected after crash.
my question is how do I make sure in aggregate when I upload the extra
3 forms that where not backed up with server that they do not create other
tables in mysql?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.