Hi Elliot, It is in the docs, just a little bit further down the page 8-)
LOCAL works only if your server and your client both have been enabled to allow it. For example, if mysqld was started with --local-infile=0, then LOCAL does not work. See Section 5.6.4, "Security Issues with LOAD DATA LOCAL". Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Elliot Kleiman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 8:12 AM To: mysql@lists.mysql.com Subject: LOAD DATA INFILE Syntax Hi mysql-list, I just installed, +------------+ | version() | +------------+ | 5.0.16-log | +------------+ Here is what I am testing out: (simple table and data) % echo 'a b c d' > testfile mysql> CREATE TABLE `test` ( -> `fe` VARCHAR( 2 ), -> `fi` VARCHAR( 2 ), -> `fo` VARCHAR( 2 ), -> `fum` VARCHAR( 2 ) -> ); Query OK, 0 rows affected (0.00 sec) mysql> load data local infile './test' into table test; ERROR 1148 (42000): The used command is not allowed with this MySQL version Q: What am I doing wrong(missing)? { I did not see it in the documentation online } http://dev.mysql.com/doc/refman/5.0/en/load-data.html Thanks, Elliot P.S. The same command works fine in previous versions of MySQL. __________________________ WizardsWorks Cluster http://www.wizardsworks.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
