Thread: Server outrages
View Single Post
Old 2020-01-11, 20:57   #554
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

237628 Posts
Default

I seem to be in a vicious loop here.

As previously specified I added the command:
innodb_force_recovery = 5
to the var/mysql/my.cnf file

I rebooted the machine and checked the MySQL status using:
sudo service mysql status

It looked good.

After logging into MySQL I tried to drop prpnet1470 with:
drop database prpnet1470;

I got the following error:
ERROR 2013 (HY000): Lost connection to MySQL server during query

So...MySQL isn't starting properly due to this error and I am unable to drop the offending DB due to this error.

Any suggestions?

I will try increasing the force_recovery even higher to see if that does anything.

Last fiddled with by gd_barnes on 2020-01-11 at 20:58
gd_barnes is offline   Reply With Quote