Get position of mysqlbinlog error. I have the error's line number
1
vote
1
answer
1015
views
If I use mysqlbinlog to load a binlog into my database like this:
mysqlbinlog --defaults-file=/path/mysqld.cnf bin.000011| mysql -u root
and get an error like this:
ERROR 2006 at line 290: MySQL server has gone away
How do I convert line 290 into a binlog position that I can use to rerun the log, starting at the failed line?
mysqlbinlog --defaults-file=/path/mysqld.cnf --start-position= bin.000011| mysql -u root
I'm using binlog-format=ROW
Or, how can I log the binlog position of the error, and not just the line number?
It seems that there must be a way to recover from an error while updating a database with mysqlbinlog, otherwise the whole database is corrupted.
Asked by user984003
(161 rep)
May 31, 2019, 09:26 PM
Last activity: Jul 24, 2025, 12:02 PM
Last activity: Jul 24, 2025, 12:02 PM