Restore database from MySQL dump

Hi everybody, the operating system of my server crushed for unknown reason so far, Windows Server 2008, we are cloning the damaged server but for some reason the web hosting decided to reinstall the enviroment and import the MySQL dump file.
How can I import the last dump file database to the new installation or there is a recomended procedure to restore a broken ODK server?
OS: Windows Server 2008
Database: MySQL 5.6
Webserver: tomcat 6
Java: version 7

Thank in advance!!

There is nothing unique about Aggregate's use of the MySQL DB. Find
instructions on how to restore MySQL on the web and use those
instructions. I'd make sure Tomcat is not running before doing the
restore.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Mon, Sep 14, 2015 at 6:17 PM, antogumba antogumba@gmail.com wrote:

Hi everybody, the operating system of my server crushed for unknown reason so far, Windows Server 2008, we are cloning the damaged server but for some reason the web hosting decided to reinstall the enviroment and import the MySQL dump file.
How can I import the last dump file database to the new installation or there is a recomended procedure to restore a broken ODK server?
OS: Windows Server 2008
Database: MySQL 5.6
Webserver: tomcat 6
Java: version 7

Thank in advance!!

--

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.

thank you Yaw for you dedicated attention.

Here is what I did:
After stopped tomcat as you advised, I restored the mysql dump file, all
the tables without exception, and I restored the war file from the previous
installation which crushed because of Server problems.

I would like to hear from you if it was the correct approach, concerning
the war file.

I have been facing some hardware problems on my web hosting provider.

··· On Tuesday, September 15, 2015 at 5:15:39 PM UTC+2, Yaw Anokwa wrote: > > There is nothing unique about Aggregate's use of the MySQL DB. Find > instructions on how to restore MySQL on the web and use those > instructions. I'd make sure Tomcat is not running before doing the > restore. > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Mon, Sep 14, 2015 at 6:17 PM, antogumba <anto...@gmail.com > wrote: > > Hi everybody, the operating system of my server crushed for unknown > reason so far, Windows Server 2008, we are cloning the damaged server but > for some reason the web hosting decided to reinstall the enviroment and > import the MySQL dump file. > > How can I import the last dump file database to the new installation or > there is a recomended procedure to restore a broken ODK server? > > OS: Windows Server 2008 > > Database: MySQL 5.6 > > Webserver: tomcat 6 > > Java: version 7 > > > > Thank in advance!! > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

I think you are probably fine, but I'd upgrade to the latest Aggregate
just in case there is an issue with the war. I'd also make sure you
have regular backups.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Sep 17, 2015 at 9:56 AM, antogumba antogumba@gmail.com wrote:

thank you Yaw for you dedicated attention.

Here is what I did:
After stopped tomcat as you advised, I restored the mysql dump file, all the
tables without exception, and I restored the war file from the previous
installation which crushed because of Server problems.

I would like to hear from you if it was the correct approach, concerning the
war file.

I have been facing some hardware problems on my web hosting provider.

On Tuesday, September 15, 2015 at 5:15:39 PM UTC+2, Yaw Anokwa wrote:

There is nothing unique about Aggregate's use of the MySQL DB. Find
instructions on how to restore MySQL on the web and use those
instructions. I'd make sure Tomcat is not running before doing the
restore.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Mon, Sep 14, 2015 at 6:17 PM, antogumba anto...@gmail.com wrote:

Hi everybody, the operating system of my server crushed for unknown
reason so far, Windows Server 2008, we are cloning the damaged server but
for some reason the web hosting decided to reinstall the enviroment and
import the MySQL dump file.
How can I import the last dump file database to the new installation or
there is a recomended procedure to restore a broken ODK server?
OS: Windows Server 2008
Database: MySQL 5.6
Webserver: tomcat 6
Java: version 7

Thank in advance!!

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@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.

Thank you, lastest Aggregate you mean the version 1.4.7 ?

··· On Thursday, September 17, 2015 at 4:15:17 PM UTC+2, Yaw Anokwa wrote: > > I think you are probably fine, but I'd upgrade to the latest Aggregate > just in case there is an issue with the war. I'd also make sure you > have regular backups. > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > > On Thu, Sep 17, 2015 at 9:56 AM, antogumba <anto...@gmail.com > wrote: > > thank you Yaw for you dedicated attention. > > > > Here is what I did: > > After stopped tomcat as you advised, I restored the mysql dump file, all > the > > tables without exception, and I restored the war file from the previous > > installation which crushed because of Server problems. > > > > I would like to hear from you if it was the correct approach, concerning > the > > war file. > > > > I have been facing some hardware problems on my web hosting provider. > > > > On Tuesday, September 15, 2015 at 5:15:39 PM UTC+2, Yaw Anokwa wrote: > >> > >> There is nothing unique about Aggregate's use of the MySQL DB. Find > >> instructions on how to restore MySQL on the web and use those > >> instructions. I'd make sure Tomcat is not running before doing the > >> restore. > >> > >> Yaw > >> -- > >> Need ODK services? http://nafundi.com provides form design, server > >> setup, professional support, and software development for ODK. > >> > >> On Mon, Sep 14, 2015 at 6:17 PM, antogumba wrote: > >> > Hi everybody, the operating system of my server crushed for unknown > >> > reason so far, Windows Server 2008, we are cloning the damaged server > but > >> > for some reason the web hosting decided to reinstall the enviroment > and > >> > import the MySQL dump file. > >> > How can I import the last dump file database to the new installation > or > >> > there is a recomended procedure to restore a broken ODK server? > >> > OS: Windows Server 2008 > >> > Database: MySQL 5.6 > >> > Webserver: tomcat 6 > >> > Java: version 7 > >> > > >> > Thank in advance!! > >> > > >> > -- > >> > -- > >> > Post: opend...@googlegroups.com > >> > Unsubscribe: opendatakit...@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...@googlegroups.com. > >> > For more options, visit https://groups.google.com/d/optout. > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

Yes.

··· On Thu, Sep 17, 2015 at 10:59 AM, antogumba wrote: > Thank you, lastest Aggregate you mean the version 1.4.7 ? > > On Thursday, September 17, 2015 at 4:15:17 PM UTC+2, Yaw Anokwa wrote: >> >> I think you are probably fine, but I'd upgrade to the latest Aggregate >> just in case there is an issue with the war. I'd also make sure you >> have regular backups. >> >> Yaw >> -- >> Need ODK services? http://nafundi.com provides form design, server >> setup, professional support, and software development for ODK. >> >> >> On Thu, Sep 17, 2015 at 9:56 AM, antogumba wrote: >> > thank you Yaw for you dedicated attention. >> > >> > Here is what I did: >> > After stopped tomcat as you advised, I restored the mysql dump file, all >> > the >> > tables without exception, and I restored the war file from the previous >> > installation which crushed because of Server problems. >> > >> > I would like to hear from you if it was the correct approach, concerning >> > the >> > war file. >> > >> > I have been facing some hardware problems on my web hosting provider. >> > >> > On Tuesday, September 15, 2015 at 5:15:39 PM UTC+2, Yaw Anokwa wrote: >> >> >> >> There is nothing unique about Aggregate's use of the MySQL DB. Find >> >> instructions on how to restore MySQL on the web and use those >> >> instructions. I'd make sure Tomcat is not running before doing the >> >> restore. >> >> >> >> Yaw >> >> -- >> >> Need ODK services? http://nafundi.com provides form design, server >> >> setup, professional support, and software development for ODK. >> >> >> >> On Mon, Sep 14, 2015 at 6:17 PM, antogumba wrote: >> >> > Hi everybody, the operating system of my server crushed for unknown >> >> > reason so far, Windows Server 2008, we are cloning the damaged server >> >> > but >> >> > for some reason the web hosting decided to reinstall the enviroment >> >> > and >> >> > import the MySQL dump file. >> >> > How can I import the last dump file database to the new installation >> >> > or >> >> > there is a recomended procedure to restore a broken ODK server? >> >> > OS: Windows Server 2008 >> >> > Database: MySQL 5.6 >> >> > Webserver: tomcat 6 >> >> > Java: version 7 >> >> > >> >> > Thank in advance!! >> >> > >> >> > -- >> >> > -- >> >> > Post: opend...@googlegroups.com >> >> > Unsubscribe: opendatakit...@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...@googlegroups.com. >> >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@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...@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.