Problem importing CSV

hman · January 6th, 2007, 09:13 AM

Hi,

I am a complete newbie to MySQL!

I am trying to import a CSV file using phpMyAdmin.

I have uploaded the CSV file via FTP to the root directory on my external server (GoDaddy).

Then in phpMyAdmin I ran the following query:

Code:

load data local infile 'resdatatest2.csv' into table tblNewsletterSubs
fields terminated by ','
lines terminated by '\n'
(ID, EcastID, Email, ActiveSub)

phpMyAdmin then says the file has imported but with Inserted rows: -1
so no data is being imported. It should have imported 284 rows, not -1 !

Here is my table structure:
Field Type
ID int(7)
EcastID int(3)
Email varchar(75)

Please help