SQL Problem

[Batu]

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 4.1.21 installer for Linux.
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-embedded ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-bench ########################################### [100%]
Preparing... ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
1:MySQL-server ########################################### [100%]
060911 9:30:41 [ERROR] /usr/sbin/mysqld: Disk is full writing './mysql/help_category.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs

And I TRY


[[[root@corvette:~]]]mysql start
ERROR 2013 (HY000): Lost connection to MySQL server during query


/tmp CHMOD is 1777

Please help,I can't start MySQL.

Thanks.

 

[hicom]

Run 'df' as root, the error is clear....your disk is full (mostly /var)

 

[Batu]

df

Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
113210032 110012688 0 100% /
/dev/hda1 101086 15428 80439 17% /boot
none 1033048 0 1033048 0% /dev/shm
/dev/hdd2 114309732 108030692 472348 100% /disk3
/usr/tmpDSK 495844 10583 459661 3% /tmp
/tmp 495844 10583 459661 3% /var/tmp


Df reply.

 

[chirpy]

So, you need to clean up space on that full partition.