{"id":172,"date":"2018-01-16T10:28:40","date_gmt":"2018-01-16T02:28:40","guid":{"rendered":"http:\/\/www.mhfohk.com\/wordpress\/?p=172"},"modified":"2018-01-16T11:11:00","modified_gmt":"2018-01-16T03:11:00","slug":"%e6%96%bcdsm%e5%85%a7%e8%87%aa%e5%8b%95%e6%8e%92%e7%a8%8b%e5%82%99%e4%bb%bdmysql%e8%b3%87%e6%96%99%e5%ba%ab","status":"publish","type":"post","link":"https:\/\/www.mhfohk.com\/wordpress\/2018\/01\/16\/%e6%96%bcdsm%e5%85%a7%e8%87%aa%e5%8b%95%e6%8e%92%e7%a8%8b%e5%82%99%e4%bb%bdmysql%e8%b3%87%e6%96%99%e5%ba%ab\/","title":{"rendered":"\u65bcDSM\u5167\u81ea\u52d5\u6392\u7a0b\u5099\u4efdMySQL\u8cc7\u6599\u5eab"},"content":{"rendered":"<p>\u6700\u8fd1\u7a81\u7136\u60f3\u5230\u5f88\u4e45\u6c92\u6709\u5099\u4efd\u6211\u7684\u8cc7\u6599\u5eab(MySQL database)\uff0c<br \/>\n\u4f46\u662f\u4f5c\u70ba\u4e00\u500b<span style=\"color: #33cccc;\"><strong><del datetime=\"2018-01-16T03:09:53+00:00\">(\u507d)<\/del><\/strong><\/span>IT\u4eba\uff0c\u600e\u53ef\u80fd\u5728\u60f3\u5230\u7684\u6642\u5019\u624d\u5099\u4efd\u5462!<br \/>\n\u65bc\u662f\u53c8\u53bb\u722c\u6587\u770b\u770b\uff0c\u627e\u5230\u53ef\u4ee5\u7528linux command: mysqldump\u4f86\u9032\u884c\u5099\u4efd\uff0c<br \/>\n\u99ac\u4e0atelnet\u9032\u53bbdsm\u8a66\u8a66\u770b\uff0cOh! No! \u627e\u4e0d\u5230mysqldump\u6307\u4ee4\uff0c<br \/>\n\u518d\u5ea6\u722c\u6587......\u539f\u4f86\u5728DSM\u88e1\u9762\u8981\u7528full path\u4f86\u57f7\u884c\u3002<br \/>\n\u518d\u4f86\u5c31\u8981\u770b\u4f60\u7528\u7684\u662fMariaDB 5\u9084\u662fMariaDB 10\uff0c\u56e0\u70ba\u8def\u5f91\u662f\u4e0d\u4e00\u6a23\u7684\u3002<\/p>\n<p><span style=\"color: #339966;\">#MariaDB 5: \/volume1\/@appstore\/MariaDB\/usr\/bin\/mysqldump<\/span><br \/>\n<span style=\"color: #339966;\"> #MariaDB 10: \/volume1\/@appstore\/MariaDB10\/usr\/local\/mariadb10\/bin\/mysqldump<\/span><br \/>\nPS.\u9019\u662fDSM6.1.4\u7248\uff0c\u65e5\u5f8c\u7684\u66f4\u65b0\u4e0d\u77e5\u9053\u9084\u6703\u4e0d\u6703\u6539\u8b8a\u3002<\/p>\n<p>\u6700\u5f8c\u628abatch file\u4e0a\u50b3\u5230diskstation\uff0c\u5728telnet\u57f7\u884c<span style=\"color: #ff0000;\">chmod 777\u00a0BackupSQL.sh<\/span><br \/>\nPS.\u4e0d\u505a\u9019\u500b\u52d5\u4f5c\u7684\u8a71\uff0c\u4efb\u52d9\u6392\u7a0b\u6703\u56e0\u70ba\u6b0a\u9650\u554f\u984c\u800c\u7121\u6cd5\u57f7\u884c<\/p>\n<p>\u6700\u5f8c\u6b65\u9a5f:<br \/>\n\u63a7\u5236\u53f0=&gt;\u4efb\u52d9\u6392\u7a0b\u8868=&gt;\u65b0\u589e=&gt;\u6392\u7a0b\u4efb\u52d9=&gt;\u4f7f\u7528\u8005\u5b9a\u7fa9\u6307\u4ee4\u78bc<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-173\" src=\"http:\/\/www.mhfohk.com\/wordpress\/wp-content\/uploads\/2018\/01\/SQLBackup.jpg\" alt=\"\" width=\"666\" height=\"662\" srcset=\"https:\/\/www.mhfohk.com\/wordpress\/wp-content\/uploads\/2018\/01\/SQLBackup.jpg 666w, https:\/\/www.mhfohk.com\/wordpress\/wp-content\/uploads\/2018\/01\/SQLBackup-150x150.jpg 150w, https:\/\/www.mhfohk.com\/wordpress\/wp-content\/uploads\/2018\/01\/SQLBackup-300x298.jpg 300w\" sizes=\"auto, (max-width: 666px) 100vw, 666px\" \/><\/p>\n<p>\u9644\u4e0a\u5c0f\u5f1f\u81ea\u5df1\u505a\u7684batch file: <a href=\"http:\/\/www.mhfohk.com\/BackupSQL.sh\">\u6309\u6211\u4e0b\u8f09<\/a><br \/>\n<strong><span style=\"color: #ff0000;\">PS.\u8a18\u5f97\u81ea\u884c\u4fee\u6539mysqldump\u7684\u8def\u5f91\uff0c\u5099\u4efd\u7684\u76ee\u7684\u5730\uff0cMySQL\u7684password\u548c\u4fdd\u7559\u5099\u4efd\u7684\u5929\u6578(\u6211\u662f\u9810\u8a2d30\u65e5)\u3002<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u7a81\u7136\u60f3\u5230\u5f88\u4e45\u6c92\u6709\u5099\u4efd\u6211\u7684\u8cc7\u6599\u5eab(MySQL database)\uff0c \u4f46\u662f\u4f5c\u70ba\u4e00\u500b(\u507d)IT\u4eba\uff0c\u600e\u53ef\u80fd\u5728\u60f3\u5230\u7684 &hellip; <a href=\"https:\/\/www.mhfohk.com\/wordpress\/2018\/01\/16\/%e6%96%bcdsm%e5%85%a7%e8%87%aa%e5%8b%95%e6%8e%92%e7%a8%8b%e5%82%99%e4%bb%bdmysql%e8%b3%87%e6%96%99%e5%ba%ab\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> \"\u65bcDSM\u5167\u81ea\u52d5\u6392\u7a0b\u5099\u4efdMySQL\u8cc7\u6599\u5eab\"<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[9,6,4],"tags":[],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-mysql","category-synology","category-xpenology"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9mX1K-2M","_links":{"self":[{"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/posts\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/comments?post=172"}],"version-history":[{"count":5,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":179,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/posts\/172\/revisions\/179"}],"wp:attachment":[{"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/media?parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/categories?post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mhfohk.com\/wordpress\/wp-json\/wp\/v2\/tags?post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}