Previous Thread
Next Thread
Print Thread
Hop To
mySQL Upgrade? #262430 03/01/2019 10:39 AM
Joined: Nov 2006
Posts: 178
Jake Offline OP
Member
OP Offline
Member
Joined: Nov 2006
Posts: 178
My web host is sending me emails recommending I upgrade mySQL from 5.5 to at least 5.7.

I see the "Pre-Installation Checklist" says "5.5+" so it seems like a good thing to do.

I need to check whether Joomla would run with mySQL 5.7.

I'm uncomfortable doing this myself. If the answer is yes I'l ask the webhost if they'll do it. If they don't do this type of upgrade I'll need to hire someone.

If there anything special that needs to be done prior to upgrading mySQL? Other than a full backup?

Thanks!

Express Hosting
Re: mySQL Upgrade? [Re: Jake] #262432 03/01/2019 11:11 AM
Joined: Jul 2006
Posts: 96
Philipp Offline
Journeyman
Offline
Journeyman
Joined: Jul 2006
Posts: 96
.
Originally Posted by Jake
I need to check whether Joomla would run with mySQL 5.7.

Yes, Joomla will also work with newer versions of MySQL. However, I would upgrade to MariaDB (https://en.wikipedia.org/wiki/MariaDB) instead.

Originally Posted by Jake
If there anything special that needs to be done prior to upgrading mySQL? Other than a full backup?

No, just create a full backup of your databases

Re: mySQL Upgrade? [Re: Jake] #262435 03/01/2019 3:03 PM
Joined: Apr 2004
Posts: 1,413
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,413
Originally Posted by Jake
My web host is sending me emails recommending I upgrade mySQL from 5.5 to at least 5.7.

I see the "Pre-Installation Checklist" says "5.5+" so it seems like a good thing to do.

Yes, UBB.threads works just fine with MySQL 5.5 and newer database. thumbsup
https://www.ubbcentral.com/doc_install.php

UBB.threads Supported MySQL Databases
MySQL Recomended 5.6 +
MySQL Minimum 5.5


Originally Posted by Jake
I need to check whether Joomla would run with mySQL 5.7.

Joomla! 1.6, 1.7, & 2.5 system requirements are over here:
https://downloads.joomla.org/us/technical-requirements-us

Joomla! 1.6, 1.7, & 2.5 Supported MySQL Databases
MySQL Recomended 5.5.3 +
MySQL Minimum 5.1


Originally Posted by Philipp
However, I would upgrade to MariaDB (https://en.wikipedia.org/wiki/MariaDB) instead.


If you are on a managed server (not VPS), Its basically up to your webhost as to which database back-end you will be running.

According to the following linked summary comparison, there are no major benefits you'd gain from demanding to switch backends vs just upgrading to the current version of your current database engine.


Which Database Is Right For Your Business?
SOURCE: https://blog.panoply.io/a-comparative-vmariadb-vs-mysql

Quote
MySQL: MySQL is a proven database that has a strong following around the globe. The Oracle Corporation continues to maintain, enhance, and support the product.

MariaDB: The MariaDB provides a drop-in replacement for organizations running MySQL. It is managed by the MariaDB Foundation, allowing people to contribute to the open source product and documentation.

Both products may continue to diverge in the future. For many organizations, the fundamental question comes down to: Which one do you feel more comfortable with?

Would you prefer a larger corporation like Oracle Corp that manages MySQL, or would you feel more comfortable with an open solution like MariaDB?

Last edited by isaac; 03/01/2019 3:07 PM.

isaac @ id242.com [id242.com] // my forum @ CelicaHobby.com [celicahobby.com]
a current developer of UBB.threads php forum software // 7.7.2 Progress Notes
Re: mySQL Upgrade? [Re: Jake] #262437 03/01/2019 4:30 PM
Joined: Jun 2006
Posts: 15,834
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,834
Upgrading system software (PHP, Apache, MySQL, etc) is well outside of the scope of user to user support on these forums, and really should be done by your data center or someone extremely capable of handling system upgrade tasks; this is especially true in the case of migrating from MySQL to MariaDB.

It is extremely easy for one who is not familiar with upgrading system utilities via command line (or even via EasyApache for WHM) to make mistakes, and even neglect to tune their newly installed services, and that is not a level of troubleshooting that we're prepared to offer.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade? [virtualnightclub.net]
Forums: A Gardeners Forum [agardenersforum.com] Scouters World [scoutersworld.com]
UBB.threads: UBBWiki [ubbwiki.com], UBB Styles [virtualnightclub.net], UBB.Sitemaps [virtualnightclub.net]
Longtime Supporter & Resident Post-A-Holic
VNC Web Services [virtualnightclub.net]: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Additional Community Resources
UBB Developers
UBB Wiki
ShoutChat Box
Recent Topics
Error Messages - What to do???
by Daryl Fawcett - 06/20/2019 9:05 AM
Forum - Left Alignment / Margin?
by keysolutns - 06/19/2019 9:58 AM
Forum Not Working after Cpanel upgrade.
by doug - 06/14/2019 2:35 PM
YouTube does not display?
by BlackMale - 06/09/2019 6:34 AM
Removing a redirect?
by Baldeagle - 06/01/2019 4:50 PM
Who's Online Now
0 registered members (), 46 guests, and 305 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Basil
Basil
New Mexico
Posts: 584
Joined: August 2006
Show All Member Profiles 
Forum Statistics
Forums35
Topics35,303
Posts192,585
Members11,855
Most Online978
Jun 24th, 2007
Random Gallery Image
Latest Photos
Land Rocks
Cozy Places
Trees
Retreats
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190623)