>> If I would have some fancy mirroring solution it would have replicated > the >> problem. So that wouldn't have helped. >> It's not an option to restore a database from the day before either. >> I guess the only thing I can do is take a backup more often but it hurts >> performance. I mean really it not that easy... >> How often do you guys take a backup? > > If you use MySQL, you have the binary log. That allows you restore any > changes done after the last full backup(or which point in time ever). The > binary logfile can be saved easily every hour. It can also get moved to > another machine, after you have cycled the logfiles.
If the database becomes corrupted at say 1am and you don't notice it until your first cup of coffee at 9am, is the binary log going to be of any help? Is it possible to restore to a point the database was consistent and then use the 'good' changes from the log? Anne _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
