tag:blogger.com,1999:blog-10409743.post115520874138419994..comments2010-10-25T18:49:11.415-07:00Rodrigo De Castrohttp://www.blogger.com/profile/02877103835865244238noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-10409743.post-28957646406292098222010-03-11T17:50:51.260-08:002010-03-11T17:50:51.260-08:00If you have error 1033, make sure you have the /tmp folder. If you create the folder, then restart mysql.Sivahttp://www.blogger.com/profile/01070569036825605233noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-77761587280651209732009-02-24T01:28:00.000-08:002009-02-24T01:28:00.000-08:00awesome.<BR/><BR/>You just saved me one or two hours of downtime on a production server :)warphttp://www.blogger.com/profile/10082681681857181668noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-72163272652549244222009-02-17T01:24:00.000-08:002009-02-17T01:24:00.000-08:00We are getting the same error in solaris where MySQl is installed in a cluster of 3 nodes.<BR/>Can't see any tmp folder here.<BR/>Please help.Biswadeephttp://www.blogger.com/profile/11411359464589575678noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-25237538245098193632008-12-09T09:35:00.000-08:002008-12-09T09:35:00.000-08:00Thanks a LOT. Another soul is saved! :Dsantinonoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-10506767467127469592008-09-10T04:57:00.000-07:002008-09-10T04:57:00.000-07:00wow, thanks ... cleaned up "/tmp/" and received the same error ... it's now working again!Hansjoerg @ tunesBaghttp://www.blogger.com/profile/08142967508358252209noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-49571007013630625612008-09-04T12:56:00.000-07:002008-09-04T12:56:00.000-07:00Excellent Post!!!!<BR/>Saved what little hair I have left for such an easy fix.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-83557979662533895372008-06-18T13:47:00.000-07:002008-06-18T13:47:00.000-07:00Thanks! Indeed it was the case for me /tmp didn't have adequate permission for mysql. At least I'm one step further - now I have the problem <BR/><BR/>Error 1146: Table 'dbname.table' doesn't exist<BR/><BR/>jeez it's always something.Bitheadhttp://www.blogger.com/profile/09041978512215776763noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-47338238385217096162008-05-06T10:40:00.000-07:002008-05-06T10:40:00.000-07:00This worked perfectly! Thanks so much. I really thought I was screwed.Mcescobar1http://www.blogger.com/profile/05227056237320998009noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-37738191365585709482008-04-25T22:22:00.000-07:002008-04-25T22:22:00.000-07:00I was having the same problem. The other day I deleted everything in my /tmp directory as I didn't have enough space. I thought /tmp files are temporary but it appeared that I was wrong. I'm trying to install a fresh ubuntu 8.04 right now. Hopefully I can get my database working there.Mohammadhttp://www.havadarha.comnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-35599076157181851532007-06-05T15:05:00.000-07:002007-06-05T15:05:00.000-07:00Thank you. Indeed, the permissions on /tmp had changed. Gotta love that panic call "uh, Dave, the database is making a grinding sound and everyone is going on a break, by the way fix it now". CheersAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-42411725611765857632007-04-25T15:36:00.000-07:002007-04-25T15:36:00.000-07:00Oh, thank you! I had modified the my.cnf to use /data/mysql/tmp as I wanted the mysql stuff kept on a nice large RAID10 drive, and apparently I made a tmp folder somewhere, but it wasn't under /data/mysql. Found this page, verified that it was the problem, and fixed. Again, thanks!Chris Wiegandhttp://chriswiegand.livejournal.comnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-1166709854369417522006-12-21T06:04:00.000-08:002006-12-21T06:04:00.000-08:00Thank You! Thank You! Thank You!<BR/><BR/>I thought I lost everything! It would have been a very bad day!<BR/><BR/>I mounted a new /tmp filesystem, but didn't have the permissions setup correctly...<BR/><BR/>Thank You!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-1158198676114816412006-09-13T18:51:00.000-07:002006-09-13T18:51:00.000-07:00I got the same problem but with /var/tmp, the rights have changed automatically when I've restard mysqld.<BR/><BR/>So I solve the problem with "chmod 1777 /var/tmp".<BR/><BR/>Is 1777 the correct rights for "/var/tmp" ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10409743.post-1156505306396809612006-08-25T04:28:00.000-07:002006-08-25T04:28:00.000-07:00Yes, I was desperate when accessing all tables returned that error. Fortunately it was only my development machine and nothing serious would happen, even if everything got corrupted :-)<BR/><BR/>After checking the log, I saw that when it started failing to access the tables, MySQL complained something about /tmp, what led me to check if everything was all right with this directory.Rodrigo Castrohttp://www.blogger.com/profile/16468018369073840110noreply@blogger.comtag:blogger.com,1999:blog-10409743.post-1155221333666725682006-08-10T07:48:00.000-07:002006-08-10T07:48:00.000-07:00Nice error message! ;) You probably had a hard time trying to find out it was related the /tmp directory...Renatonoreply@blogger.com