Re: Moving dbs to new server

[Rick James]

> The partition layout is different on the machines.
Elaborate.
In particular, if files are symbolically linked, then the table is ALTERed, the links may be lost and the table will move to a different location.

> Would stopping mysql as you indicated have prevented this?
A graceful stop should not do any harm. kill -9 can do other forms of damage.

chown (and maybe chmod) is needed after certain flavors of machine-to-machine copies. Also it depends on who you are when you tar/untar (or zip/unzip). I would use scp or netcat (nc), as root, to copy the files and not lose the ownership and permissions. tar/zip are not necessarily of much benefit if the machines are on a gigabit ethernet.

Oh, if the number associated with 'user' mysql is different on the two machine, that could have caused the trouble. (Unix utilities send only the number, not the name, I think.)

3 hours for copy; 36 hours for mysqldump. -- In the former case, the indexes were copied; in the latter they had to be rebuilt.