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?
dumplogsMySQLreplication
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?
Best Answer
Use the mysqlbinlog utility
mysqlbinlog --help
gives the following: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:
Either
or append directly with
Give it a Try !!!