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

  • magentocommerce.com/magento-connect/… I found one extension as well you can use it. Commented Apr 5, 2017 at 5:08
  • If you want to get only those block that you have created for change then just open CMS block and cms page table then select those rows to be imported, then there will be options given below to Export, click on it. And you can use this file to import data to live server. If you had selected different stores for CMS block or page then just crate a new SQL file for CMS block/ store and fill new block IDs and store IDs that you want to and run it in query Windows. Or you can use above given magento extension by @Magento2 Learner.
    – Kumar M
    Commented Apr 5, 2017 at 5:31

3 Answers 3


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.


In Magento 1.9, all static blocks and CMS pages are located in 4 tables: cms_block_store, cms_block, cms_page_store, cms_page.

Open phpmyadmin in localhost and export them. After that, you can import to phpmyadmin in Hostgator (don't forget to backup).

Hope it helps

  • In addition, is there some extension maybe that is able to perform that "magic", like exporting cms pages, static blocks, maybe some config etc? Commented Apr 5, 2017 at 4:00

In Magento 1.9, all static blocks and CMS pages are located into following 4 tables in database:

  1. cms_block_store

  2. cms_block

  3. cms_page_store

  4. cms_page

Do to your Database and export them. After that, you need to import these tables into your new database. Don't forget to backup.

  • Great man, it worked! The only thing is that I had to disable the foreign key checking to 0 and, after importing data, to 1, because I was getting an error. Commented Apr 7, 2017 at 2: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.