Error 2 File Not Found Mysql
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 mysql load data infile file not found windows more about Stack Overflow the company Business Learn more about hiring developers or
(errcode 2 - No Such File Or Directory) Mysql
posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow error 2 (hy000): file '' not found (errcode: 2 - no such file or directory) Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up LOAD DATA INFILE file not found error up vote mysql error code 2 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 ROWS; FYI - Table xiao has been created in MySQL 5.7 and LOINCSUNQUESTV2.txt was an Excel spreadsheet created on
File './mysql/user.myd' Not Found
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. In version 5.6 of a stock vanilla install it would be in this directory: C:\ProgramData\MySQL\MySQL Server 5.6. Try moving the file there. I believe that Mysql looks at this location by default, so I would change LOAD DATA INFIL
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 error 1148 (42000): the used command is not allowed with this mysql version about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users load data infile error 13 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping
Mysql Server Is Running With The Secure-file-priv Option
each other. Join them; it only takes a minute: Sign up MySQL LOAD DATA Error (Errcode: 2 - “No such file or directory”) up vote 2 down vote favorite I am trying to load data into a table of http://stackoverflow.com/questions/30649226/load-data-infile-file-not-found-error my MySQL database, and getting this error. LOAD DATA LOCAL INFILE 'C:\Users\Myself\Desktop\Blah Blah\LOAD DATA\week.txt' INTO TABLE week; Reference: this The path is hundred percent correct, I copied it by pressing shift and clicking "copy path as" and checked it many times. So any tips on this will be much appreciated. . My research: Seeing this answer, I tried by changing C:\Users to C:\\Users. It did not work for me. Secondly, is there a way to use some http://stackoverflow.com/questions/23232417/mysql-load-data-error-errcode-2-no-such-file-or-directory kind of a relative path (rather than an absolute path) here? mysql sql bulkinsert load-data-infile share|improve this question edited May 18 at 20:03 SushiGuy 43738 asked Apr 22 '14 at 23:59 Solace 2,48772455 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted I don't know what version of MySQL you are using but a quick Google search found possible answers to both your questions. Below are excerpts from the MySQL 5.1 Reference Manual: The file name must be given as a literal string. On Windows, specify backslashes in path names as forward slashes or doubled backslashes The LOCAL keyword affects where the file is expected to be found: If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client program was started. Regards. share|improve this answer answered Apr 23 '14 at 0:26 FumblesWithCode 32116 add a comment| up vote 0 down vote Try removing the word LOCAL from your query. share|improve this answer answered Apr 23 '14 at 0:04 Vishnuraj V 1,0772618 add a comment| up vote 0 down vote Try moving the week.txt file to the desktop the
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 https://ubuntuforums.org/showthread.php?t=822084 IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! 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 ? not found 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 Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded file not found 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 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