August 15th, 2000, 02:59 PM
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!
August 18th, 2000, 05:11 PM
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).]