{"id":1950,"date":"2022-04-08T11:04:48","date_gmt":"2022-04-08T02:04:48","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1950"},"modified":"2022-04-08T11:04:48","modified_gmt":"2022-04-08T02:04:48","slug":"mariadb-%e3%82%b9%e3%83%88%e3%82%a2%e3%83%97%e3%83%ad%e3%82%b7%e3%82%b8%e3%83%a3%e3%83%bc%e3%80%81%e3%83%95%e3%82%a1%e3%83%b3%e3%82%af%e3%82%b7%e3%83%a7%e3%83%b3%e3%80%81%e3%83%88%e3%83%aa%e3%82%ac","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1950","title":{"rendered":"mariaDB \u30b9\u30c8\u30a2\u30d7\u30ed\u30b7\u30b8\u30e3\u30fc\u3001\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3001\u30c8\u30ea\u30ac\u30fc\u3092\u542b\u3081\u3066backup<\/small>"},"content":{"rendered":"

\u30fb\u30b9\u30c8\u30a2\u30d7\u30ed\u30b7\u30b8\u30e3\u30fc\u3001\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3001\u30c8\u30ea\u30ac\u30fc\u3092\u542b\u3081\u3066backup\u3059\u308b\u306b\u306f –routines\u306eoption\u3092\u4ed8\u3051\u308b<\/p>\n

\r\nmysqldump --routines PrivateInvoice > backup\/PrivateInvoice_`date \"+%Y%m%d_%H%M%S\"`.sql\r\n<\/pre>\n
\r\nmysql\u3000 PrivateInvoice < PrivateInvoice_20220408_105539.sql\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u30fb\u30b9\u30c8\u30a2\u30d7\u30ed\u30b7\u30b8\u30e3\u30fc\u3001\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3001\u30c8\u30ea\u30ac\u30fc\u3092\u542b\u3081\u3066backup\u3059\u308b\u306b\u306f –routines\u306eoption\u3092\u4ed8\u3051\u308b mysqldump –routines PrivateInvoice > backup\/…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1950"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1950"}],"version-history":[{"count":3,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1950\/revisions"}],"predecessor-version":[{"id":1959,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1950\/revisions\/1959"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}