Re: OT backup mysql databases

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

 



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


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

  Powered by Linux