Aug
02

MySQL: ERROR 1064 (42000) when importing sql-dumps

Victor Farazdagi MySQL, Programming 2009-08-02

Today, I wanted to import quite a huge sql-dump, and got this error. What I was using was:

mysql --user=root -p dbName < sqlDumpName.sql

I was pretty sure about dump's integrity, so after receiving "Error 1064" decided to import using source command:

#mysql --user -p
mysql>use dbName;
mysql>source ./sqlDumpName.sql

This time import went through w/o any issues.

Be Sociable, Share!
    Address: http://www.phpmag.ru/2009/08/02/mysql-error-1064-42000-when-importing-sql-dumps/
    «
    »
    Trackback

    2 comments untill now

    1. Luiz @ 2010-02-12 20:32

      Thanks! Do you know if there are any problem with using this command to import a MySQL3 dump to MySQL5?

    2. Liz @ 2011-07-10 22:47

      I had this same problem, and I *was* importing a mysql3 dump into mysql5. This workaround (using source) worked for me. thanks!

    Add your comment now