Proper syntax of LOAD DATA INFILE
I want to load the contents of a tab delimited text file into a table.
LOAD DATA INFILE '/home/xxx/Desktop/parcel_numbers.txt' INTO TABLE tblparcel_numbers FIELDS TERMINATED BY '/t' LINES TERMINATED BY '/r/n'
This command generates error 29 and error 13 "File does not exist"
I'm running MySQL V 5.1 on UBUNTU 12.04. I'm logged in as a user. Using MySQL workbench to execute the LOAD DATA command. I'm connected to the database in which the target table is located. I have been able to add data and tables to the database so that is not the problem here. This syntax has worked on Windows. Where am I going wrong? Should the text file be in some other lication? BTW The LOCAL option is not supported in this version of MySQL.
All response are appreciated.
Marty
Subject
Written By
Posted
Proper syntax of LOAD DATA INFILE
November 23, 2013 11:34AM
November 23, 2013 08:50PM
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.