Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Help - with LOAD DATA INFILE

    I have a 2 part question.

    First, I simply can't get the LOAD DATA INFILE command to work. I'm trying to load a txt file into a very simple database. I get the following error When I input:

    LOAD DATA INFILE "cars.txt" INTO TABLE cars

    I get this error:
    Access denied for user: 'xwreck@localhost' (Using password: YES)

    When I input:


    I get this error:
    Error 1148: The used command is not allowed with this MySQL version

    Any ideas on why this doesn't work for me?

    Now, the 2nd question I had is: Can the file I reference in the LOAD DATA query be a full URL: ex:

    Thank you for your help.

  2. #2
    Join Date
    Nov 2003
    You have to have the FILE privilege to use the LOAD DATA command,
    and even if you have the privilege this feature
    might be disabled with --local-infile=0 when MySQL was first

    Try logging on to MySQL as root, then issue the
    LOAD DATA command.
    Second, I find it helpful to specify the full path name
    to the file (e.g. "C:\tmp\somefile.txt").
    You might want to check out section 6.4.8 of the MySQL
    manual for further info on LOAD DATA.

Posting Permissions

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