Wednesday, March 18, 2015

MySQL - mysqlbinlog default-character-set error



I tried reading the bin log file in mysql. What I was greeted with is this error.

shell> bin/mysqlbinlog /var/lib/mysql3306/mysql-bin.000001
bin/mysqlbinlog: unknown variable 'default-character-set=utf8'

Solving this is pretty simple.

shell> bin/mysqlbinlog --no-defaults -v /var/lib/mysql3306/mysql-bin.000001

And done.

No comments :