Imagine, I am building a web application of a Bank. Therefore I need to backup the database at least once a day and to backup the whole database everyday does not sound efficient. So I want to know how to create the backup file of the database only holding the transactions of current day.
migrated from stackoverflow.com Aug 6 '10 at 2:35
Make Incremental Backups by Enabling the Binary Log.