----- Original Message ----- From: "Christopher Hicks" <chicks@xxxxxxxxxx>
To: "RedHat's Fedora List" <fedora-list@xxxxxxxxxx>
Sent: Wednesday, 27 October, 2004 23:07
Subject: Re: OT backup mysql databases
On 27 Oct 2004, Edwin Dicker shaped electrons to convey:I have a few small mysql databases on my system. I backup my whole system every week with a cpio backup to tape. Is a cpio backup good enough for mysql databases? If I restore the /var/lib/mysql directory structure, will i have full access again ? Do I need to stop the mysqld service before creating the backup ?
Running mysqldump on each tablespace (including the mysql tablespace) would be much cleaner and not require any shutdown of mysql. The backups of the /var/lib/mysql directory may or may not be consistant depending on whether there's any update activity at that point. (And mysql can delay updates so there may be update activity after there's noone connected for a short time.)
-- </chris>
Thanks for the info Chris. If I would stop the service during backup, would the database be up-to-date then?
Edwin
