Mysql Restore from binlogs

How can we make one database re开发者_StackOverflow中文版store date to date, like "sunday to wednesday" but from one binlog file?

Thanks,

Pedro

You can use mysqlbinlog. To specify start and end dates, use the --start-datetime and --stop-datetime arguments; they are documented on the mysqlbinlog page in the MySQL Manual.

You need to first restore your last full backup which was before the point you want to restore to. Then replay the binlogs from that point (The backup should probably have been created containing the binlog position - if not you'll have to try to work it out) up to the point you want to restore to.