Error 29 Hy000
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 1148 (42000): Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8:
Error 29 (hy000) File Relay-bin Not Found (errcode 2)
Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu
Error 29 (hy000): File Not Found (errcode: 13 - Permission Denied)
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 Load Data Infile File Not Found Windows
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 file './mysql/user.myd' not found 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, B
here for a quick overview of the site Help Center Detailed answers to any questions you might mysql error code 2 have Meta Discuss the workings and policies of this site About #1148 - the used command is not allowed with this mysql version Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting load data infile error 13 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 https://ubuntuforums.org/showthread.php?t=822084 million programmers, just like you, helping each other. Join them; it only 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 = /var/lib/mysql http://stackoverflow.com/questions/8471727/load-data-infile-does-not-work 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 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 | +-------------------+--------------+-
2013 by Soraph Recently I had to work with a large amount of data that had to be imported into MySQL via a script after being modified. I've found that using LOAD DATA was the quickest way to do the job. If you are using Ubuntu https://oldwildissue.wordpress.com/2013/12/11/fixing-mysql-error-29-errcode-13-in-ubuntu/ for your server (or you have to work with a server using Ubuntu) you will find this error when trying to use the query: ERROR 29 (HY000): File '....' not found (Errcode: 13) After few seconds on Google you will find http://board.phpbuilder.com/showthread.php?10393741-RESOLVED-LOAD-DATA-INFILE-mysql-says-file-not-found-but-it-s-definitely-there many users that managed to get over the error using the keyword LOCAL, but if you keep your MySQL updated you will see that it will not work as it could generate a security issue in your server. To overcome this not found issue there is a simple workaround that require you to modify the MySQL's AppArmor file and define directory where the program can read and write. Be aware that allowing MySQL to read and write in a directory could lead to security problems, always review this kind of changes with a System Administrator. The workaround is really quick: Open the file /etc/apparmor.d/usr.sbin.mysqld as root with your favourite text editor You should see a list of paths where AppArmor allow MySQL to write and read, error 29 (hy000) at the end of this list add the directory where you would like that MySQL will be able to read and write following the pattern used in all the previous entries. For instance: #Other contents /usr/sbin/mysqld { #Other contents /var/log/mysql.log rw, /var/log/mysql.err rw, #Other contents #This will be your dir definition /tmp/ r, /tmp/* rw, #Other contents } Then save and close the file. After you have successfully modified the file it is time to tell AppArmor that it needs to reload the configurations, so as root execute the following command: # /etc/init.d/apparmor reload Then restart MySQL, as root execute the following command: # service mysql restart At this point you have allowed MySQL to write and read contents into your defined directory, only do this if you know what you are doing! I take no responsibility for any damage or data loss caused by a server not correctly secured. Be careful & have fun! Rate this:Share this:Click to share on Twitter (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Reddit (Opens in new window)Click to email (Opens in new window)MoreClick to share on Pinterest (Opens in new window)Click to share on Pocket (Opens in new window)Click to share on Tumblr (Opens in new window)Share on Facebook (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related This entry was posted in MySQL, Systems and tagged AppArmor
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 config file: Code: sudo nano /etc/apparmor.d/usr.sbin.mysqld adding this line: Code: /path/to/ r, and then reloading app armor: Code: sudo /etc/init.d/apparmor reload The error persists. I've tried adding the LOCAL option to the mysql command but I get this complaint from mysql: Code: ERROR 1148 (42000): The used command is not allowed with this MySQL ve