PHP Magazine

Авг

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.

MySQL

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?