I need to migrate all the databases from one server to another. There are about 100 databases, and all databases are used daily and updated/inserted too and read through their respective websites.
If I copy over the databases in one go, by the time the website for that database is migrated to the new server, the data will be out of sync.
Is there a way to setup a temporary replicate of all the databases in the server to replicate to the new server (one way master/slave replication, master being the original server and slave being the source server). I can then setup the website on the new server and run it in parallel to the old site until all sites are migrated then switch off the old server.
I'm running MySQL 5 community edition.
Thanks
Jason