ERROR: The partition with /var/lib/mysql is too full!

i run /etc/init.d/mysql restart and it wont work....


my hard drive is packed. but i removed at least a few gigs.....

ERROR: The partition with /var/lib/mysql is too full!

i run /etc/init.d/mysql restart and it wont work....


my hard drive is packed. but i removed at least a few gigs.....

Is mysql binary log enabled? If you're not replicating your databases elsewhere then it's safe to flush the logs and disable bin-log from /etc/my.cnf. This will possibly reclaim gigs of disk space.

Here's the mysql command to flush them:

FLUSH LOGS;

Be sure to disable binary logging and restart mysql after the above step.

Regards

problem is mysql cannot even boot anymore! it just throws that message and will not boot.

use mysqladmin to run the command against the down db

use mysqladmin to run the command against the down db

mysqladmin requires the database to be up otherwise root can't authenticate. It's the chicken and egg problem.

Regards

problem is mysql cannot even boot anymore! it just throws that message and will not boot.

Delete the binary log files directly from /var/lib/mysql. Be sure you to know what you're doing. Have a backup before trying the above.

Regards

Paste us the result of:

df -h