OT backup mysql databases
alan
alan at clueserver.org
Wed Oct 27 21:01:36 UTC 2004
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
More information about the fedora-list
mailing list