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.