MySQL Forums :: Newbie :: Proper syntax of LOAD DATA INFILE


Advanced Search

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 Martin McGlensey 11/23/2013 11:34AM
Re: Proper syntax of LOAD DATA INFILE John Smith 11/23/2013 08:50PM
Re: Proper syntax of LOAD DATA INFILE Martin McGlensey 11/24/2013 11:19AM
Re: Proper syntax of LOAD DATA INFILE Martin McGlensey 11/25/2013 10:53AM
Re: Proper syntax of LOAD DATA INFILE Martin McGlensey 11/25/2013 03:32PM
Re: Proper syntax of LOAD DATA INFILE Barry Galbraith 11/25/2013 03:51PM
Re: Proper syntax of LOAD DATA INFILE Martin McGlensey 11/26/2013 08:37AM
Re: Proper syntax of LOAD DATA INFILE Barry Galbraith 11/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.