Re: OT backup mysql databases

["Edwin Dicker" <fedora dicker nl>]

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