{"id":2550,"date":"2022-08-18T20:00:45","date_gmt":"2022-08-18T12:00:45","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=2550"},"modified":"2022-08-18T20:00:45","modified_gmt":"2022-08-18T12:00:45","slug":"mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%a4%87%e4%bb%bd%e6%81%a2%e5%a4%8d%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"http:\/\/xnw60rlg.ipyingshe.net:5347\/?p=2550","title":{"rendered":"mysql\u6570\u636e\u5e93\u5907\u4efd\u6062\u590d\u8bed\u53e5"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\u5907\u4efd\u6570\u636e \nsudo mysqldump -u root -p  wordpress > \/media\/pi\/OS\/wordpress_$(date +%F).sql\n\n\n\u6062\u590d\u6570\u636e\n\u8bed\u6cd5\uff08Syntax\uff09\uff1a\nmysql -u&lt;username> -p&lt;password> &lt;dbname> &lt; \/opt\/mytest_bak.sql   #\u5e93\u5fc5\u987b\u4fdd\u7559\uff0c\u7a7a\u5e93\u4e5f\u53ef\n\u8bf4\u660e\uff1a\u6307\u5b9adbname\uff0c\u76f8\u5f53\u4e8euse &lt;dbname><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-2550","post","type-post","status-publish","format-standard","hentry","category-6"],"_links":{"self":[{"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/2550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2550"}],"version-history":[{"count":0,"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/2550\/revisions"}],"wp:attachment":[{"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2550"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/xnw60rlg.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}