Upgrade from MySQL 5.7 to MySQL 8.0 or MariaDB 10.3

Radhi

Active Member
Feb 5, 2019
27
3
3
Tunisie
cPanel Access Level
Root Administrator
Hi
Does when upgrading from MySQL 5.7 to MySQL 8.0 or MariaDB 10.3 affect the sites and scripts?

If that doesn't affect it, what is the upgrade mechanism?

Thanks in advance.
 

andrew.n

Well-Known Member
Jun 9, 2020
633
183
43
EU
cPanel Access Level
Root Administrator
Please read the warnings shown before the upgrade carefully and make sure that your sites will support those changes. If you upgrade to the next version then it's a direct upgrade. If you upgrade for example from MySQL 5.5 to MySQL 5.7 then first you will be moved to 5.6 and then to 5.7.
 
  • Love
Reactions: Radhi

Radhi

Active Member
Feb 5, 2019
27
3
3
Tunisie
cPanel Access Level
Root Administrator
Please read the warnings shown before the upgrade carefully and make sure that your sites will support those changes. If you upgrade to the next version then it's a direct upgrade. If you upgrade for example from MySQL 5.5 to MySQL 5.7 then first you will be moved to 5.6 and then to 5.7.
A thousand thanks for your reply and advice.
 
  • Like
Reactions: andrew.n

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,491
1,008
313
cPanel Access Level
Root Administrator
We do consider MySQL 8 to be "higher" than MariaDB, so the details @vacancy provided are important.

It's not so much that the upgrade makes any changes, but it's more an issue of IF your scripts are compatible with the adjustments in the newer version. If you aren't sure, it might be worth it to consult with a professional database administrator to check your sites and database queries to ensure there aren't any issues, as MySQL downgrades are not something that are supported in cPanel.
 
  • Like
Reactions: Radhi and vacancy