OT backup mysql databases

[Edwin Dicker]

----- Original Message ----- 
From: "Christopher Hicks" <chicks at chicks.net>
To: "RedHat's Fedora List" <fedora-list at redhat.com>
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