Re: OT backup mysql databases

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

 



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 

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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux