i updated mysql using the tool provided in WHM. all seemed to run smoothly until it tried to restart mysql and i got this message:
|
1 2 3 4 5 6 7 |
Mysql did not start up after upgrade; there may be a problem in /etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 857. Obtained version information from system. Proceeding with MySQL/MariaDB upgrade despite the following: Critical: The system detected issues with the current “/etc/my.cnf” file. These issues may interfere with the upgrade to MySQL 5.7. |
tried to reboot and restart services (old windows habits 🙂 ) and of course it didn’t work.
so i opened up a ssh connection, deleted all content from /etc/my.cnf and replaced it with:
|
1 2 |
innodb_force_recovery=4 innodb_purge_threads=0 |
restarted mysql again (with success) and then deleted once again all content from /etc/my.cnf and restarted mysql
went back to whm – Upgrade MySQL and clicked on Resume Upgrade button
just to be sure i went back to ssh and ran
|
1 |
mysqlcheck --all-databases |
all good after that 😀