/temp full please help

[cool999]

Hello, please tell me how can i clear /temp

/usr/tmpDSK 485M 460M 16K 100% /tmp

let me know.. thanks...

[cool999]

i found the reason why my tmp is getting full, one my database table is crashed, and when i try to repair it, it make the tmp full, and because of this i m not able to repair my table... ( i cleared the /tmp using this cmd - rm -f -r ses* ) please help me out... can i stop it from created log / session files or whatever in tmp so i can repair my table or any other way?

urgent help please..

Thank you...

[anojpala]

I guess your database is of large size and the memory allocated for mysql is not good enough.In such situations it will try to use /tmp and if it is also full then will fail.
Removing session files is not a good option as its of very small size.
Either you increase the memory for mysql or increase the /tmp size. This will help whenever you need to repair that database again.

[cool999]

I did this and increased my /tmp to 2 GB, and repaired my table successfully..

# /etc/init.d/mysql stop
# cp -af /var/tmp /var/tmp.bak
# umount /var/tmp
# umount /tmp
# rm -f /usr/tmpDSK
# dd if=/dev/zero of=/usr/tmpDSK bs=1024 count=1048576
# mkfs /usr/tmpDSK
# tune2fs -j /usr/tmpDSK
# mount -t ext3 -o nosuid,noexec,loop /usr/tmpDSK /tmp
# mount -o bind,noexec,nosuid /tmp /var/tmp
# cp -a /var/tmp.bak/* /tmp/
# rm -rf /var/tmp.bak/
# chmod 1777 /tmp
# /etc/init.d/mysql start

enjoy