用MYSQL BACKUP工具备份出来的SQL,如何还原?
里面中文全是乱码直接用MYSQL 命令还原出错
ERROR 1064 (42000) at line 83: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near '1','','',0,0),(38,34,'JAZLYNN','[email protected]','HTTP://WWW.BING.COM/'
,'110.' at line 1
里面中文全是乱码直接用MYSQL 命令还原出错
ERROR 1064 (42000) at line 83: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near '1','','',0,0),(38,34,'JAZLYNN','[email protected]','HTTP://WWW.BING.COM/'
,'110.' at line 1
另外两个MYSQL的版本是什么?
用MYSQL < XX.SQL恢复的
MYSQL的版本是一样的,都是WIN的5.XX。
现在只有一个这样的备份文件了,没法再去备份了。
乱码的备份,希望能帮忙解决一下,并给一个方案,谢谢!
不过这个工具没有还原的功能,现在用MYSQL命令还原不成功:(