PHPMYADMIN error while importing big sql dump

Question

I am trying to import a big SQL dump into my mysql database but I got an error which the following. Via PHPMYADMIN interface I didn't manage to import it, it says too voluminous. So I tried with command line: mysql -uroot -p dbsnp < SNP_HGVS.sql but I got this error: 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:d�L'.`

Do you know how to resolve this issue? Many thanks.

Is it okay to use `mysql -uroot -p` instead of `mysql -u root -p`? — rhavendc, Apr 19 '16 at 09:39
Are you sure the dump is formatted correctly for MySQL (i.e. coming from another mysql source of similar settings)? Are you sure your server you're importing the data to has similar settings to the source of the SQL dump? — Walt Sorensen, May 03 '16 at 02:25
@WaltSorensen, Hi Walt, actually, the dump wasn't correctly setup. I re-extract the archive and now it works. — user979974, May 03 '16 at 07:03

score 0 · Answer 1 · edited May 23 '17 at 10:28

0

It seems to me the character of dump file is not UTF-8.As per the error you need to --binary-mode on. Please check the link: [Enable binary mode while restoring a Database from an SQL dump

edited May 23 '17 at 10:28

Community

1
1

answered Apr 18 '16 at 07:13

Dipanwita Kundu

1,637
1
9
14

I took a look at your link, when I add option `--binary -o` it displays:`ERROR at line 1: Unknown command '\O'.` any idea? – user979974 Apr 18 '16 at 12:31

score 0 · Accepted Answer · answered May 04 '16 at 16:01

0

As per clarification question and comments:

The source SQL dump was not correctly setup and formatted for MySQL. Re-dumping the data with the correct MySQL configuration/format resolves the issue.

answered May 04 '16 at 16:01

Walt Sorensen

381
3
14

PHPMYADMIN error while importing big sql dump

2 Answers2