5.5 导出的数据导入到5.6的问题
mysql 5.5导出数据语句:/opt/mysql/bin/mysqldump --all-databases --opt -uroot -p'test' > all.sql
用
/opt/mysql/bin/mysql -uroot -p'test' < all.sql
导入提示:
ERROR at line 2445: 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. Query: 'INSERT INTO `cdb_avatar` VALUES (
于是按照http://www.itpub.net/thread-1783850-1-1.html加了--binary-mode=1
/opt/mysql/bin/mysql --binary-mode=1 -uroot -p'test' < all.sql
提示:
ERROR 1064 (42000) at line 2446: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
' at line 1
这咋破? 看 是 前后2行报的错.......ths
语法问题 同版本倒入。
页:
[1]