Features / Usability

Posted by James Geddes 06 Jun 2019 14:34 GMT-0000 posts: 126

On running

sudo service mysql status

MySQL returned

Failed to start MySQL Community Server.

Since GIYF, I found

https://askubuntu.com/questions/455029/mysql-server-start-failed/602087

This suggested

sudo service mysql stop
sudo rm /var/lib/mysql/ib_logfile0
sudo rm /var/lib/mysql/ib_logfile1

Since that seems a bit dangerous without proper precautions, I first took a copy of ib_logfile0 and ib_logfile1, then removed them. I then restarted the SQL server. So far, it seems to be stable, but only time and Uptime Robot will tell.

I will keep everyone informed!

I feel like I have only addressed the symptom rather than treating the root cause. What can be done to prevent this?