| Name | Information | Report | ||
|---|---|---|---|---|
| database | mysql (5.6.41-84.1) |
Checked with Hosting, they cannot upgrade to 5.7. for my account type.
Is there any way to bypass the MySql version upgrade?
Upgrading to 3.10 - MySql version
Number of replies: 12Re: Upgrading to 3.10 - MySql version
If you have MySQL 5.6, you have to be content with Moodle rel. 3.9 (LTS).
Ref.
Re: Upgrading to 3.10 - MySql version
Unfortunately, that doesn't seem to be an option, I tried with my hosting provider and they were unable to offer it either. Only siteground seems to be offering 5.7 and only to new accounts. I have a 3-year-old account and they are forcing me to buy a new one if I want moodle 3.10, it looks like cpanel doesn't support 5.7 and all new account come with something call "Site Tools" instead of Cpanel
Re: Upgrading to 3.10 - MySql version
New SiteGround hosting is on Google servers ... believe it or not.
'SoS', Ken
Re: Upgrading to 3.10 - MySql version
Well, CPanel has supported MySQL 5.7 almost two whole years now, since CPanel version 70 came out. And MySQL 5.7 itself has been out for a whole five years now. MySQL 5.6 will reach its end of support from Oracle next February 2021. Staying on 5.6 long term is not an option.
It is entirely a hosting company's decision if they want you to pay more to get 5.7. But any hosting company that says they do MySQL but doesn't *actually* have or support 5.7 is incompetent and no one should be using them.
It is entirely a hosting company's decision if they want you to pay more to get 5.7. But any hosting company that says they do MySQL but doesn't *actually* have or support 5.7 is incompetent and no one should be using them.
Re: Upgrading to 3.10 - MySql version
Don't even get me started. I am looking for ANY hosting solution that offer SQL 5.7 and the biggest names none of them offer them, I am planning on leaving siteground after they pull this "if you want 5.7 pay more" scheme.
Re: Upgrading to 3.10 - MySql version
@Daniel
How much per month are you willing to spend? How much are you willing to learn in admin of a VPS/Cloud server? Those questions not for response here in forums but for your consideration when 'shopping' for hosting a moodle.
The key to getting what you want when you want it is to build your own. There are providers, like Rackspace, that will allow customer to choose a VPS (un-managed by them) by specs and OS ... like CentOS 8, Ubuntu 20.x, Debian X. They are minimal when it comes to apps ... get only sshd to begin.
You, then set up your repos, and build what you want.
MySQL has their own repo. Don't use the OS versions.
For PHP ... remi offers PHP 7 versions and their setup similar to MySQL repo set up.
All nix's offer Apache or Nginx from their base repo.
Just gotta dig the net to find who offers what you seek!
My 2 cents.
'SoS', Ken
Re: Upgrading to 3.10 - MySql version
If the biggest names don't do a good job, then go for a smaller name.
To repeat a Mantra heard in this forum: Shared hosting don't cut for a professional Moodle site. The starter level is VPS.
Re: Upgrading to 3.10 - MySql version
+1
Buy an unmanaged server and learn some command line stuff. It's not that difficult and it's good for you. You can then run what you like. I would stick Ubuntu 20.04LTS Server on it. Ken wouldn't
Buy an unmanaged server and learn some command line stuff. It's not that difficult and it's good for you. You can then run what you like. I would stick Ubuntu 20.04LTS Server on it. Ken wouldn't
There are also a number of web-based admin tools you can run on your server if you like. If in doubt, try Cockpit.
Re: Upgrading to 3.10 - MySql version
How true.Howard! We all pick our own 'poisons'!
There is also Webmin for a panel.
'SoS', Ken
Re: Upgrading to 3.10 - MySql version
Daniel,
As Visvanath says, the smaller companies can often be better.
Take a look at Reclaim Hosting https://reclaimhosting.com/. They are a small hosting company co-founded by a former instructional technologist in the US as a place for schools and students to get shared or full hosting, domains, VPS, and now they have a cloud hosting offering too. Anyone can use them of course, you don't have to be in education. They are very open source savvy, have solid support, and reasonable pricing. (And a sense of humor.) And you won't get any of this "Pay more for the current, secure version" baloney from them either.
Randy
As Visvanath says, the smaller companies can often be better.
Take a look at Reclaim Hosting https://reclaimhosting.com/. They are a small hosting company co-founded by a former instructional technologist in the US as a place for schools and students to get shared or full hosting, domains, VPS, and now they have a cloud hosting offering too. Anyone can use them of course, you don't have to be in education. They are very open source savvy, have solid support, and reasonable pricing. (And a sense of humor.) And you won't get any of this "Pay more for the current, secure version" baloney from them either.
Randy
Re: Upgrading to 3.10 - MySql version
Hello !
My solution:
- edit <moodle_path>/admin/environment.xml and change database requirement from 5.7 to 5.6 for moodle 3.10
- reload upgrade url https://<your_moodle_site>/admin/
- Complete the installation
My server environment was OK except the database. i have 5.6 rather than 5.7.
For the moments my site it's working fine but I'm not feel secure about these procedure.
Regards !
Re: Upgrading to 3.10 - MySql version
Well, I'd agree that one should be a little concerned. ;)
Not sure anyone but a true DB/Moodle coding expert could know and tell ya for sure. So, might be wise to look at what one has to do to get server where you can control versions of not only MySQL but PHP etc.
It's always been upwards ... and just round the corner is yet 40 of Moodle.
'SoS', Ken