Thursday 20 August 2015

mysqlbinlog Segmentation fault (core dumped)

[root@twpdb22 mysqlbinlog]# mysqlbinlog --no-defaults -v logbin.000912 > logbin000912.sql
Segmentation fault (core dumped)
[root@twpdb22 mysqlbinlog]# find / -name mysqlbinlog
/data/mysql/mysqlbinlog
/usr/local/mysql/bin/mysqlbinlog
/usr/bin/mysqlbinlog

You have new mail in /var/spool/mail/root
[root@twpdb22 mysqlbinlog]# rm -fr /usr/bin/mysqlbinlog
[root@twpdb22 mysqlbinlog]# cp /usr/local/mysql/bin/mysqlbinlog /usr/bin/
You have new mail in /var/spool/mail/root
[root@twpdb22 mysqlbinlog]# mysqlbinlog --no-defaults -v logbin.000912 > logbin000912.sql
[root@twpdb22 mysqlbinlog]#


The reason was got 2 different version mysqlbinlog , replace the old with new version, then settle the issue.

No comments:

Post a Comment