mysql导入数据失败解决方法

Posted on 2015-12-03

ERROR at line 2104889: ASCII ‘\0’ appeared in the statement, but this is not allowed unless option –binary-mode is enabled and mysql is run in non-interactive mode. Set –binary-mode to 1 if ASCII ‘\0’ is expected.

解决方法:

开启二进制日志功能

vim /etc/mysql/my.cnf

[client]

binary-mode = 1

service mysql restart