How to move all MySQL databases to another server
Monday, February 16th, 2009How to move all MySQL databases to a new server in a few simple steps.
Let’s assume your original location of mysql is at /media/disk/…
Your new location of mysql is at /
You just need to synchronize two directories /etc/mysql and /var/lib/mysql/. Remember to stop mysql before doing this, and start it after synchronisation.
/etc/init.d/mysql stoprsync -rav […]
