Drupal 11 requires MySQL 8.0 or later. However, many of the Cloud Platform environments are still not upgraded to MySQL 8.0.
On such environments, if you want to install a new Drupal 11 application or upgrade an existing application from Drupal 10 to Drupal 11, you can use the MySQL 8.0 to 5.7 backport database driver module.
Use this procedure to:
Before enabling the module, ensure that you have:
To install the MySQL 8.0 to 5.7 backport database driver module:
Add the MySQL 8.0 to 5.7 backport database driver module by running the following command:
composer require 'drupal/mysql57:^1.0'In the settings.php file, add the following line before the Acquia require line outside any if statements that conditionally load the settings on Acquia environments:
require DRUPAL_ROOT . '/modules/contrib/mysql57/settings.inc';
// Example Acquia Cloud Require Line
if (file_exists('/var/www/site-php/application/application-settings.inc')) {
require '/var/www/site-php/application/applcatopm-settings.inc';
}
In the administrative menu, click Extend and search for MySQL 5.7.
Verify that the system does not report any error for the database system version.
After your Cloud Platform environment is upgraded to MySQL 8, you can uninstall the MySQL Backport module with the following steps:
From the settings.php file, remove the following line:
require DRUPAL_ROOT . '/modules/contrib/mysql57/settings.inc';In the administrative menu, click Extend and select Uninstall.
The system displays a list of modules that you can uninstall.
Remove the module from your codebase by running the following command:
composer remove 'drupal/mysql57'To post module-related questions or comments for its maintainer or to report bugs or other issues, file an issue in the issue queue.
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Tue Sep 24 2024 18:15:12 GMT+0000 (Coordinated Universal Time)