mysqld won't start.

[d4v1d]

Hi,

10 minuts ago my mysql server decided to just stop working.. Out of nowhere. When I start it with /etc/init.d/mysqld start it says 'ok' but it seems to shutdown 5 seconds after I issued that command.

root@dbekker:/usr/local/mysql/bin# /etc/init.d/mysqld start
Starting mysqld:                [ OK ]
root@dbekker:/usr/local/mysql/bin# ps aux | grep mysqld
root      9440  0.0  0.0   6032   660 pts/0    S+   16:04   0:00 grep mysqld

When I tried to start it by hand it gives a error and some warnings, what to do now?

root@dbekker:/usr/local/mysql/bin# ./mysqld
130226 16:02:39 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
130226 16:02:39 [Warning] Can't create test file /var/lib/mysql/dbekker.lower-test
130226 16:02:39 [Warning] Can't create test file /var/lib/mysql/dbekker.lower-test
./mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
130226 16:02:39 [ERROR] Aborting

130226 16:02:39 [Note]

It worked for over 3 months and today this happend :|

David,

 

[chatwizrd]

wtf? Cant change dir is a problem. Did something happen to your /var/lib/mysql folder?

Either you have a drive corruption or something mallicious is going on.

Check to see if /var/lib/mysql is actually there.

 

[d4v1d]

wtf? Cant change dir is a problem. Did something happen to your /var/lib/mysql folder?

Either you have a drive corruption or something mallicious is going on.

Check to see if /var/lib/mysql is actually there.

Nop.. Neither is /usr/share/mysql :/

Is there a way to reinstall mysql? (not just apt-get remove and apt-get install I guess.. )

 

[chatwizrd]

I would guess all of your databases are now gone. You could restore mysql but you will have to pull database backups from any backups you have.

 

[d4v1d]

I found what screwed it.. Yesterday I installed mysqltcl via apt-get.. It worked fine untill apache got restarted..

I would guess all of your databases are now gone. You could restore mysql but you will have to pull database backups from any backups you have.

How can I restore mysql?

I tried to downgrade mysql and upgrade it again but that didn't work..

Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' '--port=3306' '--socket=/tmp/mysql.sock'
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
*** Linking libmysqlclient.so.16 to libmysqlclient.so.18
Restarting MySQL.
Stopping mysqld:                [ FAILED ]
mysqld is already running.  ${SOCK} exists
It is recommended to do "./build php n" after MySQL update.

 

[d4v1d]

The problem is solved with a little bit help from this thread