Error 2 Mysql 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 error 29 (hy000): file not found (errcode: 13) about Stack Overflow the company Business Learn more about hiring developers or posting ads mysql error code 2 with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow error 2 (hy000): file '' not found (errcode: 2 - no such file or directory) is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up mysql: SOURCE error 2? up vote 30 down vote favorite 2 When file './mysql/user.myd' not found I tried to source for a particular .sql file, namely 'metropolises.sql' that I created and saved previously from a database, the following error is displayed: Failed to open file 'metropolises.sql', error: 2 Any idea what went wrong? mysql share|improve this question edited Feb 4 '13 at 9:48 asked Feb 4 '13 at 9:46 Clueless Gorilla 3192511 1 What does it mean to "try to source for a particuar .sql
(errcode 2 - No Such File Or Directory) Mysql
file"? –Lightness Races in Orbit Feb 4 '13 at 9:51 1 Did you mean "search"? –veljasije Feb 4 '13 at 9:54 I created a table in a database. Now, in order to get the data created, I typed SOURCE metropolises.sql; into the terminal, however the error message as described above showed up. Pretty sure there's no error in the table created. –Clueless Gorilla Feb 4 '13 at 10:22 add a comment| 12 Answers 12 active oldest votes up vote 49 down vote Assuming you mean that you are trying to use the source command in order to execute SQL statements from a text file, the error number given appears to be passed through from the POSIX layer. Therefore, using this resource, we can deduce that the error value of 2 means "no such file or directory". In short, you got the path wrong. Try providing an absolute path, as it's not clear what the current working directory will be in the context of your MySQL server. You may be assuming that it's the working directory of your shell, but it's not obvious that we should expect this to be true. share|improve this answer answered Feb 4 '13 at 9:59 Lightness Races in Orb
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Error 1148 (42000): The Used Command Is Not Allowed With This Mysql Version
policies of this site About Us Learn more about Stack Overflow the load data infile error 13 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users mysql errcode 2 Badges Ask Question x Dismiss 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 takes http://stackoverflow.com/questions/14684063/mysql-source-error-2 a minute: Sign up LOAD DATA INFILE file not found error up vote 0 down vote favorite I have a newbie MySQL question: I keep getting an error 29 that says file is not found with the following syntax and I cannot figure out why: LOAD DATA INFILE 'C:/Users/rkartj2/Desktop/LOINCSUNQUESTV2.txt' INTO TABLE xiao FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' IGNORE 1 http://stackoverflow.com/questions/30649226/load-data-infile-file-not-found-error ROWS; FYI - Table xiao has been created in MySQL 5.7 and LOINCSUNQUESTV2.txt was an Excel spreadsheet created on a Windows machine. mysql share|improve this question edited Jun 4 '15 at 16:45 TobyLL 1,5091719 asked Jun 4 '15 at 16:24 rkartje 1 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote While I have not used version 5.7 of Mysql yet, the error you are receiving is the same in previous versions. ERROR 29 (HY000): File 'C:/Users/rkartj2/Desktop/LOINCSUNQUESTV2.txt' not found This may seem a bit misleading to a newb especially since you can go to your Desktop and see that the LIONSUNQUESTV2.txt file is there. I see one of two possibilities here which is either that Mysql does not have permissions to access the file from the current directory or that it does not know that the file is on your local server. You can try using LOAD DATA LOCAL INFILE. From dev.mysql If that does not work, you need to move file to a location that mysql has access to, such as the Mysql data directory. I
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social https://ubuntuforums.org/showthread.php?t=822084 Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! http://forums.devshed.com/mysql-help-4/load-data-local-infile-error-code-2-file-found-180473.html Ubuntu Ubuntu 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 found error" when the file exists Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place not found 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 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 file not found 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 of the mysqld process, not your privs. Try this: Code: chmod o+rx /home/calsaverini chmod o+r /home/calsaverini/data.txt Then try to load your file as before. Hal Pomeranz, Deer Run Associates [[ Various Linux/Unix related documents ]] [[ Command-Line Kung Fu blog ]] Adv Reply Reply With Quote June 9th, 2008 #3 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 Re: MySQL return a "f
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases MySQL Help LOAD DATA LOCAL INFILE - Error Code 2 - File Not Found Thread: LOAD DATA LOCAL INFILE - Error Code 2 - File Not Found Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread September 4th, 2004,04:51 PM #1 No Profile Picture R4ABigman View Profile View Forum Posts Contributing User Devshed Newbie (0 - 499 posts) Join Date Apr 2004 Location Warrington, NW England Posts 42 Rep Power 13 LOAD DATA LOCAL INFILE - Error Code 2 - File Not Found Hi everyone, I've searched through the internet, and this forum before posting this. Also I've read the MySQL manual over and over, but yet I still cannot figure out what I'm doing wrong! I'm trying to load data from my computer (client) to a database based on the internet (server). I have had this working fine (without the LOCAL addition) when my computer was both client and server, so I can't see where I'm going wrong. Heres the SQL: Code: LOAD DATA LOCAL INFILE 'C:\\\\My Documents\\\\...Lengthy file path...\\\\C6M04_70.X02' REPLACE INTO TABLE examcomponent FIELDS TERMINATED BY '' LINES TERMINATED BY '\r\n' The error: File 'C:\\My Documents\\...Lengthy file path...\\C6M04_70.X02' not found (Errcode: 2) I have also tried this: Code: LOAD DATA LOCAL INFILE 'C:\\My Documents\\...Lengthy file path...\\C6M04_70.X02' REPLACE INTO TABLE examcomponent FIELDS TERMINATED BY '' LINES TERMINATED BY '\r\n' The error: File 'C:\My Documents\...Lengthy file path...\C6M04_70.X02' not found (Errcode: 2) I've also tried getting rid of the REPLACE and LOCAL bits, but apparently to no avail. If anyone can suggest anything, or have any comments, they are welcome. Thanks in advance. Faq Reply With Quote September 4th, 2004,09:42 PM #2 Guelphdad View Profile View Fo