Re: Proper syntax of LOAD DATA INFILE
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
Subject
Written By
Posted
November 23, 2013 11:34AM
November 23, 2013 08:50PM
Re: Proper syntax of LOAD DATA INFILE
November 24, 2013 11:19AM
November 25, 2013 10:53AM
November 25, 2013 03:32PM
November 25, 2013 03:51PM
November 26, 2013 08:37AM
November 26, 2013 03:01PM
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.