MySQL Update from 5.6 to 5.7

Discussion of non-phpBB related topics with other phpBB.com users.
Forum rules
General Discussion is a bonus forum for discussion of non-phpBB related topics with other phpBB.com users. All site rules apply.
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5871
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by thecoalman »

3Di wrote: Fri Jun 28, 2019 6:19 pm Sorry but, all of this it doesn't looks to me as a support's ticket / request.
There has been a general relaxation of the rules for this but clearly not a phpBB support issue.
https://www.phpbb.com/rules/#server-support
Although we are happy to help if possible, problems with server configuration (Apache, *nix, etc.) or general php coding may better be better asked at sites specifically dedicated to the support of the particular product involved. We are unlikely to have the same expertise in those areas as dedicated support sites.
I'm going to move this to general discussion forum.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
bipolarmorgan
Registered User
Posts: 112
Joined: Tue Jul 07, 2015 7:27 pm
Name: I dont

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan »

Sorry... :oops:
Heo32
Registered User
Posts: 207
Joined: Sat Jan 07, 2017 10:08 pm

Re: MySQL Update from 5.6 to 5.7

Post by Heo32 »

A backup of phpBB through the ACP can be used and restored on a newer database version. I speak from experience.

Official link:
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html

There is also YouTube for visual instructions.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by warmweer »

Using the same database after upgrading MySQL 5.6 to 5.7, shouldn't give a problem (but again, always take a backup just in case).
However moving from MySQL to Mariadb as far as I know (and on my first try that was confirmed) can cause problems. Exporting the SQL and importing in Mariadb is recommended.
bipolarmorgan
Registered User
Posts: 112
Joined: Tue Jul 07, 2015 7:27 pm
Name: I dont

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan »

So far, I'm not getting anything more than I already had folks. The idea was someone who has done this process comment, instead I'm getting people second guessing my understanding of the situation. Please only bother to reply if you have something useful to input.

That being said, I know I will have to backup the db before this upgrade, and that I can do this several different ways. Also, I know it all works once completed, as I have a devserver which runs mariadb using an older version of my production db. So ya, enough of that info guys... give me the goods, is it really as simple as backup, upgrade, import ?!
bipolarmorgan
Registered User
Posts: 112
Joined: Tue Jul 07, 2015 7:27 pm
Name: I dont

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan »

thecoalman wrote: Fri Jun 28, 2019 11:18 pm
3Di wrote: Fri Jun 28, 2019 6:19 pm Sorry but, all of this it doesn't looks to me as a support's ticket / request.
There has been a general relaxation of the rules for this but clearly not a phpBB support issue.
https://www.phpbb.com/rules/#server-support
Although we are happy to help if possible, problems with server configuration (Apache, *nix, etc.) or general php coding may better be better asked at sites specifically dedicated to the support of the particular product involved. We are unlikely to have the same expertise in those areas as dedicated support sites.
I'm going to move this to general discussion forum.
Curious, WHEN does it become a support issue? After I attempt it and it fails?!
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by Lumpy Burgertushie »

is it really as simple as backup, upgrade, import ?!
yes.
bipolarmorgan
Registered User
Posts: 112
Joined: Tue Jul 07, 2015 7:27 pm
Name: I dont

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan »

Lumpy Burgertushie wrote: Wed Jul 03, 2019 4:52 am
is it really as simple as backup, upgrade, import ?!
yes.
Thanks Lumpy!
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by warmweer »

bipolarmorgan wrote: Wed Jul 03, 2019 4:31 am ...
Curious, WHEN does it become a support issue? After I attempt it and it fails?!
The point was (and is) that it's not a phpBB support issue. General discussion seems a better place (it doesn't really make a difference whether it's a phpBB database or something else.)
bipolarmorgan wrote: Wed Jul 03, 2019 4:30 am So far, I'm not getting anything more than I already had folks. The idea was someone who has done this process comment, instead I'm getting people second guessing my understanding of the situation. Please only bother to reply if you have something useful to input.
Who decides what is useful or not? What if I said I do it all the time without encountering a problem. Would you blindly accept that? (I wouldn't!).

The answer had been given already by 3Di, and that's also the recommendation on specialised sites.
3Di wrote: Fri Jun 28, 2019 3:23 am The transfer of databases between different versions of MySQL or MariaDB should be performed by EXPORT / IMPORT of SQL files using phpMyAdmin or a similiar tools of your choice.
bipolarmorgan
Registered User
Posts: 112
Joined: Tue Jul 07, 2015 7:27 pm
Name: I dont

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan »

warmweer wrote: Wed Jul 03, 2019 7:11 am
bipolarmorgan wrote: Wed Jul 03, 2019 4:31 am ...
Curious, WHEN does it become a support issue? After I attempt it and it fails?!
The point was (and is) that it's not a phpBB support issue. General discussion seems a better place (it doesn't really make a difference whether it's a phpBB database or something else.)
bipolarmorgan wrote: Wed Jul 03, 2019 4:30 am So far, I'm not getting anything more than I already had folks. The idea was someone who has done this process comment, instead I'm getting people second guessing my understanding of the situation. Please only bother to reply if you have something useful to input.
Who decides what is useful or not? What if I said I do it all the time without encountering a problem. Would you blindly accept that? (I wouldn't!).

The answer had been given already by 3Di, and that's also the recommendation on specialised sites.
3Di wrote: Fri Jun 28, 2019 3:23 am The transfer of databases between different versions of MySQL or MariaDB should be performed by EXPORT / IMPORT of SQL files using phpMyAdmin or a similiar tools of your choice.
You are hilarious. Beat a dead horse much? The real question was never really answered, so just stop replying guys...
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5871
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by thecoalman »

bipolarmorgan wrote: Wed Jul 03, 2019 4:31 am Curious, WHEN does it become a support issue? After I attempt it and it fails?!
phpBB supports the version of MySql you are upgrading too, if it fails there is likely other issue unrelated to phpBB. It's already been tested by the developers and who knows how many users so bugs are unlikely.

There is a lot of people here with great knowledge. If it's phpBB related you'll get support, if not minimally you should get pointed in the right direction to fix whatever issue you have.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by canonknipser »

I would recommend to read the official documentation -> https://dev.mysql.com/doc/refman/5.7/en/upgrading.html esp. the section Logical upgrade
Heo32
Registered User
Posts: 207
Joined: Sat Jan 07, 2017 10:08 pm

Re: MySQL Update from 5.6 to 5.7

Post by Heo32 »

bipolarmorgan wrote: Wed Jul 03, 2019 4:30 am Please only bother to reply if you have something useful to input.
Please do not tell people to not reply when they are providing free voluntary information to your ungrateful self.

That being said, I'm not sure if you're a narcissist or a douche-bag. Maybe you're both. But I do know that after reading your comment, I don't think you're worth anyone's time with that dictating, spoiled and entitled attitude.
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by AmigoJack »

As per https://dev.mysql.com/doc/refman/5.7/en ... shell.html nothing is deprecated or removed that would remotely relate to a phpBB installation.
Post Reply

Return to “General Discussion”