[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: OT backup mysql databases

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

Attachment: signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]