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?
The log records *EVERY* query which is executed.
Therefor you can restore an old backup, and redo every query until
time-point X
You just have to keep pairs of complete backups and logs to restore.
The longer between complete backups the longer it takes to restore
because queries have to be executed.
You can effectively restore to every time you have the logs and the
backup of the server at which they start.
(I only use PostgreSQL so make sure of the differences between PITR
and the implementation of MySQL before
believing me on my word).
Marc
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
