我对MySQL非常陌生,现在正在Windows上运行它.我正在try 从MySQL中的转储文件还原数据库,但出现以下错误:
$ >mysql -u root -p -h localhost -D database -o < dump.sql
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: 'SQLite format 3'.
我曾try 在ini文件中输入--binary-mode
,但仍然会出现相同的错误.我该怎么办?请帮忙.
UPDATE
正如尼克在 comments 中建议的那样,我试了$ > mysql -u root -p -h localhost -D database --binary-mode -o < dump.sql
次,但结果是ERROR at line 1: Unknown command '\☻'.
次