I'm having problems with php scripts that use 'LOAD DATA LOCAL INFILE'. Each time I run a script, I get an error in the server log saying MySQL query failed: "LOAD DATA LOCAL INFILE ...." : The used command is not allowed with this MySQL version.
We're using php version 4.1.2 and MySQL 3.23.49, both installed using RedHat (7.3) package managers. MySQL wasn't explicitly configured using '--enable-local-infile' at installation. I've tried including 'local-infile=1' in the my.cnf file under [mysql], [mysqld], [mysql.server] etc., and this has enabled use of 'load data local infile' from the command line, but still not in php scripts. Removing the word LOCAL from the php scripts results in a different error - I get a message saying that access is denied for the user instead. I would be very grateful to hear from anyone who knows how to get round this problem. Regards, Stephen ------------------------------------------------- Stephen Park Dept. Clinical Pharmacology, Royal College of Surgeons in Ireland 25 St. Stephen's Green, Dublin 2, Ireland E-mail: [EMAIL PROTECTED] Web: http://www.sdepark.net/ Tel: +353 (0)1 240 9515 Fax: +353 (0)1 240 9516 ------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
