Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2015
    Posts
    3

    Unanswered: importing files into mysql

    Hello. I'm trying to import text files into SID (xampp). I'm an absolute beginner and I'm using a SQL book that gives instructions for importing files into MySQL. I'm getting the error below.

    Warning: PDOStatement::execute(): LOAD DATA LOCAL INFILE forbidden in /Applications/XAMPP/xamppfiles/htdocs/sid/sid.php on line 259

    This is one piece of the code.

    LOAD DATA
    LOCAL INFILE '/Users/alexmartino/Desktop/textfiles/calendar.txt'
    INTO TABLE calendar
    LINES TERMINATED BY '\r\n'
    IGNORE 1 LINES

    I have a mac computer...not sure if that changes anything. Please help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2015
    Posts
    3

    not helpful

    Lol. That doesn't really help me. I'm a beginner, so I don't understand the majority of those posts. I need someone to explain in English what I need to do. I love it when people post google, as if someone who can navigate to a forum and register for that forum, doesn't know how to use google.

Posting Permissions

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