Re: copying raw mysql data from one server to another

[Peter Brawley]

> if the raw data could be copied over properly while the instance is running which from your answer you suggest it cannot.

Right, it can't. MySQL is not a filing system.

> If I stop the MySQL instance, however, then is it correct that it can be copied over correctly?

Depending on the database, its engine(s), its settings, its use of partitions and symlinks, its stored routines, and a host of other issues---your file copy has a small chance of being correct and usable, but more chances of being incomplete and therefore invalid.

So again, the way to go is mysqldump.