Sample Header Ad - 728x90

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