I've just read this in the MySQL-Doc:
To be safe with MySQL, you only need to have backups and have the update logging turned on. With this you can recover from any situation that you could with any transactional database. It is, of course, always good to have backups, independent of which database you use.
Can anyone explain me, how to setup some form of undo-last-query-whatever-it-was with help of the update log only? Say, I change a couple of values in a table, how could I recover them afterwards? Afaik, the update log doesn't keep some kind of backup-data, which should be necessary for these operations.
Am I missing sth. real obvious??
Thanks for help boys and girls
To be safe with MySQL, you only need to have backups and have the update logging turned on. With this you can recover from any situation that you could with any transactional database. It is, of course, always good to have backups, independent of which database you use.
Can anyone explain me, how to setup some form of undo-last-query-whatever-it-was with help of the update log only? Say, I change a couple of values in a table, how could I recover them afterwards? Afaik, the update log doesn't keep some kind of backup-data, which should be necessary for these operations.
Am I missing sth. real obvious??
Thanks for help boys and girls