1

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento. Both have same Magento version. I do not want to migrate the complete DB as I have many junk orders/customers/products etc.. All I want to migrate is the stores, Content blocks, pages, and basically all content related data.

What is the best way to achieve this?

1

All CMS pages and static blocks are saved in the following 4 tables:

  • cms_page
  • cms_page_store
  • cms_block
  • cms_block_store

Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database.
Export:

mysqldump -u -p database_name cms_block cms_block_store cms_page cms_page_store > content.sql


Import:

mysql -u -p database_name < content.sql

  • cms block/pages has reference to store tables also, won't there be any issue as the magento is fresh? Also if I dump these tables won't there be foreign key issues? – Tester Jul 24 at 8:05
  • have u checked ? – Hafiz Arslan Jul 24 at 8:10
  • I mean even if I do this, there will be issue because the tables do not include the store tables. – Tester Jul 24 at 8:12
  • i have do this at my end. Getting all cms and block content successfully :) – Hafiz Arslan Jul 24 at 8:19
  • if you get your result please accept my answer . – Hafiz Arslan Jul 24 at 10:08

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.