problem with upload file to database using phpmyadmin

vasana

Hi I can't upload the file by using phpmyadmin.
My table is like
ID Name phone

and my data in the file is
3,'Peter','05331235'

I selected ',' as a field terminater
and I leave field enclosed by , field escape by and line terminated by as default ( which is " , \ and \r\n respectively ) and I choose LOAD METHOD as DATA LOCAL

When I submit it, it said

Error

SQL-query :

LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\php10.tmp' INTO TABLE asia FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'

MySQL said:

The used command is not allowed with this MySQL version
Back

I use MYSQL version 4.0.13-win. If this command can't be use with this version what I should modify to make it work.
thank a lot

DeltaRho2K

Do you have access to a DOS Shell? If so, try loading it manually to see if it works:

Command follows:
load data local infile "filename.txt" into table table_name;

Or:
load data local infile "filename.txt" into table table_name;

The file needs to be in the same location as your mysql executable. If you are running this on a server, and can access the shell, just remove the word local from the command and adjust the filename path accordingly.

I also recommend removing the quotes...
3,Peter,05331235

And, if that doesn't work, consider using tab delimiting without the quotes:
3 Peter 05331235