Tuesday, 10 December 2013

mysqlbinlog: unknown variable 'default-character-set=utf8'

Today when I try to check the log-bin file, encounter an error:
mysqlbinlog: unknown variable 'default-character-set=utf8'
it's because inside the my.cnf  got
default-character-set=utf8


the default-character-set is deprecated in 5.5. we should use instead:
character-set-server = utf8
 
or add ----no-defaults
 
mysqlbinlog --no-defaults -v logbin-log.000003 > logbin003.sql
 
-----------------------The End----------------------------