i have two servers, each with a mysql instance. the "old" server has a couple of db instances that i want to migrate. aside from stopping the service, and scp'ing the files in /var/lib/mysql from old ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...