MySQL Forums
Forum List  »  Newbie

Re: Moving mysql server from one server to another
Posted by: Peter Brawley
Date: January 16, 2018 01:30PM

One way ...

1 Do a complete mysqldump, import it to the new server.

2 Port the app(s) for this DB to the new server. Regression-test db and app till you're satisfied you've found all the bugs caused by the migration. In so doing, build scripts of db and app mods required by the move.

3 mysqldump the old db again, empty out the new db, import the most recent old-db-dump, run the scripts from #2, bring up the app on the new server, test everything again

4 Fix migration scripts from results of #3

5 Announce maintenance time for the app, repeat #3, actvate the app for everyone

Options: ReplyQuote


Subject
Written By
Posted
Re: Moving mysql server from one server to another
January 16, 2018 01:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.