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: 3223
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 » 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.

User avatar
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » Fri Jun 28, 2019 11:38 pm

Sorry... :oops:

Heo32
Registered User
Posts: 113
Joined: Sat Jan 07, 2017 10:08 pm

Re: MySQL Update from 5.6 to 5.7

Post by Heo32 » Sun Jun 30, 2019 6:34 pm

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
Registered User
Posts: 2160
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: MySQL Update from 5.6 to 5.7

Post by warmweer » Mon Jul 01, 2019 4:33 pm

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.

User avatar
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » 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.

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 ?!

User avatar
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » Wed Jul 03, 2019 4:31 am

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: 66342
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by Lumpy Burgertushie » Wed Jul 03, 2019 4:52 am

is it really as simple as backup, upgrade, import ?!
yes.

User avatar
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » Wed Jul 03, 2019 5:04 am

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
Registered User
Posts: 2160
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: MySQL Update from 5.6 to 5.7

Post by warmweer » 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.

User avatar
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » Wed Jul 03, 2019 9:07 am

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: 3223
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 » Wed Jul 03, 2019 11:36 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?!
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.

User avatar
canonknipser
Registered User
Posts: 1995
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 » Wed Jul 03, 2019 6:48 pm

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: 113
Joined: Sat Jan 07, 2017 10:08 pm

Re: MySQL Update from 5.6 to 5.7

Post by Heo32 » Thu Jul 04, 2019 1:09 am

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: 5589
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by AmigoJack » Thu Jul 04, 2019 5:47 am

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”