Sometimes, your e-commerce website is on the localhost or on a different server with your live site, whereas you create all CMS pages & static blocks on dev site. Therefore, it is troublesome to import/ export CMS pages & static blocks from the dev to the live site. This tutorial will help you to solve this problem at ease.
In Magento 1, all CMS pages and static blocks are saved in the following 4 tables:
Hence, if you need to copy the content, just simply export data from these tables and then import again to your live site database. It can be done easily through Phpmyadmin.
In Phpmyadmin, let’s click on the Export button. On the Export page, you must select the 4 above options and check on the Data column to export them.
After that, go to Phpmyadmin of your live site and select Import function to import the file again.
In case you don’t have Phpmyadmin, it will be more complicated. You have to use the SSH command to export and import these tables. Here are 2 commands to export and import specific tables in a 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
If you import/ export CMS pages and static blocks by this way, it would help you to save a lot of time. Hope that you guys find this tutorial useful. See you in the next tutorial.