Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2009
    Posts
    4

    Unanswered: Error Loading Text File into Table

    Hi,
    I keep getting the error message:

    ERROR 2 (HY000): File 'fileName.txt' not found
    whenever I try to load data from a text file (saved on path C into a table like this:

    LOAD DATA LOCAL INFILE 'fileName.txt' INTO TABLE tableName;
    I've also tried:

    LOAD DATA LOCAL INFILE 'C:/fileName.txt' INTO TABLE tableName;
    and

    LOAD DATA LOCAL INFILE '/fileName.txt' INTO TABLE tableName;
    but I keep getting the same error.

    Now I've been reading about the security issues related to LOAD DATA LOCAL at:

    Code:
    http://dev.mysql.com/doc/refman/5.1/en/load-data-local.html
    which suggested that LOAD DATA LOCAL can be enabled using:

    --local-infile[=1] option
    My question is, how do I input this command?

    Any assistance will be appreciated. Thanks.
    Last edited by 01010011; 11-14-09 at 23:25. Reason: Include a link

Posting Permissions

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