{"id":349,"date":"2020-04-16T22:21:02","date_gmt":"2020-04-16T14:21:02","guid":{"rendered":"http:\/\/128.199.245.30\/wordpress\/?p=349"},"modified":"2020-04-23T05:25:38","modified_gmt":"2020-04-22T21:25:38","slug":"wordpress-website-recovery","status":"publish","type":"post","link":"https:\/\/unama.website\/?p=349","title":{"rendered":"WordPress Website Recovery"},"content":{"rendered":"\n<h2>\u5099\u4efd-Backup<\/h2>\n\n\n\n<p>\u6211\u7684\u72c0\u6cc1\u662f\u539f\u672c\u4f7f\u7528DigitalOcean\u7684\u4f3a\u670d\u5668\u67b6\u7ad9\uff0c\u906d\u53d7\u653b\u64ca\u5f8c\u88ab\u5b98\u65b9\u95dc\u9589\u7db2\u8def\uff0c\u5b98\u65b9\u63a8\u85a6\u89e3\u6c7a\u65b9\u6cd5\u5c31\u662f\u67b6\u65b0\u6a5f\u5668\u628a\u8cc7\u6599\u5f9e\u820a\u6a5f\u5668\u642c\u904e\u53bb\u3002<\/p>\n\n\n\n<p>\u6240\u4ee5\u9019\u88e1\u6211\u5011\u53ea\u8981\u4f86\u5099\u4efdWordpress\u7684\u8cc7\u6599\u5eab\u5c31\u884c\u4e86<\/p>\n\n\n\n<p>\u5148\u7528mysqldump\u628awordpress\u7684\u8cc7\u6599\u5eab\u532f\u51fa<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u username -p dbname > dbname.sql<\/code><\/pre>\n\n\n\n<p>\u4f60\u8981\u53ea\u532f\u51fa\u67d0\u500btable\u4e5f\u884c(\u53ea\u6709wp_posts\u548cwp_postmeta\u9019\u5169\u500btable\u662f\u5fc5\u8981)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -p --user=username dbname tableName > tableName.sql<\/code><\/pre>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u6211\u5011\u8981\u67b6\u8a2d\u4e00\u500b\u65b0\u7684Wordpress\u500b\u4eba\u7db2\u7ad9\uff0c\u4e4b\u5f8c\u518d\u5c07\u820a\u8cc7\u6599\u5eab\u7684\u8cc7\u6599\u653e\u9032\u53bb\u5c31\u597d\u3002\u53ef\u4ee5\u53c3\u8003\u9019\u7bc7<a href=\"?p=369\">\u5229\u7528DigitalOcean\u67b6\u8a2dWordpress\u500b\u4eba\u7db2\u7ad9(Ubuntu 18.04)<\/a><\/p>\n\n\n\n<p>\u67b6\u597d\u5f8c\u6211\u5011\u8981\u4f86\u958b\u59cb\u642c\u8cc7\u6599\uff0c\u524d\u9762\u6211\u5011\u5df2\u7d93\u5099\u4efd\u597d\u4e86\u8cc7\u6599\u5eab\uff0c\u6240\u4ee5\u73fe\u5728\u6211\u5011\u8981\u5c07\u820a\u6a5f\u5668\u7528Recovery ISO\u4f86\u958b\u6a5f<\/p>\n\n\n\n<p>\u9032\u5230\u4f60\u6a5f\u5668\u88e1\u7684Recovery\u9078\u9805\uff0c\u9078\u64c7Boot from Recovery ISO<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6-1024x471.png\" alt=\"\" class=\"wp-image-383\" width=\"580\" height=\"266\" srcset=\"https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6-1024x471.png 1024w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6-300x138.png 300w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6-768x353.png 768w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6-587x270.png 587w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/\u64f7\u53d6.png 1154w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/figure>\n\n\n\n<p>\u5148\u5c07\u820a\u6a5f\u5668\u95dc\u6a5f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo poweroff<\/code><\/pre>\n\n\n\n<p>\u518d\u5c07\u53f3\u4e0a\u89d2\u7684power\u6253\u958b\u5f8c\u7528console\u9032\u5165<\/p>\n\n\n\n<p>\u61c9\u8a72\u6703\u770b\u5230:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>This droplet is booted to the DigitalOcean recovery environment.\nWhen you are finished, you may set your Droplet to boot from\nthe local disk again via the DigitalOcean control panel.\n\nThis rescue environment is based on Ubuntu 18.04.\n\n* Network access and SSH have been enabled automatically *\n* SSH Host keys do NOT match while using this rescue system *\n\nRoot Password has randomly been set to:\n  exam-ple0-1234-5678\nYour are strongly encouraged to use SSH keys. To import your SSH\npublic keys:\n  From Github:        ssh-import-id gh:&lt;Github user name>\n  From Launchpad.net: ssh-import-id lp:&lt;launchpad user name>\n--------------------------------------------------------------------\n1. Mount your Disk Image &#91;Not Mounted]\n2. Check Filesystem\n3. Reset Droplet Root Password\n4. Configure Keyboard\n5. Attempt to 'chroot' into installed system\n6. Interactive Shell &#91;\/bin\/bash]\nChoose (1-6) and press Enter to continue.<\/code><\/pre>\n\n\n\n<p>\u90781. Mount your Disk Image\u5f8c\uff0c\u9019\u6642\u4f60\u518d\u9032\u65b0\u6a5f\u5668\u7684root\u5e33\u865f(\u56e0\u70ba\u7b49\u7b49\u8981\u628a\u5099\u4efd\u8cc7\u6599\u5eab\u5012\u9032\u65b0\u7684\u6a5f\u5668\u4e0a\u7684mysql)<\/p>\n\n\n\n<p>\u5728\u65b0\u6a5f\u5668\u4e0a\u7528sftp\u628a\u820a\u8cc7\u6599\u6293\u56de\u4f86<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sftp root@your_old_server_ip_or_remote_hostname<\/code><\/pre>\n\n\n\n<p>\u5bc6\u78bc\u5728\u4f60\u4f7f\u7528recovery mode\u5f8c\u4ed6\u6703\u7d66\u4f60\u4e00\u7d44\u65b0\u7684\uff0c\u6bcf\u6b21\u958b\u6a5f\u90fd\u6703\u8b8a<\/p>\n\n\n\n<p>\u9032\u53bb\u5f8c\u8acb\u5230\/mnt\u5e95\u4e0b\u53bb\u62ff\u8cc7\u6599\uff0c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/mnt\nget remoteFile\nget -Pr remoteDirectory<\/code><\/pre>\n\n\n\n<p>\u8acb\u81f3\u5c11\u628awp_posts.sql\u548cwp_postmeta.sql\u548cwordpress\/wp-content\/uploads\u8cc7\u6599\u593e\uff0c\u9019\u88e1\u6211\u662f\u76f4\u63a5\u5c07\u820a\u7684wordpress\u6574\u500b\u6253\u5305\uff0c\u7522\u751f\u4e00\u500bwordpress.sql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>get wordpress.sql\nget -Pr wordpress\/wp-content\/uploads<\/code><\/pre>\n\n\n\n<p>\u4e4b\u5f8c\u96e2\u958bsftp\uff0c\u5148\u66ff\u820a\u7684wordpress\u8cc7\u6599\u5275\u4e00\u500b\u8cc7\u6599\u5eab<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -u root -p\nCREATE DATABASE wordpresstemp DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;\nexit;<\/code><\/pre>\n\n\n\n<p>   \u518d\u628awordpress.sql\u5012\u9032wordpresstemp\u8cc7\u6599\u5eab\u4e2d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> mysql -u root -p wordpresstemp &lt; wordpress.sql<\/code><\/pre>\n\n\n\n<p>\u9019\u6642\u5019\u53ef\u4ee5\u6253\u958bphpmyadmin\u64cd\u4f5c\u628a\u5169\u5f35table(wp_posts\u548cwp_postmeta\u79fb\u5230\u65b0\u7684wordpress\u8cc7\u6599\u5eab)<\/p>\n\n\n\n<p>\u9edewordpresstemp(\u820a\u8cc7\u6599\u5eab)\u88e1\u8981\u8907\u88fd\u7684\u8868(wp_posts\u548cwp_postmeta)\uff0c\u5f8c\u9ede\u64cd\u4f5c<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"344\" height=\"410\" src=\"https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/image-2.png\" alt=\"\" class=\"wp-image-384\" srcset=\"https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/image-2.png 344w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/image-2-252x300.png 252w, https:\/\/unama.website\/wp-content\/uploads\/2020\/04\/image-2-227x270.png 227w\" sizes=\"(max-width: 344px) 100vw, 344px\" \/><\/figure>\n\n\n\n<p>\u56e0\u70ba\u65b0\u7684wordpress\u8cc7\u6599\u5eab\u88e1\u4e5f\u6709wp_posts\u548cwp_postmeta\u9019\u5169\u5f35\u8868\uff0c\u6240\u4ee5\u4f60\u53ef\u4ee5\u5148\u628a\u9019\u5169\u5f35\u8868\u5206\u5225\u6539\u6210wp_posts_backup\u548cwp_postmeta_backup\uff0c\u518d\u8907\u88fd\u820a\u7684\u8868\u904e\u53bb\uff0c\u6211\u5728\u57f7\u884c\u7684\u7684\u6642\u5019\u6703\u9047\u5230\u4ed6\u8aaa\u7121\u6cd5\u9806\u5229\u8907\u88fd\u56e0\u70bapost_date_gmt\u88e1\u4e0d\u5141\u8a310000-00-00 00:00:00\u7684\u503c\uff0c\u6211\u7684\u89e3\u6c7a\u8fa6\u6cd5\u662f\u56dephpmyadmin\u9996\u9801\u5f8c\u9ede&#8221;\u8b8a\u6578&#8221;\u7136\u5f8c\u627e\u5230&#8221;sql mode&#8221;\u9ede&#8221;\u7de8\u8f2f&#8221;\u628a\u88e1\u9762\u7684&#8221;NO_ZERO_DATE&#8221;\u79fb\u9664\u6389\uff0c\u9019\u6a23\u61c9\u8a72\u5c31\u80fd\u9806\u5229\u8907\u88fdtable\u4e86\u3002<\/p>\n\n\n\n<p>\u8907\u88fd\u597d\u5f8c\uff0c\u8a18\u5f97\u9084\u8981\u5c07\u820a\u7684uploads\u8cc7\u6599\u593e\u5e95\u4e0b\u7684\u6771\u897f\u642c\u5230\u65b0\u6a5f\u5668\u4e0a\u7684uploads\u8cc7\u6599\u593e\u88e1(\u53ef\u80fd\u8981\u7a0d\u5fae\u6ce8\u610f\u4e00\u4e0b\u6b0a\u9650)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mv old_wordpress\/wp-content\/uploads\/* \/var\/www\/html\/wordpress\/wp-content\/uploads\/<\/code><\/pre>\n\n\n\n<p>\u8907\u88fdwp_posts\u8ddfwp_postmeta\u7684\u6b65\u9a5f\u662f\u4e00\u6a23\u7684\uff0c\u6700\u5f8c\u518d\u56de\u982d\u6253\u958bhttp:\/\/ip_or_your_domain\uff0c\u61c9\u8a72\u5c31\u80fd\u770b\u5230\u4f60\u7684\u820a\u6587\u7ae0\u3001\u5716\u90fd\u56de\u4f86\u4e86QQ\uff0c\u4e0d\u904e\u5206\u985e\u7684\u90e8\u5206\u53ef\u80fd\u5c31\u8981\u91cd\u65b0\u5206\u4e86\u3002<\/p>\n\n\n\n<p>\u7a0d\u5fae\u6aa2\u67e5\u4e00\u4e0b\u6240\u6709\u6587\u7ae0\u5927\u81f4\u90fd\u6c92\u554f\u984c\uff0c\u53ef\u4ee5\u628a\u820a\u6a5f\u5668\u653e\u5e7e\u5929\u518d\u522a\u9664\u3002\u9084\u6c92\u57df\u540d\u7684\u53ef\u4ee5\u53c3\u8003\u9019\u7bc7<a href=\"?p=274\">HOW TO REGISTER A NEW DOMAIN<\/a>\uff0c\u5982\u679c\u4f60\u5df2\u7d93\u6709\u8cfc\u8cb7\u57df\u540d\uff0c\u8a18\u5f97\u628a\u820a\u7684ip\u6539\u6210\u65b0\u7684ip\uff0c\u61c9\u8a726\u500b\u5c0f\u6642\u5de6\u53f3\u5c31\u597d\u4e86\uff0c\u7b49\u57df\u540dip\u66f4\u6539\u751f\u6548\u5f8c\u6211\u5011\u5c31\u53ef\u4ee5\u6e96\u5099\u4f86\u7528SSL\u6191\u8b49\u4e86! \u53ef\u4ee5\u53c3\u8003\u9019\u7bc7<a href=\"?p=385\">Configuring Let\u2019s Encrypt SSL Certificate for Nginx on Ubuntu 18.04<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5099\u4efd-Backup \u6211\u7684\u72c0\u6cc1\u662f\u539f\u672c\u4f7f\u7528DigitalOcean\u7684\u4f3a\u670d\u5668\u67b6\u7ad9\uff0c\u906d\u53d7\u653b\u64ca\u5f8c\u88ab\u5b98\u65b9\u95dc\u9589\u7db2\u8def\uff0c\u5b98\u65b9\u63a8\u85a6\u89e3\u6c7a\u65b9\u6cd5\u5c31\u662f\u67b6\u65b0\u6a5f\u5668\u628a\u8cc7\u6599\u5f9e\u820a\u6a5f\u5668\u642c\u904e\u53bb\u3002 \u6240\u4ee5\u9019&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/unama.website\/?p=349\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/posts\/349"}],"collection":[{"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unama.website\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=349"}],"version-history":[{"count":5,"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions"}],"predecessor-version":[{"id":396,"href":"https:\/\/unama.website\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions\/396"}],"wp:attachment":[{"href":"https:\/\/unama.website\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unama.website\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unama.website\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}