{"id":211,"date":"2019-09-10T20:23:32","date_gmt":"2019-09-10T12:23:32","guid":{"rendered":"https:\/\/freeapp.sbs\/blog\/?p=211"},"modified":"2025-04-01T17:06:25","modified_gmt":"2025-04-01T08:06:25","slug":"xufrthz6gdayyfz","status":"publish","type":"post","link":"https:\/\/eternalsphere.net\/echoes\/index.php\/2019\/09\/10\/xufrthz6gdayyfz\/","title":{"rendered":"\u5e38\u7528\u6570\u636e\u5e93\u64cd\u4f5c\u547d\u4ee4"},"content":{"rendered":"

\u6570\u636e\u5e93\u547d\u4ee4<\/p>\n

\u5ba2\u6237\u7aef\u5de5\u5177 mysql<\/p>\n

mysql -u root -p’pass’ -h ‘server’<\/p>\n

 <\/p>\n

mysqladmin\u5de5\u5177<\/p>\n

mysqladmin [\u9009\u9879]\u547d\u4ee4[\u547d\u4ee4\u53c2\u6570]<\/p>\n

create db-name<\/p>\n

debug \u5c06debug\u4fe1\u606f\u5199\u5165\u9519\u8bef\u65e5\u5fd7<\/p>\n

drop db-name<\/p>\n

extended-status \u663e\u793a\u670d\u52a1\u5668\u72b6\u6001\u53d8\u91cf\u53ca\u53d8\u91cf\u503c<\/p>\n

flush-hosts \u5237\u65b0\u6240\u6709\u65e5\u5fd7<\/p>\n

flush-privileges \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u6570\u636e\u8868<\/p>\n

flush-status \u6e05\u7a7a\u72b6\u6001\u53d8\u91cf<\/p>\n

flush-tables \u5237\u65b0\u6240\u6709\u6570\u636e\u8868<\/p>\n

kill id,id… kill\u7ebf\u7a0b<\/p>\n

password new-pass \u8bbe\u7f6e\u65b0\u5bc6\u7801<\/p>\n

ping \u68c0\u67e5\u670d\u52a1\u5668\u662f\u5426\u53ef\u7528<\/p>\n

reload \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u6570\u636e\u8868<\/p>\n

refresh \u5237\u65b0\u6240\u6709\u7684\u6570\u636e\u8868\u5e76\u91cd\u542f\u65e5\u5fd7\u6587\u4ef6<\/p>\n

shutdown \u5173\u95ed\u670d\u52a1\u5668<\/p>\n

start-slave \u5728\u4ece\u670d\u52a1\u5668\u4e0a\u542f\u52a8\u590d\u5236<\/p>\n

stop-slave \u5728\u4ece\u670d\u52a1\u5668\u4e0a\u505c\u6b62\u590d\u5236<\/p>\n

 <\/p>\n

mysqldump\u5de5\u5177<\/p>\n

\u6570\u636e\u5e93\u903b\u8f91\u5907\u4efd\u7a0b\u5e8f<\/p>\n

mysqldump -u root –all-databases > ABC \u5907\u4efd\u6240\u6709\u6570\u636e\u5e93<\/p>\n

mysqldump -u root -p –database mysql > ABC \u5907\u4efdmysql<\/p>\n

mysqldump -u root -p mysql user > user_table \u5907\u4efdmysql\u6570\u636e\u5e93\u4e0b\u7684user\u6570\u636e\u5305<\/p>\n

mysql -u root -p < ABC \u8fd8\u539f\u6240\u6709\u6570\u636e\u8868<\/p>\n

mysql -u root -p mysql < ABC \u8fd8\u539fmysql\u6570\u636e\u5e93<\/p>\n

mysql -u root -p mysql <user_table \u8fd8\u539f\u6570\u636e\u8868<\/p>\n

 <\/p>\n

\u6570\u636e\u5e93\u5b9a\u4e49\u8bed\u8a00<\/p>\n

CREATE DATABASE<\/p>\n

eg\uff1amysql -u root -p<\/p>\n

>create database hr;<\/p>\n

>show database;<\/p>\n

CREATE TABLE<\/p>\n

ALTER DATABASE<\/p>\n

ALTER TABLE<\/p>\n

DROP TABLE<\/p>\n

DROP INDEX<\/p>\n

RENAME TABLE<\/p>\n

DROP DATABASE<\/p>\n

 <\/p>\n

\u6570\u636e\u5e93\u64cd\u4f5c\u8bed\u8a00<\/p>\n

INSERT \u5411\u6570\u636e\u8868\u4e2d\u63d2\u5165\u4e00\u884c\u65b0\u6570\u636e<\/p>\n

UPDATE \u66f4\u65b0\u6570\u636e\u8868\u4e2d\u73b0\u6709\u7684\u6570\u636e\u503c<\/p>\n

LOAD DATA INFILE \u5feb\u901f\u4ece\u6587\u672c\u6587\u4ef6\u4e2d\u8bfb\u53d6\u6570\u636e\u5230\u6570\u636e\u8868\u4e2d<\/p>\n

DELETE<\/p>\n

 <\/p>\n

\u6570\u636e\u5e93\u67e5\u8be2\u8bed\u8a00<\/p>\n

\u4f7f\u7528SELECT\u8bed\u53e5<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u5e93\u547d\u4ee4 \u5ba2\u6237\u7aef\u5de5\u5177 mysql mysql -u root -p’pass’ -h ‘server’   mysqladmin\u5de5\u5177 mysqladmin [\u9009\u9879]\u547d\u4ee4[\u547d\u4ee4\u53c2\u6570] create db-name debug \u5c06debug\u4fe1\u606f\u5199\u5165\u9519\u8bef\u65e5\u5fd7 drop db-name extended-status \u663e\u793a\u670d\u52a1\u5668\u72b6\u6001\u53d8\u91cf\u53ca\u53d8\u91cf\u503c flush-hosts \u5237\u65b0\u6240\u6709\u65e5\u5fd7 flush-privileges \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u6570\u636e\u8868 flush-status \u6e05\u7a7a\u72b6\u6001\u53d8\u91cf flush-tables \u5237\u65b0\u6240\u6709\u6570\u636e\u8868 kill id,id… kill\u7ebf\u7a0b password new-pass \u8bbe\u7f6e\u65b0\u5bc6\u7801 ping \u68c0\u67e5\u670d\u52a1\u5668\u662f\u5426\u53ef\u7528 reload \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u6570\u636e\u8868 refresh \u5237\u65b0\u6240\u6709\u7684\u6570\u636e\u8868\u5e76\u91cd\u542f\u65e5\u5fd7\u6587\u4ef6 shutdown \u5173\u95ed\u670d\u52a1\u5668 start-slave \u5728\u4ece\u670d\u52a1\u5668\u4e0a\u542f\u52a8\u590d\u5236 stop-slave \u5728\u4ece\u670d\u52a1\u5668\u4e0a\u505c\u6b62\u590d\u5236   mysqldump\u5de5\u5177 \u6570\u636e\u5e93\u903b\u8f91\u5907\u4efd\u7a0b\u5e8f …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-bdobq3k1tczue"],"_links":{"self":[{"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":1,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":2317,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/posts\/211\/revisions\/2317"}],"wp:attachment":[{"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eternalsphere.net\/echoes\/index.php\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}