【JavaWeb】Mysql source 恢复数据出错解决

来源:互联网 发布:五毛特效是什么软件 编辑:程序博客网 时间:2024/06/14 13:27

MySql cmd恢复数据库时报错:

ERROR: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: 'ÿþ-'.Bye

原因:因为源sql文件是powershell导出的,所以用cmd导入会有问题,将源文件用cmd导出即可。