One issue is that you still lose anything newer than the last backup. The binary log is helpful to recover the delta's if you lose the database for whatever reason. I roll (backup) my binary logs too so I can use the prior days backups and recover to any point in time - such as recovering from bozo mistakes (Oops, didn't mean to alter the table in the production DB....:-) The binary log doesn't help if your entire machine goes south...
I also keep my backups for several months as I have been in the situation where something happened to data and nobody noticed for weeks.
You can also setup a slave DB server on your backup box that has up-to-the minute changes, and you can fail over to it if needed.
Learn about Linux
Download Linux
Get Linux help
Additional backup
Posted by: walt-sjc on December 29, 2004 03:57 AMI also keep my backups for several months as I have been in the situation where something happened to data and nobody noticed for weeks.
You can also setup a slave DB server on your backup box that has up-to-the minute changes, and you can fail over to it if needed.
#