I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500.
How can I do that?
This question came from our site for professional and enthusiast programmers.
Use the mysqlbinlog utility
Suppose your binary log is called mysql-bin.012345. You would do the following for positions 10 - 2500 to attach it to a mysqldump called MySQLData.sql:
or append directly with
Give it a Try !!!