Restoring server but sql version may be important

maestroc

Well-Known Member
Aug 23, 2012
69
0
56
cPanel Access Level
Reseller Owner
Our server is fried and the data center can't recover it. We are getting ready to restore from backups but have a potential problem that I don't know how to address. The Mysql version might be important. We had not upgraded the old server's SQL to mariadb due to some very old scripts (15+ years old) and we feared that it would not work on mariadb, etc. The server we are going to restore to has cpanel already installed so most likely it has a newer version of SQL/MariaDB. Is there any way to roll back to the version of sql that came right before mariadb without totally having to reinstall cpanel, etc.?
 

rackaid

Well-Known Member
Jan 18, 2003
89
28
168
Jacksonville, FL
cPanel Access Level
DataCenter Provider

HostNoc

Active Member
Feb 20, 2020
28
3
3
Ontario
cPanel Access Level
Root Administrator
Hi
You can install the OS and then you install the cPanel after that you can remove the mysql through yum remove command then install manually mysql version you want.

Regards
 
Last edited:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,255
313
Houston
I absolutely would follow the recommendation provided by @rackaid

@HostNoc the method you're suggesting would not be the best practice nor would it be supported.

You can configure the version of MySQL® or MariaDB® to use in the /root/cpanel_profile/cpanel.config file’s mysql-version key before you install cPanel & WHM. However, we do not support the configuration of existing installations of cPanel & WHM.
The newer documentation on customizing your installation would be here: Customize Your Installation | cPanel & WHM Documentation

Keep in mind that v86 does not support MySQL prior to 5.7 (per: cPanel Deprecation Plan | cPanel & WHM Documentation) so if you need MySQL 5.5 you must use the LTS tier.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,255
313
Houston
Just to confirm, yes it does the supported/available versions are listed here: MySQL or MariaDB Upgrade | cPanel & WHM Documentation

Code:
Available versions
The following versions of MySQL are available:

[LIST]
[*]MySQL 5.6
[*]MySQL 5.7
[/LIST]
The following versions of MariaDB are available:

[LIST]
[*]MariaDB 10.0
[*]MariaDB 10.1
[*]MariaDB 10.2
[*]MariaDB 10.3
[/LIST]