Load Data Local Infile

jamal · 10-27-2002, 02:06 AM

Can anyone help me please ?? MySQL gave an error message that the command "LOAD DATA LOCAL INFILE is not allowed in the version of MySQL that I am using.
I use mySQL version 3.23.52
Please can anyone give a command that does the same job in this version of mySQL??
Thanks in Advance.
Jamal

bcarl314 · 10-30-2002, 02:05 PM

I had this one just the other day. You need to open mysql like this:

$> mysql -local_infile=1

This should enable that function. By defualt, mysql disabled this function because they thought it was an exploitable security hole.

10-27-2002, 02:06 AM	PM User \| #1
jamal New to the CF scene Join Date: Oct 2002 Location: england Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts	Load Data Local Infile Can anyone help me please ?? MySQL gave an error message that the command "LOAD DATA LOCAL INFILE is not allowed in the version of MySQL that I am using. I use mySQL version 3.23.52 Please can anyone give a command that does the same job in this version of mySQL?? Thanks in Advance. Jamal

10-30-2002, 02:05 PM	PM User \| #2
bcarl314 Mega-ultimate member Join Date: Jun 2002 Location: Winona, MN - The land of 10,000 lakes Posts: 1,651 Thanks: 1 Thanked 21 Times in 20 Posts	I had this one just the other day. You need to open mysql like this: $> mysql -local_infile=1 This should enable that function. By defualt, mysql disabled this function because they thought it was an exploitable security hole. __________________ Drop shippers directory -::- Create a free online birthday or Christmas wish list -::- Create accessible online surveys -::- accessible drop down menu -::- Golf Birthday Gifts, golf accessories, and more -::- Learn to flip web sites Zend Certified Engineer

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: