Re: Disk Imaging backups [Scanned]

Andrew McGlashan wrote:

Non-database files are less likely to be a problem with rsync type backups -- I use rsnapshot for these. But database tables need to be fully consistent and so a short "freeze" will be required to be sure that everything is good.

The other way you can do it, is tell rsync to exclude the "real" database files, and don't worry if they're incoherent, because you have a daily cron job that tells the db to make a coherent dump of itself to a local file, which rsync will back up.