Hi guys I would like to export categories from one of my magento installations and import it into another:
version for the export is 188.8.131.52 and 184.108.40.206 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 220.127.116.11 over to the 18.104.22.168 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: