|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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).] |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Import .txt or .csv into MySql database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|