How to Export Static Blocks and CMS Pages in Bulk from Local to Online in Magento 1.9

cms-pagesmagento-1.9page-contentstatic-blockstatic-content

I have a localhost version of Magento and another which is already in Hostgator. My changes on files I can ftp quick and easily, of course. But I would like to know if there is some faster way to "upload" my static blocks and cms pages I've created in localhost instead of having to create all them again, manually (it would be a very painful task, for sure), maybe through phpmyadmin or through an awesome "free-preferred" extension.

Thank u

Best Answer

For that you can export database table of CMS block and CMS page from phpmyadmin and import that in server phpmyadmin , make sure when export, export only data not structure and data.

4 tables:

  • cms_block

  • cms_block_store

  • cms_page

  • cms_page_store

First take backup.

Related Topic