Backup Plan / flush-logs by database

[steve ungar]

I'm in the process of figuring out how to transition from daily full backups to weekly full backups and daily incremental backups. My plan is:

- weekly: mysqldump for each database (not using --all-databases)
- daily: mysqladmin flush-logs

Is that the proper procedure? If so, I could use some advice/feedback on the following:

* We have several databases that get backed up, and most of the time we only need to restore 1 (ie - screwed up data in 1 database as opposed to a disaster recover situation). It looks like the logs from flush-logs contain the changes for ALL databases. Is it possible to start from a full backup of 1 database and apply just the changes that affect that database?

* My plan is to archive off site both the weekly full backups as well as all of the daily logs. Am I being thorough or is it overkill to keep the daily logs once I have a complete full backup?

Any other advice?

Thanks for your help,
-Steve