Load Data Local Infile

jamal

10-27-2002, 01: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, 01: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.