OT backup mysql databases

[Alexander Dalloz]

Am Mi, den 27.10.2004 schrieb Edwin Dicker um 22:50:

> 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?

It is proper.

> If I restore the /var/lib/mysql directory structure, will i have full access 
> again ?

Yes, if you do it right.

> Do I need to stop the mysqld service before creating the backup ?

Yes, if you just copy the databases files.
To be on the safe side use "mysqldump" which will take care for
situations where any database is used during you run the backup. See
manpage and --help.

> Edwin 

Alexander


-- 
Alexander Dalloz | Enger, Germany | GPG key 1024D/ED695653 1999-07-13
Fedora GNU/Linux Core 2 (Tettnang) kernel 2.6.8-1.521smp 
Serendipity 22:54:40 up 7 days, 19:34, load average: 0.72, 0.66, 0.57 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20041027/dccd1ba9/attachment-0001.sig>