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
bipolarmorgan
Registered User
Posts: 68
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

MySQL Update from 5.6 to 5.7

Post by bipolarmorgan » Sun Jun 23, 2019 10:02 am

Has anyone had any issues upgrading to MySQL 5.7 while using phpBB 3.2.x ?? I am trying to avoid potential MySQL vulnerabilities, without breaking the forum. I would prefer to know in advance if there will be any "hangups" during this process.

Please let me know if you need more information to give me an answer ... Thanks in advance! :ugeek:

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21145
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: MySQL Update from 5.6 to 5.7

Post by Mick » Sun Jun 23, 2019 10:39 am

According to the specs it’s ok https://www.phpbb.com/support/docs/en/3 ... uickstart/

Make backups of everything just in case.
"The more connected we get the more alone we become" - Kyle Broflovski

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 » Sun Jun 23, 2019 11:18 am

Mick wrote:
Sun Jun 23, 2019 10:39 am
According to the specs it’s ok https://www.phpbb.com/support/docs/en/3 ... uickstart/

Make backups of everything just in case.
Thanks, but I was hoping for someone with experience in this update (IE: have done this update), to see if there are nuances that may cause an issue. While I can see from your information that it should run properly on 5.7, I was wondering specifically if there are known issues when updating from 5.6 to 5.7 ... if that makes sense. And of course I would make backups just in case, as that is upgrade 101 ... LOL

I'm assuming I can just hop into the WHM and upgrade mysql without any issues and just want to confirm my assumption...

Thanks for any information provided!

sakm
Registered User
Posts: 519
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by sakm » Sun Jun 23, 2019 10:00 pm

bipolarmorgan wrote:
Sun Jun 23, 2019 11:18 am
Mick wrote:
Sun Jun 23, 2019 10:39 am
According to the specs it’s ok https://www.phpbb.com/support/docs/en/3 ... uickstart/

Make backups of everything just in case.
Thanks, but I was hoping for someone with experience in this update (IE: have done this update), to see if there are nuances that may cause an issue. While I can see from your information that it should run properly on 5.7, I was wondering specifically if there are known issues when updating from 5.6 to 5.7 ... if that makes sense. And of course I would make backups just in case, as that is upgrade 101 ... LOL

I'm assuming I can just hop into the WHM and upgrade mysql without any issues and just want to confirm my assumption...

Thanks for any information provided!
I'm in the same position too

I have been putting it off for this reason although I suspect everything will go fine and if not my host will be able to bail me out :lol:

I have also contemplated on upgrading to Maria DB too!

User avatar
Lumpy Burgertushie
Registered User
Posts: 66327
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by Lumpy Burgertushie » Sun Jun 23, 2019 11:01 pm

my mother was a software test engineer for xerox back when they were the big thing in PCs ( before bill gates started ).
she taught me about computers and started me off. the best advice she ever gave me was " backup and then click the button and see what happens".

the "backup" part sometimes included physically backing up away from the machine as well as making backups. :lol:

anyway, as long as you have backups you really can't break anything so bad that a few clicks won't recover.

go for it.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

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 » Mon Jun 24, 2019 4:37 am

I'm surprised this hasn't come up with anyone yet ... I would have figured someone would have backed up their db and bit the proverbial bullet and upgraded their mysql by now. I've been waiting just because I have to take my website(s) offline to do this update and I hate taking the website(s) offline.... I really need to get a better redundant setup someday...

Anyway, thanks for the input guys, I'll update here after I bite the bullet myself and do the update so future users can have some peace of mind prior to the starting of this process themselves.
sakm wrote:
Sun Jun 23, 2019 10:00 pm
I'm in the same position too

I have been putting it off for this reason although I suspect everything will go fine and if not my host will be able to bail me out :lol:

I have also contemplated on upgrading to Maria DB too!
Ya, I have Maria DB on my devserver and it works fine, so I might upgrade to maria db on the production side as well... If you do hit the button before I do, feel free to reply back here and let us know how your experience was. If I beat ya to it, I'll post here as well and let you know how it went.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50501
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by stevemaury » Mon Jun 24, 2019 3:22 pm

bipolarmorgan wrote:
Mon Jun 24, 2019 4:37 am
I'm surprised this hasn't come up with anyone yet ... I would have figured someone would have backed up their db and bit the proverbial bullet and upgraded their mysql by now.
If a million people have done this and there was no problem, you would not read about it here.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
warmweer
Registered User
Posts: 2159
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 » Tue Jun 25, 2019 8:02 pm

Generally it' not recommended to continue using the original database after upgrading MySQL. The recommedation is to export the databse, upgrade MySQL and then import the backup.
Having said this: I've always just upgraded without needing to export first and then import and never encountered a problem.
BUT!! taking a backup before any manipulation is a no-brainer. (And if you're using MyISAM engine, a physical copy of the database directory is as good a backup as an export - do not do this with InnoDB > guaranteed corrupt.)
My board's not broken, it just went peculiar

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 3:18 am

bipolarmorgan wrote:
Mon Jun 24, 2019 4:37 am
sakm wrote:
Sun Jun 23, 2019 10:00 pm
I'm in the same position too

I have been putting it off for this reason although I suspect everything will go fine and if not my host will be able to bail me out :lol:

I have also contemplated on upgrading to Maria DB too!
Ya, I have Maria DB on my devserver and it works fine, so I might upgrade to maria db on the production side as well... If you do hit the button before I do, feel free to reply back here and let us know how your experience was. If I beat ya to it, I'll post here as well and let you know how it went.
I'm definitely contemplating going to MariaDB instead of MySQL ... anyone have thoughts on this?

User avatar
3Di
Former Team Member
Posts: 13773
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by 3Di » 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.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

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 3:36 am

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.
I did do some research and am aware of this. And as always, I know the golden rule - BACKUP BACKUP BACKUP... But any experience with this upgrade?

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 3:37 am

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.
And by similar tools, will a mysqldump work as a backup to import into MariaDB ? I'm reading also that I must go to version 10.0 of MariaDB from MySQL 5.6 ....

User avatar
3Di
Former Team Member
Posts: 13773
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by 3Di » Fri Jun 28, 2019 6:19 pm

Sorry but, all of this it doesn't looks to me as a support's ticket / request.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

sakm
Registered User
Posts: 519
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by sakm » Fri Jun 28, 2019 7:06 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.
Might be best moving it in to phpBB Discussion

Its always worth reading other peoples configurations and if they have ever had problems migrating to different versions of sql :)

User avatar
3Di
Former Team Member
Posts: 13773
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: MySQL Update from 5.6 to 5.7

Post by 3Di » Fri Jun 28, 2019 7:18 pm

Sure, but since I've been quoted twice and received notifications I don't want it to seem like I'm ignoring people, rightly in my personal logic I offer support in the support area if I think it's due.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

Post Reply

Return to “General Discussion”