开发者

MySQL error with load data infile fixed by reboot?

开发者 https://www.devze.com 2023-02-25 15:49 出处:网络
I\'ve got an Ubuntu server where there\'s a task to import a csv file.Generally everything runs smoothly but every once in a while I get an error:

I've got an Ubuntu server where there's a task to import a csv file. Generally everything runs smoothly but every once in a while I get an error:

Mysql::Error: 
The used command is not allowed with this MySQL version: 
\n LOAD DATA LOCAL INFILE 

I don't think the error is accurate as the same import script runs most of the time. Rebooting the server and rerunn开发者_如何学Going the script "fixes" the issue. Still, that doesn't seem like a long-term solution. What else could be causing this?


what version of mysql do you have ?

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

try reading this thread, it may be helpful. The guy seemds to have similar problem solved.

http://forums.digitalpoint.com/showthread.php?t=65260

0

精彩评论

暂无评论...
验证码 换一张
取 消