search

brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

I cant load data using LOAD DATA LOCAL INFILE #1807

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I am trying to load data into some tables. In order to do so these are the 
steps that I have done:
1. Create a database using the command Create a new data base
2. I create the table called patsat.tls201_appln
3. I used the following command:

LOAD DATA LOCAL INFILE '/Users/linaescobar/Documents/patstat/raw/tls201_part1' 
INTO TABLE patstat.tls201_appln FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY 
'"' IGNORE 1 LINES ;

I got this message:
File '/Users/linaescobar/Documents/patstat/raw/tls201_part1' not found 
(Errcode: 2)

I have tried with LOCAL DATA INFILE I got Error13
I have allow permission to write in the patstat and the raw folders to all the 
users
I enable the permission using the icon Users and allowing all the privileges
I change the sense of the slash
I also put the file in the usr/local/.. path

What version of Sequel Pro are you using? =1.0.2
What version of OS X are you using? = 10.8.2
What version of MySQL are you connecting to on the server? mysql 5.6.12 osx 
10.7-x86

Can anybody help me.
Best regards,
Lina

Original issue reported on code.google.com by lina.esc...@gmail.com on 6 Sep 2013 at 3:50

GoogleCodeExporter commented 9 years ago 
Hi Lina,

When I try an equivalent command on my machine it works correctly.

If you run the following on the command line:

ls -la '/Users/linaescobar/Documents/patstat/raw/tls201_part1'

...does that list the file correctly?  If not, does the file perhaps have an 
extension the Finder is missing?

Original comment by rowanb@gmail.com on 6 Sep 2013 at 4:34

GoogleCodeExporter commented 9 years ago 
Hello. 

When I run ls -la  /Users/linaescobar/Documents/patstat/raw/ in the terminal it 
lists the file correctly.
I also tried by adding the txt at the end of the file's name but it keeps 
bringing the same error:
File '/Users/linaescobar/Documents/patstat/raw/tls201_part1.txt' not found 
(Errcode: 2)

Original comment by lina.esc...@gmail.com on 9 Sep 2013 at 7:27

GoogleCodeExporter commented 9 years ago 
This issue is now managed at GitHub:
https://github.com/sequelpro/sequelpro/issues/1807

Comments made here will be ignored.

Original comment by schlabbe...@gmail.com on 12 Jan 2014 at 11:48