> Best is to take a database backup of the testing database using > mysqldump, output this to a file, and then restore it to the > production database. For instance,
Do you mean the other way around? Emily, were you asking how to port production snapshot to test server or vice versa? Thanks! Kay > -----Original Message----- > From: Adam Feuer [mailto:[email protected]] > Sent: Tuesday, June 01, 2010 8:30 PM > To: A good place to start for users or folks new to Mifos. > Cc: Kevin Kimani > Subject: Re: [Mifos-users] Question on how to port snapshot of production dbto > test server > > On Tue, Jun 1, 2010 at 7:11 PM, Emily Tucker > <[email protected]> wrote: > > (*) What version of MySQL should they be running on the test server? > > MySQL - Community Edition 5.1.31 > > For more info see the INSTALL doc: > > http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/1.5.x;a=blob_pla in;f=INS > TALL;hb=HEAD > > > (*) What is the best way to port a snapshot of the production db to the test > > server? > > Best is to take a database backup of the testing database using > mysqldump, output this to a file, and then restore it to the > production database. For instance, > > % mysqldump -uroot -p mifos-testing >testing-database-backup.sql > % mysql -uroot -p mifos-production < testing-database-backup.sql > > Remember to shut down mifos before taking or restoring the backup. > > cheers > adam > -- > Adam Feuer <adamf at pobox dot com> > > ------------------------------------------------------------------------ ------ > > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
