Inserting Data in MySQL via file error

[whodaman]

Hi all, I tried excuting this command in MySQL using myPhpAdmin. I got this error:

SQL-query :  

LOAD DATA LOCAL INFILE 'C:\\WINNT\\TEMP\\php25CE.tmp' INTO TABLE `data_pprc` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' 

MySQL said: 

The used command is not allowed with this MySQL version

My File looks like this:

0;0;4;13
0;0;5;13
0;0;6;13
0;0;7;13

My fields are:

value; pp_row; pp_col; yearMonth

I'm using MySQL 4.0.13. Does this version support adding data as a file? Does anyone know what is wrong?

Thank you in advance.

 

[sleipnir214]

If the datafile resides on the filesystem of the MySQL server, drop the "LOCAL" keyword.

The "LOCAL" optional keyword tells your client software to transfer the data to the server through the MySQL connection.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!