PDA

View Full Version : 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.