Upgrade MySQL Database via WHM

Step by step how to upgrade MySQL database via WHM.

Note: Basically upgrade mysql can be upgraded easily through WHM interface and it is an automatic process.

Backup Database first

Make sure you backup all database first. For managed service, can take a look folder /exabytes-id/ or /backup/backup_db/ and see if database if regulary backup. If not, may run backup database first for all users.

cd /root && mkdir `date +%Y_%m_%d` && cd `date +%Y_%m_%d` && for I in $(mysql -e 'show databases' -s --skip-column-names); do mysqldump $I | gzip > "$I.sql.gz"; done

Upgrade Database

Proceed to upgrade database either MySQL 5.7 Or MariaDB (depends which version your database installed on) > Continue.

Warning

When you facing an upgrade warning, just ignore it. Tick Critical and proceed to Continue. Choose Interactive Upgrade.

Choose Interactive upgrade

Upgrade in process

Now let’s wait for 5 minutes. This may take quite time.

Upgrade Details

Uprade now has finished. You just need to click “Resume Current Upgrade”.

Now you should able to upgrade most WHM type servers.