#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    TX
    Posts
    38
    Rep Power
    15
    I keep getting an error message when I try to import data into my database. The error message is "Error: Can't get stat of '/home/explore/addressbook.csv' (Errcode: 13), when using table: addressbook"

    I tried importing the data 2 ways and get the same error message

    1. mysqlimport -h localhost -u myusername -pmypassword addressbook /home/explore/addressbook.csv fields-terminated-by=;

    2. load data infile 'addressbook' into table addressbook;

    Thanks in advance!
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    20
    Rep Power
    0
    It is most likely a unix permissions issue, and that mySQL doesn't have permission to access the file. Or, it could also be that it can't find the file. Note that when using LOAD DATA INFILE you should include the complete path, including extension.

    [This message has been edited by elin (edited August 18, 2000).]

Similar Threads

  1. Import .txt into MySQL
    By ZacDee in forum MySQL Help
    Replies: 1
    Last Post: February 14th, 2004, 01:01 PM
  2. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 04:11 PM
  3. Replies: 3
    Last Post: February 11th, 2004, 08:30 AM
  4. MySQL import issue - huge file
    By Gnosis in forum MySQL Help
    Replies: 9
    Last Post: February 2nd, 2004, 07:49 PM
  5. MYSQL database
    By isheikh in forum MySQL Help
    Replies: 3
    Last Post: January 14th, 2004, 10:58 PM

IMN logo majestic logo threadwatch logo seochat tools logo