Mysql help

[Xman]

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

Xman Reviewed by Xman on 27th Sep 2009. Mysql help MySQL said: https://pirate-this.com:2083/3rdparty/phpMyAdmin/themes/original/img/b_help.png #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 Rating: 5

[William Palmer]

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

[Xman]

lol i am not sure how to find the permissions

i did run chmod 0777 tmp and it didnt help

[GrandMaster]

Try this command

# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start

[JmZ]

/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:

# 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.

[Xman]

Thanks you it seems to have worked GrandMaster. Thanks to all who replied.