导出block,widget,更新到magento

update core_config_data set value ='http://1922.test/' where path ='web/unsecure/base_url';

update core_config_data set value ='http://1922.test/' where path ='web/secure/base_url';

mysqldump -u [username] -p[password] [database] cms_page cms_page_store cms_block cms_block_store | grep INSERT | sed 's/INSERT INTO/REPLACE INTO/' > cms-export.sql

mysql -u [username] -p[password] [database] < cms-export.sql

cms导出

mysqldump -u myuser -p mypwd cms_page cms_page_store cms_block cms_block_store | grep INSERT | sed 's/INSERT INTO/REPLACE INTO/' > cms-export.sql

mysqldump -u myuser -p mypwd widget widget_instance widget_instance_page widget_instance_page_layout core_layout_update | grep INSERT | sed 's/INSERT INTO/REPLACE INTO/' > widget-export.sql