Update requirements docs with a note about MySQL 8 issues that may affect some sites

Created on 1 March 2019, almost 6 years ago
Updated 14 March 2024, 9 months ago

Some MySQL 8 could definitely affect some sites, and significantly. Add a note to the database requirements about them.

Original issue read:

Currently I have a Drupal 8 site in production with a database on MySQL 5.7

How to migrate a MySQL 5.7 database to MySQL 8.0?

Do I just need to export my Drupal 8 database from MySQL 5.7 and import it into a MySQL 8.0 database?

Is there any manipulation to do on the tables ?

📌 Task
Status

Active

Version

11.0 🔥

Component
Documentation 

Last updated about 5 hours ago

No maintainer
Created by

🇫🇷France zenimagine

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇺🇸United States tr Cascadia

    I added the original issue text in the issue summary, as my subsequent reply doesn't really make sense unless you can see what I was replying to. Also, the OP was asking a fair question - changing major DB version can cause problems on any site in general, and it is wise to look for guidance before attempting it on a complex Drupal site.

    Regardless, in the case of upgrading a Drupal site to MySQL 8, there are certain situations that we know about, notably with the Voting API module and the Group module, where updating the database can cause data destruction because of 🐛 Make Drupal\Core\Database\Schema work with reserved keywords for naming Fixed for example.

    Since it doesn't seem that this problem will every be fixed in D9, documenting a way to avoid this critical problem is the least that could be done. But it needs to be done in a manner that ensures people will see it BEFORE attempting the upgrade. Because after failing the database upgrade is too late.

  • 🇮🇳India ajay547

    Hi Team,

    Do we have any document for safely updating mysql 5.7 to mysql 8.0 for Drupal 9.5 website.

    Regards

Production build 0.71.5 2024