I am fairly new to MySQL and I am going to be setting up a web site on a
third party hosting machine. I continuously hear horror stories about
machines/sites being hacked and databases being destroyed. Despite my
best efforts I am sure I have some security flaws in my site. What I am
looking to do is provide myself with a mechanism to roll back my
database to a clean state if I happen to suffer one of these attacks (or
a failure). I was wondering what is the best way to do this. From my
limited knowledge of MySQL I think maybe I could use one of the following:
1) Binary Logs - Not really sure how these work but I was thinking of
maybe coping them to an off site machine every half hour and apply them
in sequence if I need to go back to a point in time ?
2) Incremental Backups - say one every half hour, then a script to
transfer that to an off site machine that way I can get the DB back to
within the last good half hour...
I don't really know much about either so if someone could give me some
pointers as to which is best it would be much appreciated...