MySQL Forums
Forum List  »  Newbie

Re: Proper syntax of LOAD DATA INFILE
Posted by: Martin McGlensey
Date: November 24, 2013 11:19AM

John,

Thanks for your response. I'm using MySQL version 5.5.34-0 on Ubuntu 12.04 LTS and MySQL Workbench. I've tried the following with no success:

1 - Change permissions so all cound have rwx priviledges from /home on down
2 - Changed owner to mysql
3 - Edited AppArmor
4 - Placed txt file in /tmp directory
(Fixes found on the net)

All attempts report Error 29 and error 13 "File does not exist". I have been entering the full path each time. I've tried it in terminal mode after specifing user password and database same result.

Tried mysqlimport -u root -p HOA_DATA file. That returned the same errors.
I have not been able to find out what error 29 is. Cannot find a MySQL error table on the net. There is something basic going on here that we're all missing.

Marty

Options: ReplyQuote


Subject
Written By
Posted
Re: Proper syntax of LOAD DATA INFILE
November 24, 2013 11:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.