Mysql ERROR: ASCII '\0' while importing sql file on linux server
39,737
Solution 1
Try something like :
mysql -u root -p -h localhost -D database --binary-mode -o < dump.sql
and make sure your sql file is not zipped.
Solution 2
I encountered this problem,the sql file was in a valid ISCII format, I solved as the following:
1- in shell use file
command to detect type of data contained in the dump file:
file db.sql
got output like following:
db.sql: Little-endian UTF-16 Unicode text, with very long lines, with CRLF line terminators
2- convert the existing dump file to UTF8 (ASCII) using iconv:
iconv -f utf-16 -t utf-8 db.sql > db_utf8.sql
then import the new file.
Solution 3
I just had this issue because the file was gzipped. I unzipped it and had no further issue.
Author by
zish
Updated on June 25, 2020Comments
-
zish about 4 years
I am getting following error while importing sql file
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: ''.
HELP NEEDED...!!