Magento Commerce, 1.14.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.


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.