导入mysql文件提示“ASCII '\0' appeared in the statement”
来源:互联网 发布:淘宝靠谱的奢侈品代购 编辑:程序博客网 时间:2024/06/10 22:17
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: '?-'.
后来百度了一下,发现这样一个回答:
The reference to --binary-mode (introduced in MySQL 5.6.3) is probably a distraction.
It doesn't sound like you're dealing with a mysqldump output file, there. Try the file utility.
shell> file dumpfile.sqldumpfile.sql: ASCII text
If you don't get the ASCII text response, you're dealing with either something that isn't a dump file from mysqldump at all, or you're dealing with something that's been compressed (with gzip or bzip2, for example), which you'd need to uncompress before piping it into mysql.
大意是说,错误信息里的--binary-mode极具迷惑性。事实上,这并不意味着你的 sql文件里包含ASCII字符。可以先通过file命令查看该文件的字符类型。
于是将该sql文件上传至Linux服务器上,执行了一下file:
[root@localhost ~]# file dafanshu_db.sql
dafanshu_db.sql: Little-endian UTF-16 Unicode text, with very long lines, with CRLF line terminators
结果很明显,这里面并没有什么ASCII字符,所以即使将mysql设置成--binary-mode,也无济于事,是文件格式的问题。
后来无意中发现,用more查看这个文件,无法正常显示任何内容,用vi却可以。这更加说明,这个sql文件绝对不是普通的文本文件。
最后想起,这个sql文件是在powershell里导出来的。于是尝试在cmd下重新导一次,然后再导入,就正常了。这坑爹的powershell。。。
- 导入mysql文件提示“ASCII '\0' appeared in the statement”
- 【mysql】 mysql备份还原时发生异常:导入mysql文件提示“ASCII '\0' appeared in the statement”
- TP5 提示Namespace declaration statement has to be the very first statement in the script
- mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause
- 使用MySQL-Front导入SQL文件提示:SQL execution error # 1064. Response from the database:
- the for statement in python
- Red Bottom Shoes Sale the term appeared in the late 19th century. "Stan" was originally "place".
- txt文件导入Mysql提示导入成功但是只有一条ID为0的无效数据
- Understanding the 'using' statement in C#
- The merge statement in oracle 9i
- Intro:The if statement in php
- Intro:The switch-case statement in php
- Variable initialization in the switch statement
- navicat for mysql 导入xlsx,提示 无法打开文件
- mysql创建触发器错误提示:Can not update in stored function/trigger already used by statement invoked
- MyEclipse导入失败,提示Some projects cannot be imported because they already exist in the workspace
- Eclipse无法导入项目(提示can not import* because the project name is in user)
- java 导入时 提示 some projects were hidden because they exist in the workspace directory。
- 什么是POD数据类型?
- ajax基础详解
- OPENSSH秘钥管理服务
- 51nod 1476 括号序列的最小代价
- 构造方法,方法重载
- 导入mysql文件提示“ASCII '\0' appeared in the statement”
- 视觉工程师必备干货工业相机50问
- 一个屌丝程序猿的人生(七十六)
- AES的S盒
- WPF学习笔记---图片旋转(2)
- ajax的简单使用——get&post的实现(2)
- C#初识6 多态之虚方法(virtual,override)
- 11.14
- 035day(枚举例题(完美立方)的学习和引用的学习)