X Xman Active Member 504 2009 0 0 Sep 28, 2009 #1 MySQL said: #1 - Can't create/write to file '/tmp/#sql_1fda_0.MYI' (Errcode: 13) i have no clue what is up my site went wacko now the index page doesnt work but other pages do
MySQL said: #1 - Can't create/write to file '/tmp/#sql_1fda_0.MYI' (Errcode: 13) i have no clue what is up my site went wacko now the index page doesnt work but other pages do
W William Palmer Banned Banned 165 2009 0 0 Sep 28, 2009 #2 hello scotty the reason why it is like this is because /tmp is stating there is no read write access to it or someone deleted tmp what you need to do is find out the chmod permissions on tmp and tell me what they are and ill tell you what to do next
hello scotty the reason why it is like this is because /tmp is stating there is no read write access to it or someone deleted tmp what you need to do is find out the chmod permissions on tmp and tell me what they are and ill tell you what to do next
X Xman Active Member 504 2009 0 0 Sep 28, 2009 #3 lol i am not sure how to find the permissions i did run chmod 0777 tmp and it didnt help
G GrandMaster Active Member 43 2009 0 0 Sep 28, 2009 #4 Try this command # chown root:root /tmp # chmod 1777 /tmp # /etc/init.d/mysqld start Click to expand...
Try this command # chown root:root /tmp # chmod 1777 /tmp # /etc/init.d/mysqld start Click to expand...
J JmZ (╯°□°)╯︵ ┻━┻ 1,789 2008 729 0 Sep 28, 2009 #5 /tmp is probably mounted as read-only OR your disk is at 99% capacity (although in that case, lots more would stop working too). In ssh check the mount list: Code: # mount /dev/sda3 on /tmp type ext3 (ro,usrquota,grpquota) # mount -o remount,rw /tmp # mount /dev/sda3 on /tmp type ext3 (rw,usrquota,grpquota) Somethin along those lines anyway.
/tmp is probably mounted as read-only OR your disk is at 99% capacity (although in that case, lots more would stop working too). In ssh check the mount list: Code: # mount /dev/sda3 on /tmp type ext3 (ro,usrquota,grpquota) # mount -o remount,rw /tmp # mount /dev/sda3 on /tmp type ext3 (rw,usrquota,grpquota) Somethin along those lines anyway.
X Xman Active Member 504 2009 0 0 Sep 28, 2009 #6 Thanks you it seems to have worked GrandMaster. Thanks to all who replied.