Error 2 Hy000 File Not Found
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or error 29 hy000 file not found errcode 13 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Error 3 Hy000 Error Writing File
Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only
Error 1148 (42000):
takes a minute: Sign up load data local infile ERROR 2 file not found up vote 5 down vote favorite I've been ramming my face against this sql error for about 45 minutes, and I have a feeling it's going
Error 29 (hy000) File Relay-bin Not Found (errcode 2)
to be something silly. I'm trying to load a .txt file into my database, which is on a server elsewhere. I'm using putty on windows 7. The sql call I am using is the following: LOAD DATA LOCAL INFILE "C:/Users/Sam/Desktop/students_data.txt" INTO TABLE students; The response I get is ERROR 2 (HYOOO): File 'C:/Users/Sam/Desktop/students_data.txt' not found (Errcode:2) If anyone could shed some light on this that'd be extravagant. I already tried switching the / to \ and using single quotes, etc., but file './mysql/user.myd' not found nothing seems to work. The file path is copied by shift+clicking the actual file and pasting it. mysql load share|improve this question asked Oct 2 '11 at 1:08 samuel 1011112 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote I have found a solution. First delete the word LOCAL from the sql statement. Second - place your file into MySQL DATA folder usually - bin/mysql/msql5.5.8/data/and your DB with which you are working. It worked for me. You might want to check your MAX_FILE upload number in php.ini file if file is large. share|improve this answer answered Dec 16 '11 at 3:38 prkarpi 362 i am working with MySQL and the first solution is okay.. but why we need php.ini file and where can i found php.ini, @prkarpi –saikiran May 13 '14 at 13:05 Have done the above procedure still facing the error.. given file permissions to full control and copied file to c>programdata>mysql>mysqlserver 5.6>data>sample . please help. –saikiran May 13 '14 at 13:19 my file is nearly has 2 GB of data. –saikiran May 13 '14 at 13:19 add a comment| up vote 2 down vote Removing the word LOCAL seemed to work for me; try it out! share|improve this answer edited Nov 22 '11 at 16:55 user212218 answered Nov 22 '11 at 16:47 ashga 221110 add a comment| up vote 0 down vote I had this problem too, t
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or #1148 - the used command is not allowed with this mysql version posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss mysql error code 2 Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only error 29 hy000 file not found errcode 13 permission denied takes a minute: Sign up LOAD DATA INFILE does not work up vote 5 down vote favorite 1 I am running MySQL on my Ubuntu machine. I checked /etc/mysql/my.cnf file, it shows my database temporary directory: ... basedir = /usr datadir http://stackoverflow.com/questions/7623984/load-data-local-infile-error-2-file-not-found = /var/lib/mysql tmpdir = /tmp ... As it shows, my MySQL server temporary directory is /tmp . I have a students.dat file, the content of this file is like following: ... 30 kate name 31 John name 32 Bill name 33 Job name ... I copied the above students.dat file to /tmp directory. Then, I run the following command to load the data from students.dat file to the students table in my database: LOAD DATA INFILE '/tmp/students.dat' INTO TABLE school_db.students FIELDS http://stackoverflow.com/questions/8471727/load-data-infile-does-not-work TERMINATED BY '\t' LINES TERMINATED BY '\n' (student_id, name, attribute) But I got the error message in MySQL console: ERROR 29 (HY000): File '/tmp/students.dat' not found (Errcode: 13) Why mysql can not find the students.dat file though the file is under mysql temporary directory? P.S. The students table is like following (there are already 4 records in the table before run the LOAD DATA INFILE... query): mysql> describe students; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | student_id | int(11) | YES | | NULL | | | name | varchar(255) | YES | MUL | NULL | | | attribute | varchar(12) | YES | MUL | NULL | | | teacher_id | int(11) | YES | | NULL | | +-------------------+--------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql sql database share|improve this question asked Dec 12 '11 at 8:43 Mellon 9,76246139226 add a comment| 2 Answers 2 active oldest votes up vote 7 down vote accepted Have a look at the sixth post from file not found error. It seems if you specify LOAD DATA LOCAL INFILE should work (They added the LOCAL keyword) share|improve this answer answered Dec 12 '11 at 9:03 cristian 6,18112635 LOCAL INFILE is a workaround. A solution to use it as is might be to change the file ownership to that of mysql. Alternatively, I have two installs of the same MySQL server and
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community https://ubuntuforums.org/showthread.php?t=822084 Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu http://board.phpbuilder.com/showthread.php?10393741-RESOLVED-LOAD-DATA-INFILE-mysql-says-file-not-found-but-it-s-definitely-there Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Development & Programming Programming Talk MySQL return a "file not not found found error" when the file exists Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 16 Thread: MySQL return a "file not found error" when the file exists Thread hy000 file not Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode June 8th, 2008 #1 calsaverini View Profile View Forum Posts Private Message Visit Homepage 5 Cups of Ubuntu Join Date Dec 2006 Location São Paulo, Brazil Beans 30 DistroUbuntu 10.10 Maverick Meerkat MySQL return a "file not found error" when the file exists Hi, I'm having a problem with mysql. When I try to load a file in a table like this: Code: LOAD DATA INFILE "/home/calsaverini/data.txt" INTO TABLE CMIG4; It returns the error: Code: ERROR 29 (HY000): File '/home/calsaverini/data.txt' not found (Errcode: 13) But the file IS THERE! Anyone have any clue what the problem could be? Adv Reply Reply With Quote June 8th, 2008 #2 HalPomeranz View Profile View Forum Posts Private Message Visit Homepage Quad Shot of Ubuntu Join Date May 2008 Location Eugene, OR, USA Beans 435 Re: MySQL return a "file not found error" when the file exists Permissions problem perhaps? The file is going to be read in with the privs o
but it's definitely there If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: [RESOLVED] LOAD DATA INFILE - mysql says file not found but it's definitely there Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-24-2015,11:52 AM #1 sneakyimp View Profile View Forum Posts Visit Homepage Senior Member Join Date Apr 2003 Location Flanders Fields Posts 5,676 [RESOLVED] LOAD DATA INFILE - mysql says file not found but it's definitely there I'm trying to load a CSV file I have generated from PHP into a db table on my workstation. For some reason, mysql is complaining that the file is not found. I am absolutely certain I have specified the path to the file properly and I'm absolutely certain that the file is readable (774). I believe this may have something to do with AppArmor and have edited the config and reloaded it with no luck. Can someone give me a hint about how to get this file imported? I've tried importing it via phpmyadmin which seems to work VERY VERY VERY VERY slowly and keeps timing out. The command: Code: LOAD DATA INFILE '/path/to/digital_raw.txt' INTO TABLE data_digital_raw FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; it returns this error: Code: ERROR 29 (HY000): File '/path/to/digital_raw.txt' not found (Errcode: 13) But I know for a fact the file is there and readable by any user on my machine: Code: $ ls -al /path/to/digital_raw.txt -rw-rw-r-- 1 sneakyimp sneakyimp 30083137 Jun 24 07:53 /path/to/digital_raw.txt I read here about how AppArmor settings can prevent a mysql load for some stupid reason and I've even gone through the trouble of editing the app armor