mysql stopped working

[zEitEr]

Did you check with the link I've given above?

It's already discussed there: http://www.directadmin.com/forum/showthread.php?t=39128&page=2

Read from Post#23

 

[Nero9]

Stopping mysqld: [ FAILED ]

*****************************************************
*****************************************************

It seems as though mysql has already been installed.
The directory /home/mysql has been found. For the best results, its recommended that this be deleted.
All database data will be lost if you delete it

Do you want to delete it? (y is recommended)? (y,n) :

 

[zEitEr]

Do not delete any DBs.

 

[Nero9]

mysql is running now..thanks

but i cant see any dbs of my sites ?

 

[zEitEr]

ls -l /home/mysql

?

If it's empty, so you managed to delete DBs while re-installing mysql. If so, it's still possible to restore them from backups.

 

[Nero9]

server:~# ls -l /home/mysql
total 20532
-rw-rw---- 1 mysql mysql 10485760 2011-02-19 21:54 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2011-02-19 21:54 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2011-02-19 21:54 ib_logfile1
drwx------ 2 mysql mysql 4096 2011-02-19 21:54 mysql
-rw-rw---- 1 mysql root 1348 2011-02-19 21:54 server.178.162.181.25.com.err
-rw-rw---- 1 mysql mysql 5 2011-02-19 21:54 server.pid

 

[zEitEr]

So you need to restore DBs from backups. Normally, the script does not delete any DB, unless you answer Yes to

Do you want to delete it? (y is recommended)? (y,n) :

 

[Nero9]

So you need to restore DBs from backups. Normally, the script does not delete any DB, unless you answer Yes to

i entered y by mistake all got deleted

 

[zEitEr]

ls -l /usr/local/directadmin/custombuild/mysql_backups

?

Is any backuping running with directadmin?

 

[Nero9]

ls -l /usr/local/directadmin/custombuild/mysql_backups

?

Is any backuping running with directadmin?

yeah. i have backups

phpmyadmin not connecting

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

 

[localhost]

LOL
Do not install xbt_tracker next time if you are not sure how to do it.

Actually the system is really unstable because many libraries where rewrote by a install script also many things are linked with old libraries which are not compatible with the latest.

Install CenOS.

 

[dreamline]

I had the same problem last week. Spend a few hours on solving it but found out that my problem was caused by phpMyAdmin. I reinstalled phpMyAdmin and it worked just fine again. Somehow my phpMyAdmin config.inc.php.

Also backed up the my.cnf config file to my.cnf.bak so that I didn't have a my.cnf file anylonger.

Also check your php.ini file because there was an entry in my case which pointed to:
mysql.default_socket = /var/run/mysql/mysqld.sock
And it should have been:
mysql.default_socket = /tmp/mysql.sock

Hope this helps.

 

[Seth]

cd /usr/local/directadmin/custombuild
./build update && ./build clean
./build set_fastest
./build set mysql_inst yes
./build set mysql_backup yes
./build mysql

Fixed it for me, thanks.

 

[befree33]

I had the same problem last week. Spend a few hours on solving it but found out that my problem was caused by phpMyAdmin. I reinstalled phpMyAdmin and it worked just fine again. Somehow my phpMyAdmin config.inc.php.

Also backed up the my.cnf config file to my.cnf.bak so that I didn't have a my.cnf file anylonger.

Also check your php.ini file because there was an entry in my case which pointed to:
mysql.default_socket = /var/run/mysql/mysqld.sock
And it should have been:
mysql.default_socket = /tmp/mysql.sock

Hope this helps.

I'm using a Xen vps. In my System Info at http://123.23.321.12:2222/CMD_SYSTEM_INFO, it shows the following:

MySQL 5.1.65 *** Stopped ***

Specs for my DA are:
Processor Name Intel(R) Xeon(R) CPU E5-2640 0 @ 2.50GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2499.998
Total Memory 524288 kB
Free Memory 38088 kB
Total Swap Memory 524280 kB
Free Swap Memory 359080 kB
System Uptime 0 Days, 4 Hours and 39 Minutes
Apache 2.2.23 Running
DirectAdmin 1.42.1 Running
Exim 4.77 Running
MySQL 5.1.65 *** Stopped ***
Named 9.3.6 Running
sshd Running
dovecot 2.1.15 Running
pure-ftpd 1.0.36 Running
Php 5.3.21 Installed

Will your solution work for my specs above?

FYI: I read http://forum.directadmin.com/showthread.php?t=39128 and another thread but they focused on Debian.

 

[zEitEr]

No need to re-install MySQL, you should better read MySQL error logs and/or try to start mysqld either with empty or default /etc/my.cnf file.

 

[wattie]

Hello,

Sir please type this command in ssh:

killall mysqld
killall -9 mysqld
/etc/init.d/mysqld start

Best regards,
Fidan Mirena
gfxMedia Creative Agency

Just a followup from me - sometimes when I try to restart MySQL it does not work. It shows "stop failed"... And the bad thing is that the mysqld continues to run as a process; however it's no longer accepting connections. Killing it and then starting is fixing the problem like Fidan Mirena said.