Recover categories and products from a broken Magento database

Last modified by Nick Weisser on Fri, June 25, 2010 08:52
Source|Old Revisions  

This is an old revision of the document!

I had a client who inadvertently upgraded from Magento to via Virtualmin script installer and ended up with a broken store. We were then trying to connect the database to a fresh install of to no avail, so we decided to just extract all catalog* and eav* tables of the spoiled database and import them into a clean database.

Once you disabled foreign key constraints, this is pretty easy to do. This can be easily achieved by adding

SET foreign_key_checks = 0;

to the top of your sql queries for steps 2 and 3:

  1. export all catalog* and eav* tables (via phpMyAdmin) from the old database
  2. delete all catalog* and eav* tables with these sql quieries in the new database
  3. import all exported tables from step 1 into the new database


Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs