Re: OT backup mysql databases

[Glen Staufer <alaxsxaq gmail com>]

On Wed, 27 Oct 2004 22:50:22 +0200, Edwin Dicker <fedora dicker nl> 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 ?
> 

If you can shut the database down during backup, that is the simplest
way to do it.

There are a variety of online backup methods which you can learn more
about in the mysql documentation including mysqldump and mysqlhotcopy.
 I would suggest that you read the documentation
(http://dev.mysql.com/doc/mysql/en/Backup.html) on backup since there
are steps you should follow to ensure that a backup performed with one
of these methods is adequate for recovery.

Glenn