MySQL Update from 5.6 to 5.7

bipolarmorgan · 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!

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.

bipolarmorgan · 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 · 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

I have also contemplated on upgrading to Maria DB too!

Lumpy Burgertushie · 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.

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

bipolarmorgan · 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

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.

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.

warmweer · 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.)

bipolarmorgan · 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

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?

3Di · 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.

bipolarmorgan · 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?

bipolarmorgan · 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 ....

3Di · 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.

sakm · 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

3Di · 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.