Page 1 of 1

PHP mysql incremental backup

Posted: Sun Aug 09, 2009 10:06 pm
by wpsd2006
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....

Re: PHP mysql incremental backup

Posted: Thu Aug 13, 2009 9:31 am
by izzy4505
This isn't possible. MySQL doesn't keep track of when each record in your database has changed.