워드프레스 SITE building - 영문 버전 wordpresse1 의 백업

정말 사이트 하나를 건물을 짓는 것 처럼 하나의 워드프레스 사이트를 짓고있다. 

 Woocemmerce와 레볼루션 슬라이딩 템플릿을 통한 프런트 페이지 작업까지 구축한

 로컬 서버를 백업하였다. 휴~

다음은 서버 BD 내 도메인이 변경된 내역. 

replace  with   use regex

db details

name

user

pass

host

tables

 all tables

 select tables

columns to exclude (optional, comma separated)

columns to include only (optional, comma separated)

actions

   /  

In the process of replacing http://localhost/wordpresse1 with http://localhost/wordpresse2 we scanned 40 tables with a total of 8948 rows, 448 cells were changed. 446db updates were performed. It all took 106.3740001 seconds.

Table	Rows	Cells changed	Updates	Seconds
wp_chat_lines	0	0	0	0.3960001
wp_chat_logs	0	0	0	0.3980000
wp_chat_online	0	0	0	0.3820000
wp_chat_visitors	0	0	0	0.4099998
wp_sharebar	4	0	0	0.5690000
wp_yith_wcwl	0	0	0	0.4490001
wp_yith_wcwl_lists	0	0	0	0.3930001
wp_bp_activity	1	0	0	0.3930001
wp_bp_activity_meta	0	0	0	0.4640000
wp_bp_notifications	0	0	0	0.3830001
wp_bp_notifications_meta	0	0	0	0.4059999
wp_bp_xprofile_data	2	0	0	0.4270000
wp_bp_xprofile_fields	1	0	0	0.3870001
wp_bp_xprofile_groups	1	0	0	0.5820000
wp_bp_xprofile_meta	0	0	0	0.4230001
wp_commentmeta	275	0	0	0.6139998
wp_comments	118	0	0	0.5830002
wp_links	0	0	0	0.4140000
wp_options	637	5 view changes	5	1.4510000
wp_postmeta	6467	2 view changes	2	1.2849998
wp_posts	562	441 view changes	439	57.7079999
wp_revslider_css	53	0	0	2.5650001
wp_revslider_layer_animations	2	0	0	0.7910001
wp_revslider_settings	0	0	0	1.4239998
wp_revslider_sliders	7	0	0	0.9630001
wp_revslider_slides	25	0	0	0.7600000
wp_signups	0	0	0	0.5319998
wp_term_relationships	280	0	0	0.9830000
wp_term_taxonomy	145	0	0	2.0990000
wp_terms	145	0	0	1.2960000
wp_usermeta	62	0	0	0.8350000
wp_users	2	0	0	0.8480000
wp_woocommerce_api_keys	0	0	0	0.4549999
wp_woocommerce_attribute_taxonomies	8	0	0	1.5369999
wp_woocommerce_downloadable_product_permissions	0	0	0	16.7370000
wp_woocommerce_order_itemmeta	43	0	0	0.4289999
wp_woocommerce_order_items	7	0	0	0.4529998
wp_woocommerce_tax_rate_locations	0	0	0	3.6390002
wp_woocommerce_tax_rates	1	0	0	0.5609999
wp_woocommerce_termmeta	100	0	0	0.9500000

delete

 Once you’re done click the delete me button to secure your server