MySQL Forums
Forum List  »  Newbie

Proper syntax of LOAD DATA INFILE
Posted by: Martin McGlensey
Date: November 23, 2013 11:34AM

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

Options: ReplyQuote


Subject
Written By
Posted
Proper syntax of LOAD DATA INFILE
November 23, 2013 11:34AM


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.