Local MySQL 8.xx.xx live MySQL 5.7.x move local > live 8?

Support
,
1

I noticed my live server is still using MySQL 5.7, because WordPress gave me a warning / notification. I also noticed my Local version of my site is running on MySQL version 8.0.35 and without any problems.

Now my question is: can i just delete everything on my live server and reinstall WordPress with a newer version of MySQL and then just upload the Local version with WPvivid Backup and i’m good to go?

This seems the easiest option?

System Details

  • Local Version: Version 9.2.9+6887

  • Operating System (OS) and OS version: Windows 11

2

Hi @Koeraedf4312!

Do you have a managed web host or your own server set up?

Deleting everything on the live server likely won’t update MySQL alone. You’ll have to figure out whether your Host or your Server set up has an option for upgrading MySQL to a more recent version. Once that is done you could migrate your Local site over top of the new site if you have updates or changes to import.

As always, make sure to take a fresh backup before doing any deleting, migrating, etc :green_heart:

2 Likes
3

Thanks for the reply. I contacted my host and they said they are planning to update to a newer MySQL, so i guess i wait some more…

1 Like
4

Sounds good @Koeraedf4312! Best of luck :slight_smile:

5

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.