Re: OT backup mysql databases

[alan <alan clueserver org>]

On Wed, 27 Oct 2004, Edwin Dicker wrote:

> Hi guys,
> 
> 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 ?

You are better off using mysqldump.  Then if you have to go to a different 
version, you can just reload the tables.

-- 
chown -R us ./base