Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    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

  • #2
    Mega-ultimate member
    Join Date
    Jun 2002
    Location
    Winona, MN - The land of 10,000 lakes
    Posts
    1,855
    Thanks
    1
    Thanked 45 Times in 42 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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •