Magento Database Repair Tool

The Magento Database Repair Tool is available on the download page.

The Database Repair Tool compares 2 databases (reference and target), and updates the target database so it has the same structure as the reference database by doing the following:

  • Adds missing tables, or repairs them to have the same engine type and charset.

  • Adds missing fields or repairs them.

  • Removes inconsistent data from tables that have broken foreign key references.

  • Adds missing foreign keys and indexes.

For full features and instructions please refer to this wiki post.