DocumentationCommerceConfiguration Guide

[PaaS only]{class="badge informative" title="Applies to Adobe Commerce on Cloud projects (Adobe-managed PaaS infrastructure) and on-premises projects only."}

Revert from Split Database

Last update: Fri Apr 24 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer
NOTE
This feature is available for Adobe Commerce instances only.

For Adobe Commerce customers who have implemented Split Database, the following topic describes how to revert or migrate back to a single database. We recommend that Adobe Commerce merchants currently using Split Database and plan to upgrade to 2.4.2 and later review these steps.

Reverting from a split database to a single database involves creating backups of the magento_quote and magento_sales databases before loading them into the single magento_main database.

In this example, we log in to all three databases, which are installed on the same host (magento2-mysql) as the “root” user. You must replace these values with the appropriate values for your databases.

  1. Create a backup of the magento_quote database:

    code language-shell 
    mysqldump -h "magento2-mysql" -u root -p magento_quote > ./quote.sql

  2. Create a backup of the magento_sales database:

    code language-shell 
    mysqldump -h "magento2-mysql" -u root -p magento_sales > ./sales.sql

  3. Load the magento_quote database into the magento_main database:

    code language-shell 
    mysql -h "magento2-mysql" -u root -p magento_main < ./quote.sql

  4. Load the magento_sales database into the magento_main database:

    code language-shell 
    mysql -h "magento2-mysql" -u root -p magento_main < ./sales.sql

  5. Drop the magento_sales database:

    code language-shell 
    mysql -h "magento2-mysql" -u root -p -e "DROP DATABASE magento_sales;"

  6. Drop the magento_quote database:

    code language-shell 
    mysql -h "magento2-mysql" -u root -p -e "DROP DATABASE magento_quote;"

  7. Remove the deployment configuration for checkout and sales in the connections and resources sections of the env.php file.

  8. Restore foreign keys:

    code language-shell 
    bin/magento setup:upgrade

Verify your work

To verify that your single database implementation is working properly, perform the following tasks and verify that data is added to the magento_main database tables using a database tool like phpMyAdmin:

  1. Verify that foreign keys have been restored. For example, the QUOTE_STORE_ID_STORE_STORE_ID key in the quote database table.
  2. Verify that customers can place orders from the storefront.
  3. Verify that orders created before reverting the split database to a single database are available in the Admin.
recommendation-more-help
386822bd-e32c-40a8-81c2-ed90ad1e198c