SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Fluffy Kitten Programmer~ Elledan's Avatar
    Join Date
    Jun 2000
    Location
    Netherlands
    Posts
    1,356
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When I try to load a text file with the table content using PHPMyAdmin, I get this error:

    SQL-query:

    LOAD DATA LOCAL INFILE 'D:\Programs\PHP\uploadtemp\php103.tmp' REPLACE INTO TABLE archive FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'

    MySQL said: File 'd:programsphpuploadtempphp103.tmp' not found (Errcode: 2)

    The content of the text file:

    1;This is a test heading;Normally, here should be an article;1\n
    2;This is the second test heading;Here will be an article as well;1\n

    www.nyanko.ws - My web-, software- and game development company.
    www.mayaposch.com - My personal site and blog.

  2. #2
    Fluffy Kitten Programmer~ Elledan's Avatar
    Join Date
    Jun 2000
    Location
    Netherlands
    Posts
    1,356
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nevermind, I used tab-delimited text files and it worked perfectly (thanks Adam!).
    www.nyanko.ws - My web-, software- and game development company.
    www.mayaposch.com - My personal site and blog.


Bookmarks

Posting Permissions

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