Magento Open Source, 1.9.x

Magento 1.x Security Patch Notice
For Magento Open Source 1.5 to 1.9, Magento is providing software security patches through June 2020 to ensure those sites remain secure and compliant. Visit our information page for more details about our software maintenance policy and other considerations for your business.

Database Repair

The Database Repair tool compares a corrupt database with a target database, and updates the target so it has the same structure as the corrupt database. During the process, Database Repair does the following:

  • Adds missing tables, or repairs them so they have the same engine type and charset
  • Adds missing fields or repairs them
  • Removes inconsistent data from tables with broken foreign key references
  • Adds missing foreign keys and indexes

A typical use case for this tool is to fix the database of an existing Magento installation that has some of the errors mentioned above. To learn more, see: Magento 1.x Database Repair Tool.

Database Repair Tool

Important! Do not use DB Repair on a production site without testing it first in a development environment. Always back up the original database before using DB Repair.