We Have a problem where by a category was deleted and then recreated causing problems as the id changed, Is it possible to restore just the product tables as do not want to loose changes which have occured to other tables such as orders, customers etc.

Has Anyone restored all the catalog_ tables and did it work? Or is there something which might cause further problems?

  • I would not recommend restoring "some tables" you will most likely have problems in the future. Where are you having issues with the id? Did you delete the category from admin? Commented Nov 7, 2013 at 21:05
  • Do you have a database backup with you? If so create a new database and install the backup and re-install your project
    – Sukeshini
    Commented Nov 8, 2013 at 10:10

1 Answer 1


You can just restore the catalog_* tables from a dump. Just be sure, that you insert the AUTOINCREMENT values as well. But a standard dump does what you need.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.