{"id":2044,"date":"2011-11-04T21:35:30","date_gmt":"2011-11-04T13:35:30","guid":{"rendered":"http:\/\/www.jpuyy.com\/blog\/?p=2044"},"modified":"2012-09-30T10:29:49","modified_gmt":"2012-09-30T02:29:49","slug":"debian-restore-data-and","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=2044","title":{"rendered":"debian\u7535\u8111\u635f\u574f\u540e\u6570\u636e\u548c\u6570\u636e\u5e93\u6062\u590d\u5c0f\u8bb0"},"content":{"rendered":"<p>\u90a3\u53f0\u7535\u8111\u662f\u7528\u6765\u7ec3\u624b\u548c\u6a21\u62df\u8bba\u575b\u7684<\/p>\n<p>\u524d\u51e0\u5929\u6709\u4e00\u665a\u88ab\u65b0\u624b\u5f04\u4e86ubuntu\u7684\u6e90\u5f3a\u5236\u66f4\u65b0\u4e86\uff0c\u7136\u540e\u7b2c\u4e8c\u5929\u6821\u533a\u505c\u7535<\/p>\n<p>\u8fd9\u53f0\u7535\u8111\u53c8\u7834<\/p>\n<p>\u5f00\u59cb\u7528u\u76d8\u548ccdrom\uff0clan\u5404\u79cd\u542f\u52a8\u90fd\u8bd5\u4e86\uff0c\u65e0\u679c\u3002\u8981\u4e0d\u5c31\u662f\u5230\u68c0\u6d4b\u786c\u4ef6\u65f6\u5361\u4f4f\uff0c\u8981\u4e0d\u5c31\u662f\u65e0\u6cd5\u8bc6\u522b\uff0c\u5176\u5b9e\u6211\u5e94\u8be5\u60f3\u5230\u7684\uff0c\u80af\u5b9a\u662f\u786c\u76d8\u7684\u5f15\u5bfc\u533a\u51fa\u4e86\u95ee\u9898\u3002<\/p>\n<p>\u4eca\u5929\u6211\u62ff\u6765<a title=\"\u6613\u9a71\u7ebf\" href=\"http:\/\/baike.baidu.com\/view\/1888289.htm\">\u6613\u9a71\u7ebf<\/a>\uff0c\u628a\u8001\u7684IDE\u63a5\u4e0a\uff0c\u7528ext2explore.exe\u6253\u5f00\uff0c\u5f53\u65f6\u5206\u533a\u6bd4\u8f83\u968f\u610f\uff0c\u53ea\u6709\u4e00\u4e2a \/ \u548c\u4e00\u4e2a \/home \uff0c\u4eca\u5929\u4f53\u4f1a\u5230\u628a\u4e0d\u540c\u7684\u76ee\u5f55\u6302\u5230\u4e0d\u540c\u5206\u533a\u7684\u597d\u5904\u4e86\uff0c\u8981\u662f\/\u6302\u4e86\uff0c\u90a3\u6211\u4e00\u5207\u73a9\u5b8c\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\u628a\u786c\u76d8\u6240\u6709\u7684\u5206\u533a\u5728windows\u4e0b\u9762\u76f4\u63a5\u5220\u6389\u4e86\uff0c\u91cd\u65b0\u6302\u56de\u5230\u8001\u673a\u5668\uff0c\u7528cdrom\u653e\u5165debian\u5149\u76d8\uff0c\u542f\u52a8\uff0c\u987a\u5229\u8fdb\u5165\u5b89\u88c5\u4ecb\u9762\uff0c\u63a5\u4e0b\u6765\u5206\u533a\u548c\u5b89\u88c5\u597d\uff0cssh\uff0c\u7b80\u5355\u5b89\u5168\u63aa\u65bd\uff0c\u4e0a\u7f51\u4ec0\u4e48\u7684\u641e\u597d\u3002\u7136\u540e\u5f00\u59cb\u641e\u8fd9\u4e9b\u6570\u636e\u3002<\/p>\n<p>\u5b89\u88c5svn\uff0c\u5c06svnroot\u91cc\u7684\u6587\u4ef6\u4f20\u8fc7\u53bb\uff0c\u542f\u52a8\u670d\u52a1\u5230\u5bf9\u5e94\u76ee\u5f55\uff0c\u7136\u540esvn\u80fd\u7528\u4e86\u3002\u88c5\u597dnginx\uff0c\u4f20\u914d\u7f6e\u548cweb\u76ee\u5f55\u91cc\u7684\u6587\u4ef6\u56de\u53bb\uff0c\u6700\u91cd\u8981\u7684\u5c31\u662f\u641emysql\u6570\u636e\u5e93\u6062\u590d\u4e86\uff0c\u4ee5\u524d\u6211\u535a\u91cc\u7684lnmp\u5b89\u88c5\u597d\uff0c\u5f00\u59cb\u6570\u636e\u5e93\u7684\u6062\u590d\u3002<\/p>\n<p>\u53d1\u73b0\u6bcf\u4e2a\u6570\u636e\u5e93\u91cc\u9762\u6709\u4e09\u79cd\u6587\u4ef6\uff0c*.frm *.MYD *.MYI\uff0c\u8fd9\u4e9b\u76f4\u63a5\u62f7\u5230\/var\/lib\/mysq\u91cc\uff0c\u5148\u6267\u884c<\/p>\n<pre>service mysql stop<\/pre>\n<p>\u8986\u76d6\u8fc7\u53bb\uff0c\u5176\u5b9e\u6211\u5728\u60f3\u8fd9\u79cd\u65b9\u5f0f\u6709\u53ef\u80fd\u4e0d\u5bf9\uff0c\u5c31\u5148\u628a\u73b0\u5728\u65b0\u5b89\u7684\/var\/lib\/mysql\u91cc\u7684\u5907\u4efd\u4e86\u4e00\u4e0b\uff0c\u7136\u540e\u4f20\u8fc7\u53bb<\/p>\n<pre>#service mysql start\r\n Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!<\/pre>\n<p>\u679c\u7136\u4e0d\u884c\uff0c\u5e78\u4e8f\u5907\u4efd\u4e86\u4e00\u4e0b\uff0c\u518d\u628a\u5907\u4efd\u7684\u8986\u76d6\u56de\u53bb\uff0c\u5e76\u6ca1\u6709\u5220\u6389\u4e0d\u51b2\u7a81\u7684\u6587\u4ef6\uff0c\u8fd8\u662ffailed<\/p>\n<p>\u540e\u6765\u53d1\u73b0\u662f\u76ee\u5f55\u6743\u9650\u4e0d\u5bf9\uff0c\u4e0d\u7ba1\u5176\u4ed6\uff0c\u5148\u6539\u76ee\u5f55\u6743\u9650<\/p>\n<pre># chown -Rf mysql:mysql \/var\/lib\/mysql\/\r\n# chmod 700 -Rf \/var\/lib\/mysql\/<\/pre>\n<p>\u7136\u540e\u53d1\u73b0\u53ef\u4ee5\u4e86<\/p>\n<pre>#service mysql start\r\nStarting MySQL database server: mysqld.\r\nChecking for corrupt, not cleanly closed and upgrade needing tables..<\/pre>\n<p>\u6309\u4ee5\u4e0a\u7684\u63d0\u793a\u8bf4\u660e\u6709\u4e00\u4e9b\u8868\u8fd8\u662f\u6709\u4e00\u4e9b\u95ee\u9898\uff0c\u53ef\u80fd\u662f\u7531\u505c\u7535\u5f15\u8d77\u7684\u3002<\/p>\n<p>\u518d\u628a\u4ee5\u524d\u5404\u79cdphp mysql\u7b49\u914d\u7f6e\u6587\u4ef6\u8f6c\u79fb\u56de\u53bb\u5c31\u597d\u4e86<\/p>\n<p>\u7cfb\u7edf\u7248\u672c\u4e00\u6837\uff0c\u5404\u79cd\u670d\u52a1\uff0c\u8def\u5f84\u90fd\u4e00\u6837\uff0c\u6240\u4ee5\u8fd9\u6b21\u6062\u590d\u4e0d\u662f\u5f88\u96be\uff0c\u4e5f\u6ca1\u6709\u591a\u5c11\u9519\u8bef\u78b0\u5230\u3002<\/p>\n<p>:)EOT<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u90a3\u53f0\u7535\u8111\u662f\u7528\u6765\u7ec3\u624b\u548c\u6a21\u62df\u8bba\u575b\u7684 \u524d\u51e0\u5929\u6709\u4e00\u665a\u88ab\u65b0\u624b\u5f04\u4e86ubuntu\u7684\u6e90\u5f3a\u5236\u66f4\u65b0\u4e86\uff0c\u7136\u540e\u7b2c\u4e8c\u5929\u6821\u533a\u505c\u7535 \u8fd9\u53f0\u7535\u8111\u53c8\u7834 \u5f00\u59cb\u7528u\u76d8\u548ccdrom\uff0clan\u5404\u79cd\u542f\u52a8\u90fd\u8bd5\u4e86\uff0c\u65e0\u679c\u3002\u8981\u4e0d\u5c31\u662f\u5230\u68c0\u6d4b\u786c\u4ef6\u65f6\u5361\u4f4f\uff0c\u8981\u4e0d\u5c31\u662f\u65e0\u6cd5\u8bc6\u522b\uff0c\u5176\u5b9e\u6211\u5e94\u8be5\u60f3\u5230\u7684\uff0c\u80af\u5b9a\u662f\u786c\u76d8\u7684\u5f15\u5bfc\u533a\u51fa\u4e86\u95ee\u9898\u3002 \u4eca\u5929\u6211\u62ff\u6765\u6613\u9a71\u7ebf\uff0c\u628a\u8001\u7684IDE\u63a5\u4e0a\uff0c\u7528ext2explore.exe\u6253\u5f00\uff0c\u5f53\u65f6\u5206\u533a\u6bd4\u8f83\u968f\u610f\uff0c\u53ea\u6709\u4e00\u4e2a \/ \u548c\u4e00\u4e2a \/home \uff0c\u4eca\u5929\u4f53\u4f1a\u5230\u628a\u4e0d\u540c\u7684\u76ee\u5f55\u6302\u5230\u4e0d\u540c\u5206\u533a\u7684\u597d\u5904\u4e86\uff0c\u8981\u662f\/\u6302\u4e86\uff0c\u90a3\u6211\u4e00\u5207\u73a9\u5b8c\u3002 \u63a5\u4e0b\u6765\u628a\u786c\u76d8\u6240\u6709\u7684\u5206\u533a\u5728windows\u4e0b\u9762\u76f4\u63a5\u5220\u6389\u4e86\uff0c\u91cd\u65b0\u6302\u56de\u5230\u8001\u673a\u5668\uff0c\u7528cdrom\u653e\u5165debian\u5149\u76d8\uff0c\u542f\u52a8\uff0c\u987a\u5229\u8fdb\u5165\u5b89\u88c5\u4ecb\u9762\uff0c\u63a5\u4e0b\u6765\u5206\u533a\u548c\u5b89\u88c5\u597d\uff0cssh\uff0c\u7b80\u5355\u5b89\u5168\u63aa\u65bd\uff0c\u4e0a\u7f51\u4ec0\u4e48\u7684\u641e\u597d\u3002\u7136\u540e\u5f00\u59cb\u641e\u8fd9\u4e9b\u6570\u636e\u3002 \u5b89\u88c5svn\uff0c\u5c06svnroot\u91cc\u7684\u6587\u4ef6\u4f20\u8fc7\u53bb\uff0c\u542f\u52a8\u670d\u52a1\u5230\u5bf9\u5e94\u76ee\u5f55\uff0c\u7136\u540esvn\u80fd\u7528\u4e86\u3002\u88c5\u597dnginx\uff0c\u4f20\u914d\u7f6e\u548cweb\u76ee\u5f55\u91cc\u7684\u6587\u4ef6\u56de\u53bb\uff0c\u6700\u91cd\u8981\u7684\u5c31\u662f\u641emysql\u6570\u636e\u5e93\u6062\u590d\u4e86\uff0c\u4ee5\u524d\u6211\u535a\u91cc\u7684lnmp\u5b89\u88c5\u597d\uff0c\u5f00\u59cb\u6570\u636e\u5e93\u7684\u6062\u590d\u3002 \u53d1\u73b0\u6bcf\u4e2a\u6570\u636e\u5e93\u91cc\u9762\u6709\u4e09\u79cd\u6587\u4ef6\uff0c*.frm *.MYD *.MYI\uff0c\u8fd9\u4e9b\u76f4\u63a5\u62f7\u5230\/var\/lib\/mysq\u91cc\uff0c\u5148\u6267\u884c service mysql stop \u8986\u76d6\u8fc7\u53bb\uff0c\u5176\u5b9e\u6211\u5728\u60f3\u8fd9\u79cd\u65b9\u5f0f\u6709\u53ef\u80fd\u4e0d\u5bf9\uff0c\u5c31\u5148\u628a\u73b0\u5728\u65b0\u5b89\u7684\/var\/lib\/mysql\u91cc\u7684\u5907\u4efd\u4e86\u4e00\u4e0b\uff0c\u7136\u540e\u4f20\u8fc7\u53bb #service mysql start Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! \u679c\u7136\u4e0d\u884c\uff0c\u5e78\u4e8f\u5907\u4efd\u4e86\u4e00\u4e0b\uff0c\u518d\u628a\u5907\u4efd\u7684\u8986\u76d6\u56de\u53bb\uff0c\u5e76\u6ca1\u6709\u5220\u6389\u4e0d\u51b2\u7a81\u7684\u6587\u4ef6\uff0c\u8fd8\u662ffailed \u540e\u6765\u53d1\u73b0\u662f\u76ee\u5f55\u6743\u9650\u4e0d\u5bf9\uff0c\u4e0d\u7ba1\u5176\u4ed6\uff0c\u5148\u6539\u76ee\u5f55\u6743\u9650 # chown -Rf mysql:mysql \/var\/lib\/mysql\/ # chmod 700 -Rf \/var\/lib\/mysql\/ \u7136\u540e\u53d1\u73b0\u53ef\u4ee5\u4e86 #service [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[30],"class_list":["post-2044","post","type-post","status-publish","format-standard","hentry","category-linux","tag-cool"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2044"}],"version-history":[{"count":7,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2044\/revisions"}],"predecessor-version":[{"id":2049,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2044\/revisions\/2049"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}