操作系统 Windows
mysql 版本 5.7
通过Windows命令进行操作,cd mysql安装目录下的bin路径
导出语句: mysqldump -h localhost -u Username -p DBname Tablename > filename.sql
导入语句: mysql -h localhost -u Username -p DBname --binary-mode < filename.sql
报错:
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.
处理:原因应该是导出文件为二进制格式,导入时系统按照UTF8格式打开报错, 利用高级编辑工具 ultraEdit 打开sql文件,另存为 UTF8格式,再次执行导入语句后正常。
mysql无法启动时的操作参考
http://blog.csdn.net/AfirSraftGarrier/article/details/47276249
相关命令参考
http://www.cnblogs.com/zeroone/archive/2010/05/11/1732834.html
http://blog.chinaunix.net/uid-20761674-id-136275.html