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.