Hello I'm new to MySQL and struggling with all sorts of things.
First things first: (hope someone can help) I'm running MySQL 3.23.53, PHP 4.2.3, Apache 1.3.27 and phpMyAdmin 2.3.2 on Solaris 8. All seemed ok until the site administrators tried to upload a csv file into the database through phpMyAdmin. The following error occurred : --------------------------------------------------------------- Error SQL-query : LOAD DATA LOCAL INFILE '/var/tmp/phpHRaW9g' INTO TABLE `branches` FIELDS TERMINATED BY '' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' MySQL said: The used command is not allowed with this MySQL version I have started mysql with the '-local-infile=1' option as per the MySQL docs but still doesn't work. Can anybody help?? Peter Fletcher Peter Fletcher Technical Analyst 01765 694295 --------------------------------------------------------------------- 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
