Article ID: 2507, created on Oct 29, 2007, last review on May 11, 2014

  • Applies to:
  • Pro Control Panel Linux

AdditionalInformation

View Knowledge
Knowledge ID 1282
Product : WEBppliance for Linux
Version : 3.5.0
Topic : FAQ

Title
MySQL command LOAD DATA LOCAL INFILE does not work

Summary
MySQL command LOAD DATA LOCAL INFILE does not work

Prevention


Details

When using LOAD DATA LOCAL INFILE command with MySQL, MySQL reports the following error:

The used command is not allowed with this MySQL version

RedHat has changed how MySQL is configured in RedHat 7.3.  MySQL was not configured with "--enable-local-infile" option.  This means that mysql clients must explicitly set this option. 

For example, if you are using 'mysql' client via telnet or ssh, then you would connect to your database like this:

mysql -u user -p --local-infile=1 yourdatabase

Note : The user also requires the "File" Privilage (File_Priv)
(MySQL root user has this previlage by default)

Then you will be able to use 'load data local infile' form of the command.

References: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

 


Attachments


Related Knowledge

Related Links
 
Last ModifiedUsageSatisfiedLast Used
8/20/2004 12:53:41 PM28 10/11/2007 6:32:36 AM

4cc899da08664637a8bc437308d3ddd7 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF