101 reputation
1
bio website
location Cincinnati, OH
age
visits member for 1 year, 10 months
seen yesterday

Jul
8
comment mysql restoration process takes longer time
The problem with backing up the datadir is that unless mysqld is stopped when you do so, the best outcome you can hope for is that the server where you restore to will attempt to recover from the crash it will believe occurred previously, because of the inevitable inconsistencies. If the new server version is the same or newer, and the my.cnf is identical in a few important ways, then yes, this works. We use a simiar process, when possible, for cloning replication slaves.