Migrating to a newer database server

  • Greetings,

    I’ve been with my web host (U2-web/Cooini) for so long that I’m in the ‘legacy’ databases. I asked about updating my database from mysql 5.1.73 to an updated version. They have shifted to MariaDB, and I received the following response from them regarding my request:

    Your mysql service can be moved to a different mysql server running a newer version of mysql. There would not be a method to test before the migration happened, though something could be worked out. The new mysql version would be running MariaDB 10.3, equivalent to MySQL 5.7+ . If you check your script compatibility for that version and confirm no issues, then migrating should be seamless. The actual migration would be done on this side.

    I’m a bit of a newbie with dealing with the database itself, and am hoping someone can assist me in how to ‘check the script compatibility.’

    I’ve been looking around the web for help, but haven’t found the solution yet.

    Any advice?

    Thanks!

    • This topic was modified 3 years, 5 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 1 replies (of 1 total)

  • MariaDB is a drop-in replacement for MySQL, so there shouldn’t be any compatibility issues.

    And WordPress, as of this writing, officially supports “MySQL version 5.6 or greater” OR “MariaDB version 10.1 or greater”, as stated on the official requirements page: https://www.ads-software.com/about/requirements/

    So there shouldn’t be any issue with the upgrade… unless something is missing or misconfigured on the new MariaDB server, which will be your host should be able to easily address.

    But, as with any major operations on your website, make sure to take a fresh backup just before you begin the migration!

    As for the “compatibility script”, WordPress doesn’t have any (at least not officially) because the requirements are very basic and very commonly available even on the cheapest of shared hosting servers: https://www.ads-software.com/about/requirements/

    Good luck!

Viewing 1 replies (of 1 total)
  • The topic ‘Migrating to a newer database server’ is closed to new replies.

Tags