I learn backing up mysql database automatically ,it works using php with system() --> mysqldump
I've been wondering whether or not php can backup mysql incrementally ?
the bash shell script is confusing me and I'm not familiar with it, so I prefer more familiar language
Any one ever do the auto increment backup with php ? I kind of stuck here on how to write it
Well there is one way but really not that effective, and it can be done only when you start developing the application
like write all the "UPDATE" "INSERT" and "DELETE" to file which filter by date so there you can have it,
but if the application already there .... it's impossible .
sorry if I put it in the wrong forum category, it's more php than sql i think....
PHP mysql incremental backup
Moderator: General Moderators
Re: PHP mysql incremental backup
This isn't possible. MySQL doesn't keep track of when each record in your database has changed.