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

    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:

    LOAD DATA LOCAL INFILE "cars.txt" INTO TABLE cars

    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: http://www.yahoo.com/file.txt

    Thank you for your help.

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    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
    started.

    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
  •