it`s important to have _both_ backups for mysql or other databases.
if your database isn`t that big, i would always recommend backing up the
database files _and_ a dumpfile.
i have seen mysqldump fail on certain condition, e.g.
http://bugs.mysql.com/bug.php?id=10249 and the file level backup saved my
day after recognizing the restore via dumpfile causing data corruption.
roland
----- Original Message -----
From: "Iain Dooley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Blair Zajac" <[EMAIL PROTECTED]>; <[email protected]>
Sent: Saturday, November 11, 2006 1:22 AM
Subject: Re: [rdiff-backup-users] rdiff-backup for email
I back up my entire system with rdiff-backup to a local drive, then
rsync
the
entire rdiff-backup over to another box. I backup email, Postgresql,
Mysql,
Apache, etc.
Just be aware that unless you are taking special precautions, the
postgresql backup is not guaranteed to be consistent. I am not sure about
the others, but I imagine that would also be the case.
i backup mysql, but in my backup script i have the line:
mysqldump -u USER --password=PASS --all-databases > \
/root/full_mysql_dump.sql
which means that i can a) browse the history without changing the live
data and b) am guarded against problems restoring the binary file formats.
cheers
iain
_______________________________________________
rdiff-backup-users mailing list at [email protected]
http://lists.nongnu.org/mailman/listinfo/rdiff-backup-users
Wiki URL:
http://rdiff-backup.solutionsfirst.com.au/index.php/RdiffBackupWiki
_______________________________________________
rdiff-backup-users mailing list at [email protected]
http://lists.nongnu.org/mailman/listinfo/rdiff-backup-users
Wiki URL: http://rdiff-backup.solutionsfirst.com.au/index.php/RdiffBackupWiki
