Magento Open Source, 1.9.x

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.