Database dumping in mysql after certain checkpoints

I want to get mysqldump after certain checkpoint e.g. if i ta开发者_Python百科ke the mysqldump now then next time when i will take the dump it should give me only the commands which executed between this time interval. is there anyway to get this using mysqldump.

One more thing how to show the commands delete, update in the mysqldump files.

Thanks

I dont think this is possible from a MySQLdump, however that feature exists as part of MySQL core - its called Binlogging or binary logging.

The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows). The binary log also contains information about how long each statement took that updated data

Check this out http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

Word of warning, binlogs can slow down the performance of your server.