PHP mysql incremental backup

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
wpsd2006
Forum Commoner
Posts: 66
Joined: Wed Jan 07, 2009 12:43 am

PHP mysql incremental backup

Post 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....
izzy4505
Forum Newbie
Posts: 16
Joined: Tue Aug 11, 2009 1:38 pm

Re: PHP mysql incremental backup

Post by izzy4505 »

This isn't possible. MySQL doesn't keep track of when each record in your database has changed.
Post Reply