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

I finally fixed it by running sudo /etc/init.d/mysql start. I just had to insert sudo in front of the command.


try this:

sudo service mysql stop
sudo service mysql start

In my case the error resulted of changing the ip address on the server.

cat /var/log/mysql/error.log

150427 23:01:08 InnoDB: 5.5.43 started; log sequence number 11731761
150427 23:01:08 [Note] Server hostname (bind-address): '192.168.1.234'; port: 3306
150427 23:01:08 [Note]   - '192.168.1.234' resolves to '192.168.1.234';
150427 23:01:08 [Note] Server socket created on IP: '192.168.1.234'.
150427 23:01:08 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
150427 23:01:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150427 23:01:08 [ERROR] Aborting

changing the

 bind-address       

in

 /etc/mysql/my.cnf

to the current ip and restarting the server

sudo /etc/init.d/mysql start

solved the problem


There are two possible problems with Mysql package:

  1. Really a space problem:

    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

    Check this and you will get full details and your answer

    https://serverfault.com/questions/256729/error-the-partition-with-var-lib-mysql-is-too-full

  2. It is a bug which might not have been fixed and to fix it follow this article:

    https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/118523


I have faced same issue, in my case there is another mysql service was running

$ ps -aux | grep mysql
mysql     7241  0.0  5.1 562600 52812 ?        Ssl  13:36   0:02 /usr/sbin/mysql
ubuntu   13580  0.0  0.0  10468   916 pts/0    S+   15:50   0:00 grep --color=au

$ sudo kill  7241

Then I started mysql.

$ sudo /etc/init.d/mysql start
* Starting MySQL database server mysqld                                 [ OK ]