All the new category changes are done on staging server, and now i wanted to move it to live. I cannot move complete database, since both the database are not synchronized and i don't want to loss sales/order/customer data.

If i only move table that are specific to category, will this work without any issue? I also wanted to retain category ID after moving it to production server.

Can anyone please guide which all table i need to move to make this category migration successful.

Thank You.


Yes, just export all tables starting catalog_ (check 'disable foreign key checks' and 'add drop tables if exist') in database and import into the other database. This will ensure the necessary relationships between products and categories still remain intact (to clarify, this will import all products and what categories they are assigned to etc).

This then won't touch sales/orders/customers etc but just import everything related to the catalog.

You may find this useful as well.

  • but product tables start with catalog_. And the OP does not want to move them...I think. – Marius Jun 11 '14 at 12:39
  • Yeh, mentioned that in my answer - this will only work if it is ONLY the customers/sales/orders he doesn't want to touch of course. – zigojacko Jun 11 '14 at 12:40
  • Thank you guys for your immediate answer. I will definitely try this. – Trimantra Software Solution Jun 11 '14 at 13:26
  • If i move all table starting with catalog_category, will this work? I have Flat Catalog enabled. I don't want to touch product tables if its possible. – Trimantra Software Solution Jun 11 '14 at 13:31
  • 1
    I did it. I just move all table ( Catalog_category_*) except index table, And it worked good for me. – Trimantra Software Solution Jun 12 '14 at 6:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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