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

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


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, 2019 at 8:05
  • have u checked ? Jul 24, 2019 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, 2019 at 8:12
  • i have do this at my end. Getting all cms and block content successfully :) Jul 24, 2019 at 8:19
  • if you get your result please accept my answer . Jul 24, 2019 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.