changing a lot of information

[salsa_dancer]

I have previously been using MYSQL-front to make changes to my databases but it doesn't seem to let me connect anymore..

I am now using phpmyadmin but I need to replace information in the database with new stuff.. There are about 355 records yet when i try to upload a CSV file using the function I get the following message....

Error

SQL-query :

LOAD DATA LOCAL INFILE '/home/tmp/php2Cg6E2' REPLACE INTO TABLE items_test
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 know the file I am using is in the correct format as I exported it direct from a database that is setup exactly the same....

Any help??

[csn]

What version mysql are you using? You might try upgrading if some part of LOAD DATA isn't supported.