up vote 2 down vote favorite
share [g+] share [fb]

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

link|improve this question
75% accept rate
Looks like you're out of space – Andrew Cooper Apr 7 '11 at 6:35
I think you need to upgrade to a server with more database space. But, I would start by looking at some disk usages to identify which tables are the culprits and check whether those were supposed to grow like that. If not, then there is more to look for. – Rasika Apr 7 '11 at 6:36
@WhiteFang34 which files i should delete??? – jimy Apr 7 '11 at 6:42
the ones you don't need! – Alnitak Apr 7 '11 at 6:45
I tried many of the log files but its making no difference – jimy Apr 7 '11 at 6:47
show 1 more comment
feedback

migrated from stackoverflow.com Apr 7 '11 at 7:51

This question came from our site for professional and enthusiast programmers.

closed as exact duplicate by Chopper3 Apr 7 '11 at 9:41

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

1 Answer

up vote 0 down vote

You can checkthe free space on your prtition with the command: df - you can also check which partition hold the directory /var/lib/mysql for example with the mount command.

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

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

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

link|improve this answer
feedback

Not the answer you're looking for? Browse other questions tagged or ask your own question.