Search code examples
mysqldump

PHPMYADMIN error while importing big sql dump

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.

Solution

  • 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.