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:

1 Like