trying to dump my cms_block and cms_page tables to new working Database. I get the Duplicate Entry for Primary Key ...what is the best way to go about this? when I export tables from old db I have Disable foreign key checks as well.

  • it doesn't make any sense - even when i dump just data only no structure, i still get the same Duplicate entry '5' for key 'PRIMARY' – roger Feb 26 '16 at 17:35
  • In the new database, did you truncate those tables before importing? Something is getting caught up. – kab8609 Feb 26 '16 at 20:57
  • I cannot truncate a due to primary key – roger Feb 26 '16 at 22:46

As far as I understood you just need CMS contents to be migrated.

It is not a good idea to inject data in you DB coming from another installation, you can really break something.

Just remeber the two rules of the Magento Fight Club: Never change the core and never inject your DB ;)

Why don't you use an import/export module like this: https://www.magentocommerce.com/magento-connect/export-import-cms-pages-blocks.html

I think it would be a safer method.

I did not try it, but I think it will fit your needings.

| 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.