sql to reproduce a set of magento cms_page and cms_block

update core_store set name='United States' where code='en'; update core_store set name='United Kingdom' where code='uk'; insert into core_store values (4,'uk',1,1,'United Kingdom',0,1); insert into cms_page (title,root_template,meta_keywords,meta_description ,identifier ,content_heading,content,creation_time,update_time,is_active,sort_order ,layout_update_xml,custom_theme ,custom_root_template ,custom_layout_update_xml ,custom_theme_from,custom_theme_to) (select title,root_template,meta_keywords,meta_description ,identifier ,content_heading,content,creation_time,update_time,is_active,sort_order ,layout_update_xml,custom_theme ,custom_root_template ,custom_layout_update_xml ,custom_theme_from,custom_theme_to from cms_page where page_id in (select page_id from cms_page_store where store_id=1)); insert into cms_page_store (page_id,store_id) (select page_id,'4' [...]

Source: http://www.yuyangblog.com/2011/07/sql-to-reproduce-a-set-of-magento-cms_page-and-cms_block/

Hartmann luggage luggage wheels pink luggage