2

Hi guys I would like to export categories from one of my magento installations and import it into another:

version for the export is 1.9.2.1 and 1.9.2.4 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 1.9.2.1 over to the 1.9.2.4 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:

dumped 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:

category page

0

Eav attribute ids mismatch. Both installations have the attributes in different order. So, caused incorrect references and so forth.

| improve this answer | |

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.