3

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

Hi

I am running in a problem here I have a linux instance running on EC2. All was working fine till last night. Today morning it showed me some error stating that there was no disk space to write of mysql.

So I tried to stop and start mysql server. Stopping worked fine, but when i start with following command

sudo /etc/init.d/mysql start

It is showing me the error

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

Thanks

Community
  • 1
jimy
  • 177
  • 2
  • 3
  • 8

1 Answers1

2

You can check the amount of free space on your partition with the command: df You can also check which partition holds the directory /var/lib/mysql for example with the mount command.

Many distributions have their /var directory in the original root partition which is not made big enough by default to hold real-life data. They usually create separate partition for /usr with tons of space, so your easiest solution would be to stop mysql, copy /var/lib/mysql to /usr/lib/mysql (or /usr/local/lib/mysql no real difference), delete the original and make a symbolic link in the old place with:

ln -s /usr/lib/mysql /var/lib/mysql

Of course check that the destination directory have the right permissions.

vbence
  • 213
  • 2
  • 12