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 :
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.
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: