Mysql Error 2 Hy000 File
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
Mysql Load Data Infile File Not Found Windows
About Us Learn more about Stack Overflow the company Business Learn more about error 1148 (42000): the used command is not allowed with this mysql version hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Error 13 (hy000): Can't Get Stat Of
the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up load data local infile ERROR error 2 hy000 file not found errcode 2 no such file or directory 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 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: (errcode 2 - no such file or directory) mysql 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 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
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: load data infile errorcode 2 New Topic Advanced Search load data infile errorcode 2 Posted by: Jon Lee () Date: December 07, 2009
Mysql Error Code 2
12:51PM I am trying to load data from a text file into an mysql error 2 failed to open file table. I am running server version 5.1.41 and client version 5.1.11. Clent and server are running on my local PC. I
Mysql Load Data Local Infile
cannot get past the file not found errorcode 2. I have used the command with and without the "local" keyword without success. I have verified that the text file is in the database directory. http://stackoverflow.com/questions/7623984/load-data-local-infile-error-2-file-not-found I have tried it with the path explicitly defined and without the path. I have used both the forward slash path designation "/" and the double back slash designation"\\". Having spent a considerable amount of time doing searches on this error without result I am reaching out to anyone who has a clue about this issue. Here is my query and result: mysql> load data infile 'nw.txt' into http://forums.mysql.com/read.php?10,294725 table import_perf_pnc; ERROR 29 (HY000): File 'C:\Documents and Settings\All Users\Application Data\MyS QL\MySQL Server 5.1\Data\perf_db\nw.txt' not found (Errcode: 2) Thanks in advance for any help that I can receive. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted load data infile errorcode 2 Jon Lee 12/07/2009 12:51PM Re: load data infile errorcode 2 Matt Pellegrino 12/07/2009 08:18PM Re: load data infile errorcode 2 Jon Lee 12/08/2009 08:17AM Re: load data infile errorcode 2 Mark Snyder 12/08/2009 08:42AM Re: load data infile errorcode 2 Jon Lee 12/08/2009 08:51AM Re: load data infile errorcode 2 Mark Snyder 12/08/2009 09:24AM Re: load data infile errorcode 2 Jon Lee 12/08/2009 09:50AM Re: load data infile errorcode 2 Mark Snyder 12/08/2009 10:48AM Sorry, you can't reply to this topic. It has been closed. powered by phorum 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. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact
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! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support http://w3schools.invisionzone.com/index.php?showtopic=5991 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 mysql error 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 mysql error 2 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
Detected You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality. loading a file into my sql Started by natnat, Jul 04 2006 02:07 PM Please log in to reply 4 replies to this topic #1 natnat natnat Newbie Members 7 posts Posted 04 July 2006 - 02:07 PM I have just started using my sql and everything was working fine with querys, creating tables and such until i tried to create a file with values in it in notepad, save it as hsiaTest.txt, and load it into my table with this code:mysql> load data local infile "hsiaTest.txt" into table test_one;it returns...ERROR 2 (HY000): File 'hsiaTest.txt' not found (Errcode: 2)I have the file saved to the same drive where the mysql database is running from so whats the problem? Back to top #2 aspnetguy aspnetguy Web Developer Members 6,770 posts Gender:Male Location:Canada Languages:PHP, ASP.NET, C#, JavaScript, HTML, CSS Posted 04 July 2006 - 02:22 PM mysql doesn't run on a 'drive' it is a stand alone server runnin gon your PC.You need to save the text file where you have the code to process it.Can oyu post your code and I will try and fix it. It is most likely just a path error. justin » My Blog | church attendance software | order of wedding speeches please...» ...do a search before asking a question, it has probably already been answered» ...read the tutorials, chances are they also have the answer to your question» ...be specific when describing your problem and if possible provide your code and/or a link Back to top #3 natnat natnat Newbie Members 7 posts Posted 04 July 2006 - 02:34 PM mysql doesn't run on a 'drive' it is a stand alone server runnin gon your PC.You need to save the text file where you have the code to process it.Can oyu post your code and I will try and fix it. It is most likely just a path error.
well, what I typed in the 1st post is the line of code. I'm using this at the DOS prompt..thats the only way my project manager will allow for now.but again it is... mysql> load data local infile "hsiaTest.txt" into table test_one;ERROR 2 (HY000): File 'hsiaTest.txt' not found (Errcode: 2)mysql> load data local infile "hsiaTest.txt" into table test_one;ERROR 2 (HY000): File 'hsiaTest.txt' not found (Errcode: 2)mysql> load data local infile "hsiaTest.txt" into table test_one;E