Re: [rdiff-backup-users] rdiff-backup for email

[roland]

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 
> > > 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 address@hidden
> http://lists.nongnu.org/mailman/listinfo/rdiff-backup-users
> Wiki URL: 
> http://rdiff-backup.solutionsfirst.com.au/index.php/RdiffBackupWiki