2

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?

Improve this question
2

1 Answer 1

Reset to default
2

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

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

Your Answer

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

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