MySQL/MariaDB Upgrade / WHM/Cpanel
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. SteveK
  2. Monday, 06 May 2019
  3.  Subscribe via email
My instance requires a Mysql upgrade and is spitting out this error

"Your server uses MySQL Governor. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state. For more information, read our MySQL/MariaDB Upgrade documentation."

I understand I can upgrade my server's cloudlinux Mysql to a newer version. I was reading other threads to be sure to back up the entire database before doing the upgrades. The question being - which database are you talking about? I have several hundred. I don't see a cloudlinux or governor database, whm, cpanel, lve manager nothing familar. All databases get backed up by default every night and copied offsite.

Should I just run the global database backup and then run this?

$ /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION
$ /usr/share/lve/dbgovernor/mysqlgovernor.py --install

After changing the database versions what would I need to do ensure WHM/Cpanel is happy? I wouldn't need to run their update again would I?

Will this impact any domains that required an older version of mysql?
Rate this post:
  1. 07.05.2019 12:05:12
  2. # 1
Dmitriy Serafin Accepted Answer
Posts: 14
Joined: 03.04.2019
0
Votes
Undo
Hello,

Could you please submit a ticket to https://cloudlinux.zendesk.com/ so our Support Team could look closely into the issue?
To speed up the process, please include the description from this post and the output of the following command (run it as root on the server):
wget -qq -O - https://www.cloudlinux.com/clinfo/cldoctor.sh|bash

Depending on the server configuration, you might need different options to upgrade the MySQL.
Thank you.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.