Restoring server but sql version may be important

[maestroc]

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]

You did not specify your versions of MySQL, but if you need MySQL 5.5/5.6, you need to make adjustments before you install cPanel. If you host offers a recover console, I would just have them install your OS and then you handle the cPanel install.

See: Installation Guide - Customize Your Installation - Version 70 Documentation - cPanel Documentation
For more details on customizing the install. I just had to do this not long ago.

 

[HostNoc]

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

 

[cPanelLauren]

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.

 

[quietFinn]

@cPanelLauren
does v86 support MariaDB 10.1?

 

[GoMummyHosting]

Current latest supported version is : 10.3.21-MariaDB with v86.0.8

 

[quietFinn]

does v86 support MariaDB 10.1?

To answer my own question: I just installed cPanel/WHM, v86.08, with MariaDB 10.1.

 

[cPanelLauren]

Just to confirm, yes it does the supported/available versions are listed here: MySQL or MariaDB Upgrade | cPanel & WHM Documentation

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]