var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Backup mysqldump by sqlquery
I' like to backup day by day from mysql. However I don't know how to do it ? How to get different of yesterday from today ...?
For instance ;
I took backup on yesterday (05-26-2012) at midnight and I'd like to backup for today at midnight. But Today Backup's shouldn't contains yesterday data...
How can I do this ?
What you are looking for as an incremental backup. That is to say only the data changes between your last backup and now. Check this link:MySQL :: MySQL 5.1 Reference Manual :: 7.2 Database Backup Methods. You will need to activate binary logs to do this.