Syncing old server to new - MySQL
Posted on 2014-02-14
We have a web server that is crashing/unstable - and a new server that has been bare-metal installed from a backup from broken server about a week old. There is, however, new data (both mysql and actual PHP files.)
I'm going to break this up into two questions - this is just for the MySQL.
How would you recommend I go about syncing up just the newer files? Is there a way for me to just transfer over the relevant MySQL files and doing so will it automatically "update" due to the replacement? My normal way of doing it would be to go site by site and through phpMyAdmin export the tables/databases...then import them into the databases on the new server...but that will kinda suck. Is there a quicker/more efficient way of doing it?
Thanks in advance!