phpmyadmin INSERT csv file problem

[eplexus]

I'm using MySQL 3.23.25 and phpMyAdmin 2.1.0 and I trying to put an exported CSV file from excel into a table using the Insert textfiles into table> function. The command appears to be completed successfully. I get

The content of your file has been inserted.

SQL-query:
LOAD DATA LOCAL INFILE '\php2' INTO TABLE districts FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\n'

However, no data appears in the table. Any advice?

Pete Jones

[wstringham]

Pete -
This is my first attempt at phpmyadmin.
I am having a similar problem to yours - attempting to 'insert' a CSV generated file into a new database table. The name of the csv file is ta-poplist.csv. When the 'insert text file' option is executed, I get the following error:

SQL-query:

LOAD DATA LOCAL INFILE 'C:\WINNT\php65.tmp' INTO TABLE pop_list FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\n'
MySQL said: File 'c:winntphp65.tmp' not found (Errcode: 2)

1) I don't know where it's getting the c:\winnt\php65.tmp filename from and,
2) the errorline doesn't appear to have a fully defined filename 'c:winntphp65.tmp'. (No backslashes)

Hopefully, you've had some success by now and could offer some suggestions.

Thanks...