Error 29 Hy000 File Mysql
Contents |
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 error hy000 mysql odbc 5.1 driver access denied for user Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8:
Mysql Error 2002 Hy000
Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu mysql error 2003 hy000 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 ? < mysql error 2003 hy000 111 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 Mode June 8th, 2008 #1 calsaverini View Profile View Forum Posts Private Message Visit Homepage 5 Cups of
Error 2002 Hy000 Mysql Centos
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 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, Braz
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 mysql load data infile file not found windows posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss error 1148 (42000): 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
Error 29 (hy000) File Relay-bin Not Found (errcode 2)
a minute: Sign up How to fix ERROR 29 (HY000) in mysql? up vote 3 down vote favorite 1 When I use this command below in Mysql client 5.1 in ubuntu: load data infile 'words.csv' into table words; I'm getting https://ubuntuforums.org/showthread.php?t=822084 this error: ERROR 29 (HY000): File '/var/lib/mysql/bhuvan/words.csv' not found (Errcode: 2) Help me out. mysql share|improve this question edited Apr 1 '11 at 15:29 Nishant 32.5k76994 asked Apr 1 '11 at 15:26 Bhuvan raj 1502415 add a comment| 3 Answers 3 active oldest votes up vote 10 down vote accepted Try load data local infile 'words.csv' into table words fields terminated by ',' enclosed by '"' lines terminated by '\n'; If your words file is in your / directory. share|improve this answer http://stackoverflow.com/questions/5515450/how-to-fix-error-29-hy000-in-mysql answered Apr 1 '11 at 15:31 k to the z 2,51211440 Worked for me. 'local' is the key word. –Indika K Jun 14 at 8:24 add a comment| up vote 7 down vote For Ubuntu users, Check you currently use: mysql -u user -p --local-infile. Another useful link talking about apparmor configuration. share|improve this answer answered Jan 4 '13 at 14:51 Seb 10114 add a comment| up vote 2 down vote If the file is located on your client machine, you should use this: load data local infile 'words.csv' into table words; share|improve this answer answered Apr 1 '11 at 15:29 Quassnoi 261k50430482 thanks a lot :) –Bhuvan raj Apr 1 '11 at 15:37 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql or ask your own question. asked 5 years ago viewed 14047 times active 3 years ago Linked 94 How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE? Related 2787How can I prevent SQL injection in PHP?1MySQL Error 1 (HY000) Trouble creating file Errcode 2852How to get a list of MySQL user accounts143ERROR 2006 (HY00
10:59:48 -0400, Scott Helms wrote: > I generally drop them into /tmp for easy access and cleanup after the > https://lists.mysql.com/mysql/230420 data load, but you can put them any place that the mysql daemon process > has access to read. Huh, maybe the daemon doesn't have access http://grokbase.com/t/mysql/mysql/146qtw4r33/error-29-file-not-found-errcode-13 to /tmp?... thufir@dur:/tmp$ thufir@dur:/tmp$ ll /tmp/make_year_model.csv -rw-rw-r-- 1 thufir thufir 83 Jun 23 22:04 /tmp/make_year_model.csv thufir@dur:/tmp$ thufir@dur:/tmp$ nl /tmp/make_year_model.csv 1 make1,model1,2012,123,red 2 make2,model2,2013,456,blue 3 make3,model3,2001,789,green mysql error thufir@dur:/tmp$ thufir@dur:/tmp$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other error 2002 hy000 names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> LOAD DATA INFILE '/tmp/make_year_model.csv' INTO TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13) mysql> mysql> quit Bye thufir@dur:/tmp$ Thread• error 29, file not found (errcode: 13)thufir23Jun • Re: error 29, file not found (errcode: 13)ScottHelms23Jun • Re: error 29, file not found (errcode: 13)CarstenPedersen23Jun • Re: error 29, file not found (errcode: 13)MichaelDykman23Jun • Re: error 29, file not found (errcode: 13)DiveshKamra23Jun • Re: error 29, file not found (errcode: 13)thufir24Jun • Re: error 29, file not found (errcode: 13)ReindlHarald24Jun • Re: error 29, file not found (errcode: 13)thufir24Jun • Re: error 29, file not found (errcode: 13)thufir26Jun © 1995, 2016, Oracle Corporation and/or its affiliates Legal Policies
enough, but I don't quite follow. Where would be a good locationfor the CSV file, then?thufir@dur:~$thufir@dur:~$ mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 62Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rightsreserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current inputstatement.mysql>mysql> LOAD DATA INFILE '/home/thufir/make_year_model.csv' INTOTABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY'\n';ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found(Errcode: 13)mysql>mysql> quitByethufir@dur:~$thufir@dur:~$ cat /home/thufir/make_year_model.csvmake1,model1,2012,604,buy nowmake2,model2,2013,780,need to sellmake3,model3,2001,780,cheapthufir@dur:~$thanks,Thufir reply Tweet Search Discussions Search All Groups mysql 8 responses Oldest Nested Scott Helms I generally drop them into /tmp for easy access and cleanup after the data load, but you can put them any place that the mysql daemon process has access to read. Scott Helms Vice President of Technology ZCorum (678) 507-5000 -------------------------------- http://twitter.com/kscotthelms -------------------------------- Scott Helms at Jun 23, 2014 at 3:04 pm ⇧ I generally drop them into /tmp for easy access and cleanup after the dataload, but you can put them any place that the mysql daemon process hasaccess to read.Scott HelmsVice President of TechnologyZCorum(678) 507-5000--------------------------------http://twitter.com/kscotthelms--------------------------------On Mon, Jun 23, 2014 at 10:52 AM, thufir wrote:Apparently this error is because MySQL can't read my home directory? Fairenough, but I don't quite follow. Where would be a good location for theCSV file, then?thufir@dur:~$thufir@dur:~$ mysql -u ro