|
From: | roland |
Subject: | Re: [rdiff-backup-users] rdiff-backup for email |
Date: | Sat, 11 Nov 2006 01:50:56 +0100 |
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" <address@hidden>
To: <address@hidden> Cc: "Blair Zajac" <address@hidden>; <address@hidden> 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 rsyncthe 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.sqlwhich 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 address@hidden http://lists.nongnu.org/mailman/listinfo/rdiff-backup-usersWiki URL: http://rdiff-backup.solutionsfirst.com.au/index.php/RdiffBackupWiki
[Prev in Thread] | Current Thread | [Next in Thread] |