Save some work...
You have several alternatives by which a great deal of effort may best be avoided.
Firstly, arrange a backup process at two levels :
First, set-up a cron-task to do a bulk dump (mysqldump --all-databases --extended-insert) each night. Also, every hour, backup the bin-logs.
Also, every night try to do a mysqldump for each table, separately into their own files, with --skip-extended-insert (so there is one line in the file per row in the table). This let's you get back data far more quickly.
Lastly, as I mentioned above -- consider triggers for auditing, so you can keep some backups and trails inside the database.
|