[BlueOnyx:04440] Re: Suggestion to Change Location of Domain MySQL Databases

[Michael Stauber]

Hi Greg,

>   * Database backups with cmuexport will not necessarily be any use to 
> you, unless you shutdown the database. You have to remember that the 
> database has these files open at all times, and is constantly making 
> updates...
>    * What about innodb files - Not all data is in the www.mydomain.com 
> directory - so a restore will not give you a full working database anyway.

Correct. Those two alone make it a non issue. Additionally: This won't back up 
the privilege tables either, so while you may retain (possibly wrecked!) 
databases during CMU, you still loose the MySQL users and their privilege 
settings.

A bad backup is like having none, because creates a wrong sense of security 
and it'll usually fail you when you need it the most.

Best way to fully backup MySQL is still doing a MySQL-dump.

-- 
With best regards

Michael Stauber