I am working on Magento 1.7 and have very little experience with magento. I created few blocks and pages now I want to add them to staging site. but the staging Database is different form my local Database as there is some other peoples are also working on same project so what will the write way to migrate my local static blocks to staging site. any module or any database migration ? Any help will be appreciated.

  • Only static block or with cms pages ? Nov 4, 2016 at 6:29
  • few blocks and few new pages also Nov 4, 2016 at 6:34

1 Answer 1


First backup below tables from staging site.

Export below tables from local site and import it to staging site.

cms_page and cms_page_store

cms_block and cms_block_store

  • export & import tables as SQL dump? Nov 4, 2016 at 6:40
  • Yes import and export it from phpmyadmin. Nov 4, 2016 at 6:44
  • but problem with this if other team made any changes in these tables this will overwrite there changes and can be a problem Nov 4, 2016 at 6:45
  • Then you have to import row only which you need to on staging. Nov 4, 2016 at 6:56

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.