{"id":46,"date":"2023-08-27T18:41:14","date_gmt":"2023-08-27T10:41:14","guid":{"rendered":"https:\/\/techblog.hxdy2013.com\/?p=46"},"modified":"2023-09-17T17:55:20","modified_gmt":"2023-09-17T09:55:20","slug":"wordpress-site-migration","status":"publish","type":"post","link":"https:\/\/techblog.hxdy2013.com\/?p=46","title":{"rendered":"WordPress Site Migration"},"content":{"rendered":"<div class=\"wp-block-post-date\"><time datetime=\"2023-08-27T18:41:14+08:00\">2023-08-27<\/time><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u672c\u6587\u8bb2\u8ff0\u5982\u4f55\u5c06\u57fa\u4e8eWordPress\u521b\u5efa\u7684\u7f51\u7ad9\u8fc1\u79fb\u5230\u5176\u4ed6\u670d\u52a1\u5668\u3002<br>\u540e\u9762\u5047\u5b9a\u65e7WP\u7ad9\u70b9\u57df\u540d\u662f<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp.old.com<\/mark>\uff0c\u7ad9\u70b9\u6587\u4ef6\u5728\u65e7\u670d\u52a1\u5668<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">\/var\/www\/wp.old.com<\/mark>\u76ee\u5f55\u4e2d\uff1b\u65b0WP\u7ad9\u70b9\u57df\u540d\u662f<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp.new.com<\/mark>\uff0c\u7ad9\u70b9\u6587\u4ef6\u51c6\u5907\u653e\u5728\u65b0\u670d\u52a1\u5668<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">\/var\/www\/wp.new.com<\/mark>\u76ee\u5f55\u4e2d\uff0c\u5b98\u65b9WP\u6587\u4ef6\u5df2\u89e3\u538b\u5728\u6b64\u76ee\u5f55\u4e2d\uff0cApache2\/Nginx\u5df2\u53d1\u5e03<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp.new.com<\/mark>\u7ad9\u70b9\u3002<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5907\u4efd\u65e7\u670d\u52a1\u5668<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5907\u4efd\u6570\u636e\u5e93<\/strong><br>MariaDB\/MySQL\u6570\u636e\u5e93\u53ef\u4ee5\u501f\u52a9phpMyAdmin\u5c06WP\u6570\u636e\u5e93\u5168\u90e8\u5bfc\u51fa\u4e3a<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp_backup.sql<\/mark>\u6587\u4ef6\u3002<br>SQLite\u6570\u636e\u5e93\u7b80\u5355\u590d\u5236\u6570\u636e\u5e93\u6587\u4ef6\u5373\u53ef\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5907\u4efd\u4e0a\u4f20\u7684\u6587\u4ef6<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/uploads<\/code><\/mark>\u76ee\u5f55\u6253\u5305<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zcvf uplodas.tar.gz .\/uploads\/*<\/code><\/mark>    # \u5c06uplodas\u76ee\u5f55\u6253\u5305\u5230uploads.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5907\u4efd\u4e3b\u9898<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/themes<\/code><\/mark>\u76ee\u5f55\u6253\u5305<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zcvf themes.tar.gz .\/themes\/*<\/code><\/mark>    # \u5c06themes\u76ee\u5f55\u6253\u5305\u5230themes.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5907\u4efd\u63d2\u4ef6<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/plugins<\/code><\/mark>\u76ee\u5f55\u6253\u5305<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zcvf plugins.tar.gz .\/plugins\/*<\/code><\/mark>    # \u5c06plugins\u76ee\u5f55\u6253\u5305\u5230plugins.tar.gz<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5c06\u6253\u5305\u6587\u4ef6\u4e0a\u4f20\u5230\u65b0\u670d\u52a1\u5668<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uff08\u7565\uff09<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5728\u65b0\u670d\u52a1\u5668\u4e0a\u6062\u590d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6062\u590d\u4e3b\u9898<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>themes.tar.gz<\/code><\/mark>\u91ca\u653e\u5230<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/themes<\/code><\/mark>\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zxvf themes.tar.gz<\/code><\/mark>    # \u91ca\u653ethemes.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6062\u590d\u63d2\u4ef6<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>plugins.tar.gz<\/code><\/mark>\u91ca\u653e\u5230<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/plugins<\/code><\/mark>\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zxvf plugs.tar.gz<\/code><\/mark>    # \u91ca\u653eplugins.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6062\u590d\u4e0a\u4f20\u7684\u6587\u4ef6<\/strong><br>\u5c06<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>uploads.tar.gz<\/code><\/mark>\u91ca\u653e\u5230<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>\/wp-content\/uploads<\/code><\/mark>\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.test.com\/wp-content<\/code><\/mark>    # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>tar -zxvf uploads.tar.gz<\/code><\/mark>    # \u91ca\u653euploads.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6062\u590d\u6570\u636e\u5e93<\/strong><br>MariaDB\/MySQL\u6570\u636e\u5e93\u53ef\u4ee5\u501f\u52a9phpMyAdmin\u5c06<mark><mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp_backup.sql<\/mark><\/mark>\u6587\u4ef6\u5bfc\u5165\u3002<br>SQLite\u6570\u636e\u5e93\u7b80\u5355\u590d\u5236\u6570\u636e\u5e93\u6587\u4ef6\u5373\u53ef\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8bbe\u7f6e\u65b0\u670d\u52a1\u5668MariaDB\/MySQL\u6570\u636e\u5e93\u8bbf\u95ee\u51ed\u636e<\/strong><br>\u5982\u65b0\u670d\u52a1\u5668\u6570\u636e\u5e93\u662fMariaDB\/MySQL\uff0c\u8fd8\u9700\u8981\u5728<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\">wp-config.php<\/mark>\u6587\u4ef6\u4e2d\u4fdd\u5b58\u6570\u636e\u5e93\u8bbf\u95ee\u51ed\u636e\u3002<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>cd \/var\/www\/wp.new.com<\/code><\/mark>    # \u5207\u6362wp.new.com\u4e3a\u5f53\u524d\u76ee\u5f55<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mv wp-config{-sample,}.php<\/code><\/mark>    # \u4ecewp-config-sample.php\u521b\u5efawp-config.php<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>vi wp-config.php<\/code><\/mark>    # \u7f16\u8f91wp-config.php<br>\u53c2\u8003\u4ee5\u4e0b\u586b\u5199\u6570\u636e\u5e93\u8bbf\u95ee\u51ed\u636e\uff1a<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>define('DB_NAME', 'new_db');<\/code><\/mark> # \u65b0\u6570\u636e\u5e93\u540d\u79f0<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>define('DB_USER', 'new_db_username');<\/code><\/mark> # \u65b0\u6570\u636e\u5e93\u8d26\u53f7<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>define('DB_PASSWORD', 'new_db_password');<\/code><\/mark> # \u65b0\u6570\u636e\u5e93\u5bc6\u7801<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>define('DB_HOST', 'localhost');<\/code><\/mark> # \u6570\u636e\u5e93\u670d\u52a1\u5668\u5730\u5740\uff0c\u901a\u5e38\u90fd\u662flocalhost<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4fee\u6539\u57df\u540d<\/strong><br>\u5728\u65b0\u6570\u636e\u5e93\u4e2d\u6267\u884c\u4ee5\u4e0bSQL\u67e5\u8be2\uff0c\u5c06WP\u7ad9\u70b9\u9996\u9875\u5730\u5740+\u5bfc\u822a\u83dc\u5355\u4e2d\u7684\u9996\u9875\u5730\u5740\u3001Posts\uff08\u6587\u7ae0\uff09\u4e2d\u7684\u56fe\u7247\u94fe\u63a5\u5730\u5740\u6539\u6210\u65b0\u57df\u540d\uff1a<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>UPDATE wp_options SET option_value = replace (option_value, 'https:\/\/wp.old.com', 'https:\/\/wp.new.com') WHERE option_name = 'home' OR option_name = 'siteurl';<br>UPDATE wp_posts SET post_content = replace (post_content, 'https:\/\/wp.old.com', 'https:\/\/wp.new.com');<br>UPDATE wp_posts SET guid = replace (guid, 'https:\/\/wp.old.com', 'https:\/\/wp.new.com');<\/code><\/mark><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u8bb2\u8ff0\u5982\u4f55\u5c06\u57fa\u4e8eWordPress\u521b\u5efa\u7684\u7f51\u7ad9\u8fc1\u79fb\u5230\u5176\u4ed6\u670d\u52a1\u5668\u3002\u540e\u9762\u5047\u5b9a\u65e7WP\u7ad9\u70b9\u57df\u540d\u662fwp.old.com\uff0c\u7ad9\u70b9\u6587\u4ef6\u5728\u65e7\u670d\u52a1\u5668\/var\/www\/wp.old.com\u76ee\u5f55\u4e2d\uff1b\u65b0WP\u7ad9\u70b9\u57df\u540d\u662fwp.new.com\uff0c\u7ad9\u70b9\u6587\u4ef6\u51c6\u5907\u653e\u5728\u65b0\u670d\u52a1\u5668\/var\/www\/wp.new.com\u76ee\u5f55\u4e2d\uff0c\u5b98\u65b9WP\u6587\u4ef6\u5df2\u89e3\u538b\u5728\u6b64\u76ee\u5f55\u4e2d\uff0cApache2\/Nginx\u5df2\u53d1\u5e03wp.new.com\u7ad9\u70b9\u3002 \u5907\u4efd\u65e7\u670d\u52a1\u5668 \u5907\u4efd\u6570\u636e\u5e93MariaDB\/MySQL\u6570\u636e\u5e93\u53ef\u4ee5\u501f\u52a9phpMyAdmin\u5c06WP\u6570\u636e\u5e93\u5168\u90e8\u5bfc\u51fa\u4e3awp_backup.sql\u6587\u4ef6\u3002SQLite\u6570\u636e\u5e93\u7b80\u5355\u590d\u5236\u6570\u636e\u5e93\u6587\u4ef6\u5373\u53ef\u3002 \u5907\u4efd\u4e0a\u4f20\u7684\u6587\u4ef6\u5c06\/wp-content\/uploads\u76ee\u5f55\u6253\u5305cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zcvf uplodas.tar.gz .\/uploads\/* # \u5c06uplodas\u76ee\u5f55\u6253\u5305\u5230uploads.tar.gz \u5907\u4efd\u4e3b\u9898\u5c06\/wp-content\/themes\u76ee\u5f55\u6253\u5305cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zcvf themes.tar.gz .\/themes\/* # \u5c06themes\u76ee\u5f55\u6253\u5305\u5230themes.tar.gz \u5907\u4efd\u63d2\u4ef6\u5c06\/wp-content\/plugins\u76ee\u5f55\u6253\u5305cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zcvf plugins.tar.gz .\/plugins\/* # \u5c06plugins\u76ee\u5f55\u6253\u5305\u5230plugins.tar.gz \u5c06\u6253\u5305\u6587\u4ef6\u4e0a\u4f20\u5230\u65b0\u670d\u52a1\u5668 \uff08\u7565\uff09 \u5728\u65b0\u670d\u52a1\u5668\u4e0a\u6062\u590d \u6062\u590d\u4e3b\u9898\u5c06themes.tar.gz\u91ca\u653e\u5230\/wp-content\/themes\u76ee\u5f55cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zxvf themes.tar.gz # \u91ca\u653ethemes.tar.gz \u6062\u590d\u63d2\u4ef6\u5c06plugins.tar.gz\u91ca\u653e\u5230\/wp-content\/plugins\u76ee\u5f55cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zxvf plugs.tar.gz # \u91ca\u653eplugins.tar.gz \u6062\u590d\u4e0a\u4f20\u7684\u6587\u4ef6\u5c06uploads.tar.gz\u91ca\u653e\u5230\/wp-content\/uploads\u76ee\u5f55cd \/var\/www\/wp.test.com\/wp-content # \u5207\u6362wp-content\u4e3a\u5f53\u524d\u76ee\u5f55tar -zxvf uploads.tar.gz [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46"}],"version-history":[{"count":3,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions"}],"predecessor-version":[{"id":184,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions\/184"}],"wp:attachment":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}