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:
-
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
-
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 ]