Mysql 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 Documentation Social error 1148 (42000): Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu mysql load data infile file not found windows Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Development error 29 (hy000) file relay-bin not found (errcode 2) & 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 to
Error 29 (hy000): File Not Found (errcode: 13 - Permission Denied)
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 Location file './mysql/user.myd' not found 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 "file not f
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 #1148 - the used command is not allowed with this mysql version Stack Overflow the company Business Learn more about hiring developers or posting ads with
Mysql Error Code 2
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Load Data Infile Error 13
a community of 6.2 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 https://ubuntuforums.org/showthread.php?t=822084 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 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 http://stackoverflow.com/questions/8471727/load-data-infile-does-not-work 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 | +-------------------+--------------+------+-----+---------+-------+ | student_id | int(11) | YES | | NULL | | | name | varchar(255) | YES | MUL | NULL | | | attribute | varchar(12) | YES | MUL | NULL | | | teacher_id | int(11) | YES | | NULL | | +-------------------+--------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql sql database share|improve this question asked Dec 12 '11 at 8:43 Mellon 9,85746141226 add a comment| 2 Answers 2 active oldest votes up vote 7 down vote accepted Have a look at the sixth post
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 https://oldwildissue.wordpress.com/2013/12/11/fixing-mysql-error-29-errcode-13-in-ubuntu/ found that using LOAD DATA was the quickest way to do the job. http://forums.mysql.com/read.php?26,264592 If you are using 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 many users that managed to not found 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 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 load data infile 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, 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 r
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Replication :: Cannot Start Replication on Slave - "cannot find master.info" New Topic Advanced Search Cannot Start Replication on Slave - "cannot find master.info" Posted by: Alex Recarey () Date: May 27, 2009 06:26PM Hello everybody. I have scoured the forums and the web searching to an answer to my problem to no avail. Thank you for taking the time to read about it. I am using mysql 5.0.32 on Debian etch. I have one server set up as MySQL replication master, with binlog properly configured and working. I have another setup for use as a slave. The slave has a snapshot taken from the master while the master was "FLUSH TABLES WITH READ LOCK". I have noted the bil log file and position using the SHOW MASTER STATUS command. I switch to the slave, login, and execute: RESET SLAVE STOP SLAVE CHANGE MASTER TO MASTER_HOST='XXX.XXX.XXX.XXX', MASTER_USER='xxxxx', MASTER_PASSWORD='xxxxxxx', MASTER_LOG_FILE='master-bin.000005 ', MASTER_LOG_POS=18262972; I receive: ERROR 29 (HY000): File '/var/lib/mysql/master.info' not found (Errcode: 13) Yes, the master's binlog file is named master-bin.000005 If i manually create a master.info file, and change the permissions so that they are: -rw-rw---- 1 mysql mysql 0 2009-05-28 02:19 master.info When I put the command RESET SLAVE I get the message: ERROR 6 (HY000): Error on delete of '/var/lib/mysql/master.info' (Errcode: 13) If I directly try the CHANGE MASTER TO command: ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log and the mysql error log shows nothing. I have read the manual countless times, and I have also set up a replication setup successfully between two virtual machines. What am I doing wrong? Thank you for your help. Alex Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views Written By Posted Cannot Start Replication on Slave - "cannot find master.info" 7602 Alex Recarey 05/27/2009 06:26PM Re: Cannot Start Replication on Slave - "cannot find master.info" 3578 Rick James 05/29/2009 10:30AM Re: Cannot Start Replication on S