\u4f7f\u7528mysqldump\u5907\u4efd\u65f6\uff0c–opt\u8868\u793a\u91c7\u7528\u4f18\u5316(Optimize)\u65b9\u5f0f<\/p>\n
mysqldump --opt -uroot -ppasswd c14sql >c14sql.sql<\/pre>\n\u51fa\u73b0\u9519\u8bef<\/p>\n
mysqldump: Got error: 145: Table '.\/c14sql\/is_stats' is marked as crashed and should be repaired when using LOCK TABLES<\/pre>\n\u89e3\u51b3\u529e\u6cd51\uff0c\u7528myisamchk<\/p>\n
myisamchk -c -r \/var\/lib\/mysql\/c14sql\/is_stats.MYI<\/pre>\n\u89e3\u51b3\u529e\u6cd52\uff0c\u8fdb\u5165mysql>\uff08\u6682\u672a\u6d4b\u8bd5\uff09<\/p>\n
mysql> repair table is_stats;<\/pre>\n\u68c0\u6d4b\u4e00\u4e0b<\/p>\n
mysql> check tables is_stats;<\/pre>\n\u6ca1\u95ee\u9898\u7684\u8bdd\u518d\u5907\u4efd\u5c31\u6ca1\u6709\u95ee\u9898\u4e86<\/p>\n
ps:<\/p>\n
mysqldump \u5bfc\u51fa\u8868\u7ed3\u6784 –no-data flag to make it only export structure<\/p>\n
mysqldump -u jira -p -h 192.168.9.11 jira6 --no-data > jira6.nodata.sql<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4f7f\u7528mysqldump\u5907\u4efd\u65f6\uff0c–opt\u8868\u793a\u91c7\u7528\u4f18\u5316(Optimize)\u65b9\u5f0f mysqldump –opt -uroot -ppasswd c14sql >c14sql.sql \u51fa\u73b0\u9519\u8bef mysqldump: Got error: 145: Table ‘.\/c14sql\/is_stats’ is marked as crashed and should be repaired when using LOCK TABLES \u89e3\u51b3\u529e\u6cd51\uff0c\u7528myisamchk myisamchk -c -r \/var\/lib\/mysql\/c14sql\/is_stats.MYI \u89e3\u51b3\u529e\u6cd52\uff0c\u8fdb\u5165mysql>\uff08\u6682\u672a\u6d4b\u8bd5\uff09 mysql> repair table is_stats; \u68c0\u6d4b\u4e00\u4e0b mysql> check tables is_stats; \u6ca1\u95ee\u9898\u7684\u8bdd\u518d\u5907\u4efd\u5c31\u6ca1\u6709\u95ee\u9898\u4e86 ps: mysqldump \u5bfc\u51fa\u8868\u7ed3\u6784 –no-data flag to make it only export structure mysqldump -u […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[23],"class_list":["post-2825","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-summary"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2825"}],"version-history":[{"count":7,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2825\/revisions"}],"predecessor-version":[{"id":7065,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/2825\/revisions\/7065"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}