Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mySQL incremental backup
- Thread starter alsaffar
- Start date
sleipnir214
Programmer
I don't know if any sofware like you want exists, because I don't know of MySQL provides that functionality.
One trick, just off the top of my head, is to add a timestamp column to every table against which you want to perform incremental backups.
Then perform a "SELECT...INTO OUTFILE...WHERE..." query and use the WHERE clause to output all records for which the timestamp column is later than a certain date.
You can then backup the files created by MySQL. It shouldn't be too hard to automate something like this.
Want the best answers? Ask the best questions: TANSTAAFL!!
One trick, just off the top of my head, is to add a timestamp column to every table against which you want to perform incremental backups.
Then perform a "SELECT...INTO OUTFILE...WHERE..." query and use the WHERE clause to output all records for which the timestamp column is later than a certain date.
You can then backup the files created by MySQL. It shouldn't be too hard to automate something like this.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Status