Hi guys I would like to export categories from one of my magento installations and import it into another:
version for the export is 22.214.171.124 and 126.96.36.199 for the import, so should have pretty much same database structure.
What tables do I need to export to "transfer" the categories as they are in 188.8.131.52 over to the 184.108.40.206 magento.
So, I guess what I am after is a list of the tables that I have to export from my Magento that houses the categories I require ?
I have just attempted the following but didn't work:
firstly took a data only dump of the tables:
Then I went and truncuated the following:
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_category_entity`; TRUNCATE TABLE `catalog_category_entity_datetime`; TRUNCATE TABLE `catalog_category_entity_decimal`; TRUNCATE TABLE `catalog_category_entity_int`; TRUNCATE TABLE `catalog_category_entity_text`; TRUNCATE TABLE `catalog_category_entity_varchar`; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `catalog_category_product_index`; SET FOREIGN_KEY_CHECKS = 1;
Then using the mysql command to restore from a dump I ran my dump.
Now going into the backend manage category page it shows all funny: