Application Launcher

Cloud Platform

MySQL 8.0 to 5.7 backport database driver for upgrading to Drupal 11

Cloud Platform

MySQL 8.0 to 5.7 backport database driver for upgrading to Drupal 11

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.

Enabling the MySQL 8.0 to 5.7 backport database driver module

Use this procedure to:

Enable the module in Drupal 11.
Enable the module in Drupal 10 to upgrade an existing application from Drupal 10 to Drupal 11.

Prerequisites

Before enabling the module, ensure that you have:

Cloud Platform account
PHP 8.3 installed on your environment

Installing the MySQL backport module

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 statements that conditionally load the settings on Acquia environments:

Drupal 11 requires MySQL 8.0 or later. However, many of the Cloud Platform environments are still not upgraded to MySQL 8.0.

Enabling the MySQL 8.0 to 5.7 backport database driver module

Use this procedure to:

Enable the module in Drupal 11.
Enable the module in Drupal 10 to upgrade an existing application from Drupal 10 to Drupal 11.

Prerequisites

Before enabling the module, ensure that you have:

Cloud Platform account
PHP 8.3 installed on your environment

Installing the MySQL backport module

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 statements that conditionally load the settings on Acquia environments:

Drupal 11 requires MySQL 8.0 or later. However, many of the Cloud Platform environments are still not upgraded to MySQL 8.0.

Enabling the MySQL 8.0 to 5.7 backport database driver module

Use this procedure to:

Enable the module in Drupal 11.
Enable the module in Drupal 10 to upgrade an existing application from Drupal 10 to Drupal 11.

Prerequisites

Before enabling the module, ensure that you have:

Cloud Platform account
PHP 8.3 installed on your environment

Installing the MySQL backport module

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 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';
}

Important

For Site Factory, acsf-init overwrites direct edits to the settings.php file. To persist the backport driver, you must add the require statement to a script in the factory-hooks/pre-settings-php/ directory.

In the administrative menu, click Extend and search for MySQL 5.7.

Select the MySQL 5.7 checkbox and click Install.

In the Reports section, navigate to Status report.

Verify that the system does not report any error for the database system version.

Uninstalling the MySQL 8.0 to 5.7 backport database driver module

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.
Select the MySQL 5.7 checkbox and click Uninstall.
Remove the module from your codebase by running the following command:
```
composer remove 'drupal/mysql57'
```

Posting questions or comments for the MySQL Backport module

To post module-related questions or comments for its maintainer or to report bugs or other issues, file an issue in the issue queue.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

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';
}

Important

In the administrative menu, click Extend and search for MySQL 5.7.

Select the MySQL 5.7 checkbox and click Install.

In the Reports section, navigate to Status report.

Verify that the system does not report any error for the database system version.

Uninstalling the MySQL 8.0 to 5.7 backport database driver module

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.
Select the MySQL 5.7 checkbox and click Uninstall.
Remove the module from your codebase by running the following command:
```
composer remove 'drupal/mysql57'
```

Posting questions or comments for the MySQL Backport module

To post module-related questions or comments for its maintainer or to report bugs or other issues, file an issue in the issue queue.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

MySQL 8.0 to 5.7 backport database driver for upgrading to Drupal 11

Enabling the MySQL 8.0 to 5.7 backport database driver module

Prerequisites

Installing the MySQL backport module

MySQL 8.0 to 5.7 backport database driver for upgrading to Drupal 11

Enabling the MySQL 8.0 to 5.7 backport database driver module

Prerequisites

Installing the MySQL backport module

MySQL 8.0 to 5.7 backport database driver for upgrading to Drupal 11

Enabling the MySQL 8.0 to 5.7 backport database driver module

Prerequisites

Installing the MySQL backport module

Frequently asked questions

I use the MySQL 8.0 to 5.7 backport database driver module to use MySQL 5.7 in a Drupal 11 site. Do I need to uninstall this module before the platform upgrade to MySQL 8.0?

Frequently asked questions

I use the MySQL 8.0 to 5.7 backport database driver module to use MySQL 5.7 in a Drupal 11 site. Do I need to uninstall this module before the platform upgrade to MySQL 8.0?

Uninstalling the MySQL 8.0 to 5.7 backport database driver module

Posting questions or comments for the MySQL Backport module

Did not find what you were looking for?

Uninstalling the MySQL 8.0 to 5.7 backport database driver module

Posting questions or comments for the MySQL Backport module

Frequently asked questions

I use the MySQL 8.0 to 5.7 backport database driver module to use MySQL 5.7 in a Drupal 11 site. Do I need to uninstall this module before the platform upgrade to MySQL 8.0?

Did not find what you were looking for?