{"id":2327,"date":"2022-03-04T10:58:01","date_gmt":"2022-03-04T02:58:01","guid":{"rendered":"http:\/\/localhost\/bpoint\/?p=2327"},"modified":"2022-03-04T10:58:01","modified_gmt":"2022-03-04T02:58:01","slug":"%e4%bd%bf%e7%94%a8bat%e6%aa%94%e5%82%99%e4%bb%bd%e8%b3%87%e6%96%99%e5%ba%ab","status":"publish","type":"post","link":"https:\/\/bpoint.space\/?p=2327","title":{"rendered":"\u4f7f\u7528BAT\u6a94\u5099\u4efd\u8cc7\u6599\u5eab"},"content":{"rendered":"<p>\u5927\u5bb6\u597d\uff0c\u9019\u6b21\u8981\u4f86\u5206\u4eab\u5982\u4f55\u4f7f\u7528BAT\u6a94\u4f86\u9032\u884c\u8cc7\u6599\u5eab\u7684\u5099\u4efd<\/p>\n<p>\u4f7f\u7528\u7684\u74b0\u5883\u662f\uff0cwindows 10 &amp; mysql\u8cc7\u6599\u5eab<\/p>\n<p>\u958b\u59cb\u4e4b\u524d\u8acb\u5148\u6e96\u5099\u597dmysqldump.exe\u9019\u500b\u6a94\u6848\uff0c\u5982\u679c\u4f7f\u7528\u7684XAMPP\u9019\u500b\u8edf\u9ad4\u7684\u8a71\uff0c\u53ef\u4ee5\u53bbxampp\\mysql\\bin\u7684\u8cc7\u6599\u593e\u5e95\u4e0b\u53bb\u627e<\/p>\n<p>1.\u65b0\u589e\u4e00\u500b.bat\u6a94<\/p>\n<p>2.\u53f3\u9375=&gt;\u7de8\u8f2f<\/p>\n<p>3.C:\\mysqldump -u AAAAA -h 192.168.0.0 -pBBBBB XXXXX &gt; D:\\%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%.sql<\/p>\n<p>C:\\mysqldump&lt;==\u9019\u88e1\u8981\u8f38\u5165mysqldump.exe\u9019\u500b\u6a94\u6848\u7684\u8def\u5f91<\/p>\n<p>AAAAA&lt;==\u9019\u88e1\u8981\u8f38\u5165\u8cc7\u6599\u5eab\u7684username\uff0c\u672c\u6a5f\u7aef\u53ef\u4ee5\u8f38\u5165root<\/p>\n<p>192.168.0.0&lt;==\u9019\u88e1\u8981\u8f38\u5165ip\uff0c\u672c\u6a5f\u7aef\u8f38\u5165localhost or 127.0.0.1<\/p>\n<p>BBBBB&lt;==\u5982\u679cuser\u6709\u8a2d\u5bc6\u78bc\uff0c\u5728\u9019\u8f38\u5165\u5bc6\u78bc\uff0c-p\u8ddf\u5bc6\u78bc\u4e4b\u9593\u4e0d\u8981\u6709\u7a7a\u683c<\/p>\n<p>D:\\&lt;==\u9019\u88e1\u8f38\u5165\u5099\u4efd\u6a94\u8981\u5132\u5b58\u7684\u8def\u5f91<\/p>\n<p>%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%&lt;==\u9019\u88e1\u53ef\u4ee5\u8f38\u5165\u6a94\u540d\uff0c\u9019\u88e1\u4f7f\u7528\u7684\u662f\u4f7f\u7528\u65e5\u671f\u53ca\u6642\u9593\u4f86\u7576\u6210\u6a94\u540d<\/p>\n<p>\u7528\u4e0b\u9762\u7684\u6848\u4f8b\u4f86\u89e3\u91cb\uff0c\u5728cmt\u5e95\u4e0b\u8f38\u5165date\u6703\u51fa\u73fe==&gt;\u73fe\u5728\u65e5\u671f\u662f: 2134\/07\/29 \u9031\u4e00<\/p>\n<p>%date:~0,4%=&gt;2134\uff0c\u57282134\/07\/29\u9019\u4e00\u5217\u8cc7\u6599\u5f9e\u7b2c0\u7684\u4f4d\u7f6e\u64f7\u53d64\u500b\u4f4d\u7f6e\u7684\u8cc7\u6599<\/p>\n<p>%date:~5,2%=&gt;07\uff0c\u57282134\/07\/29\u9019\u4e00\u5217\u8cc7\u6599\u5f9e\u7b2c5\u7684\u4f4d\u7f6e\u64f7\u53d62\u500b\u4f4d\u7f6e\u7684\u8cc7\u6599<\/p>\n<p>%date:~8,2%=&gt;29\uff0c\u57282134\/07\/29\u9019\u4e00\u5217\u8cc7\u6599\u5f9e\u7b2c8\u7684\u4f4d\u7f6e\u64f7\u53d62\u500b\u4f4d\u7f6e\u7684\u8cc7\u6599<\/p>\n<p>ps.2134\/07\/29\uff0c2\u9019\u4e00\u6b04\u7684\u8cc7\u6599\u4f4d\u7f6e\u662f\u7b2c0\u500b<\/p>\n<p>\u53c3\u8003\u4f86\u6e90\uff1ahttps:\/\/blog.miniasp.com\/post\/2009\/11\/03\/How-to-get-system-date-time-in-batch-file-part-III<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u5bb6\u597d\uff0c\u9019\u6b21\u8981\u4f86\u5206\u4eab\u5982\u4f55\u4f7f\u7528BAT\u6a94\u4f86\u9032\u884c\u8cc7\u6599\u5eab\u7684\u5099\u4efd \u4f7f\u7528\u7684\u74b0\u5883\u662f\uff0cwindows 10 &amp; mys [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2327","post","type-post","status-publish","format-standard","hentry","category-36"],"_links":{"self":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts\/2327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2327"}],"version-history":[{"count":0,"href":"https:\/\/bpoint.space\/index.php?rest_route=\/wp\/v2\/posts\/2327\/revisions"}],"wp:attachment":[{"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bpoint.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}