6 February 2011

Migrate from one MySQL server to another

Migration from one MySQL server to another can be done in 3 steps; assuming your new server is ready.

Step 1 - your data:
Export all your databases (but mysql and test) and import them to your new server

Step 2 - access definition:
Export user and db tables of mysql database, and import them to your new server

Step 3 - flushing privileges:
Execute the following SQL command :
flush privileges;

Now, you can use your new server (data + access) exactly like the previous one.
Tips: do not forget to update the database host/port information of your third party applications using MySQL server.

No comments:

Post a Comment

Thank you for your visit, let's share your point of view: