Thanks Brent,
Yes, I too can import with LOAD DATA and mysqlimport, but the thing that's
irritating is that I have to create the tables first in order to import the
data in either case.
With a 'regular' import from a dumped table, mysql should be able to read
the SQL statements within the dump f
Hi all,
I'm having a problem importing a dump file in Mac OSX. I created the dump
from phpMyAdmin, and tried to import it in these 2 ways with the following
results:
>From mysql command line:
Mysql> database_name < dumped_file;
Result: ERROR 1064: You have an error in your SQL syntax near 'data