470,602 Members | 1,503 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

Problem with 'load data local infile'

Hello,

I am running MySQL 4.0.16. I get the error 'The used command is not allowed
with this MySQL version' when using the 'load data local infile' command.
The local_infile is ON; the select * into outfile works but load data local
infile does not. What am I doing wrong?

Thanks!

DETAILS --->

lalo:/home/rkapur/content_mgt >
cat x
/* ============= code_master ============= */
use content_mgmt;
select * into outfile "/home/rkapur/content_mgmt/code_master.txt"
from code_master where cm_id > 4;
use rktest;
load data local infile "/home/rkapur/content_mgmt/code_master.txt"
into table code_master;

lalo:/home/rkapur/content_mgt >
mysql -u root -p < x
Enter password:
ERROR 1148 at line 6: The used command is not allowed with this MySQL
version
lalo:/home/rkapur/content_mgt >

================================

mysql> show local variables like "local%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set (0.00 sec)
Jul 20 '05 #1
0 1743

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Pieter Van Waeyenberge | last post: by
14 posts views Thread by Bruce A. Julseth | last post: by
2 posts views Thread by Pieter Van Waeyenberge | last post: by
3 posts views Thread by Otto | last post: by
reply views Thread by Donald Tyler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.