[horde] Backing up horde databases

[Aaron Segura]

I should say, "Tarring up the raw files from a *running* database will
only cause you to cry when/if you try to restore"

-----Original Message-----
From: horde-bounces at lists.horde.org
[mailto:horde-bounces at lists.horde.org] On Behalf Of Aaron Segura
Sent: Thursday, December 14, 2006 2:03 PM
To: Eric; horde at lists.horde.org
Subject: Re: [horde] Backing up horde databases

You should be using 'mysqldump' to backup a running database.  Tarring
up the raw database files will only cause you to cry when/if you try to
restore.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

-----Original Message-----
From: horde-bounces at lists.horde.org
[mailto:horde-bounces at lists.horde.org] On Behalf Of Eric
Sent: Thursday, December 14, 2006 1:54 PM
To: horde at lists.horde.org
Subject: [horde] Backing up horde databases


To back up my MySQL and Horde databases, I have been going to 
/var/lib/mysql (in Fedora Core 2) and saying:

tar rf mysql.db.YYMMDD.tar mysql
... to tarball the mysql database, and

tar rf horde.db.YYMMDD.tar horde
... to tarball the horde database.  Then

gzip *db*tar

Then I download the gzip'ed tarballs and burn them onto CD.

Am I getting everything that's important by doing this, or should I 
be doing something else?

Thanks...

-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org
-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org