{"id":334,"date":"2023-09-26T16:26:58","date_gmt":"2023-09-26T08:26:58","guid":{"rendered":"https:\/\/www.techvc.net\/?p=334"},"modified":"2023-10-02T23:50:50","modified_gmt":"2023-10-02T15:50:50","slug":"mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id","status":"publish","type":"post","link":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/","title":{"rendered":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID:"},"content":{"rendered":"\n

\u6545\u969c\u63cf\u8ff0\uff1a\u6570\u636e\u5e93\u7269\u7406\u6587\u4ef6\u88ab\u624b\u52a8\u5220\u9664\uff0c\u5bfc\u81f4MySQL\u65e0\u6cd5\u542f\u52a8\u3002<\/p>\n\n\n\n

\u89e3\u51b3\u529e\u6cd5\uff1a\u542f\u52a8\u6062\u590d\u6a21\u5f0f\uff0c\u4fee\u6539my.cnf<\/p>\n\n\n\n

[mysqld]\ninnodb_force_recovery = 1<\/code><\/pre>\n\n\n\n
\u8fd9\u65f6\u5019\u53ef\u4ee5\u6b63\u5e38\u542f\u52a8\u4e86\uff0c\u5728\u6570\u636e\u5e93\u5217\u8868\u4e2d\u53ef\u4ee5\u770b\u5230\u8fd9\u4e2a\u6570\u636e\u5e93\uff0c\u53ef\u4ee5\u5bf9\u8fd9\u4e2a\u5e93\u8fdb\u884c\u5bfc\u51fa\u5907\u4efd\u3002\u7136\u540e\u5220\u9664\u4e0a\u9762\u7684\u914d\u7f6e\uff0c\u4e5f\u5c31\u662f\u4e0b\u9762\u8fd9\u4e2a\u5220\u6389\uff0c\u518d\u542f\u52a8mysql\uff0c\u91cd\u65b0\u5bfc\u5165\u5373\u53ef\u3002<\/p>\n\n\n\n
innodb_force_recovery = 1<\/code><\/pre>\n
Views: 140<\/p>","protected":false},"excerpt":{"rendered":"
\u6545\u969c\u63cf\u8ff0\uff1a\u6570\u636e\u5e93\u7269\u7406\u6587\u4ef6\u88ab\u624b\u52a8\u5220\u9664\uff0c\u5bfc\u81f4MySQL\u65e0\u6cd5\u542f\u52a8\u3002 \u89e3\u51b3\u529e\u6cd5\uff1a\u542f\u52a8\u6062\u590d\u6a21\u5f0f\uff0c\u4fee\u6539my.cnf \u8fd9\u65f6\u5019 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-334","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"\nMySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql\u9519\u8befcould-not-find-any-file-associated-with-the-tablespace-id\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net\" \/>\n<meta property=\"og:description\" content=\"\u6545\u969c\u63cf\u8ff0\uff1a\u6570\u636e\u5e93\u7269\u7406\u6587\u4ef6\u88ab\u624b\u52a8\u5220\u9664\uff0c\u5bfc\u81f4MySQL\u65e0\u6cd5\u542f\u52a8\u3002 \u89e3\u51b3\u529e\u6cd5\uff1a\u542f\u52a8\u6062\u590d\u6a21\u5f0f\uff0c\u4fee\u6539my.cnf \u8fd9\u65f6\u5019 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql\u9519\u8befcould-not-find-any-file-associated-with-the-tablespace-id\/\" \/>\n<meta property=\"og:site_name\" content=\"\u6cf0\u514b\u7ef4\u897f@techvc.net\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-26T08:26:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-02T15:50:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/09\/\u6cf0\u514b\u7ef4\u897f\u80cc\u666f-edited.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"763\" \/>\n\t<meta property=\"og:image:height\" content=\"371\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u732b\u5934\u54e5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u732b\u5934\u54e5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/\"},\"author\":{\"name\":\"\u732b\u5934\u54e5\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#\\\/schema\\\/person\\\/4d6bfbcd614005ea07c82a30df5a1bb1\"},\"headline\":\"MySQL\u9519\u8befCould not find any file associated with the tablespace ID:\",\"datePublished\":\"2023-09-26T08:26:58+00:00\",\"dateModified\":\"2023-10-02T15:50:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/\"},\"wordCount\":15,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#organization\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/\",\"name\":\"MySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#website\"},\"datePublished\":\"2023-09-26T08:26:58+00:00\",\"dateModified\":\"2023-10-02T15:50:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/2023\\\/09\\\/26\\\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\\\/\\\/www.techvc.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u9519\u8befCould not find any file associated with the tablespace ID:\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#website\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/\",\"name\":\"\u6cf0\u514b\u7ef4\u897f@techvc.net\",\"description\":\"\u89e3\u653e\u7a0b\u5e8f\u5458\uff0c\u5e2e\u52a9\u521b\u4e1a\u8005\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.techvc.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#organization\",\"name\":\"\u5317\u4eac\u6cf0\u514b\u7ef4\u897f\u79d1\u6280\u6709\u9650\u516c\u53f8\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/logo\u5b9d\u5251-edited.png\",\"contentUrl\":\"https:\\\/\\\/www.techvc.net\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/logo\u5b9d\u5251-edited.png\",\"width\":820,\"height\":820,\"caption\":\"\u5317\u4eac\u6cf0\u514b\u7ef4\u897f\u79d1\u6280\u6709\u9650\u516c\u53f8\"},\"image\":{\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/#\\\/schema\\\/person\\\/4d6bfbcd614005ea07c82a30df5a1bb1\",\"name\":\"\u732b\u5934\u54e5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.techvc.net\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/\u6734\u6d77\u6797_avatar_1696137507.png\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/\u6734\u6d77\u6797_avatar_1696137507.png\",\"contentUrl\":\"https:\\\/\\\/www.techvc.net\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/\u6734\u6d77\u6797_avatar_1696137507.png\",\"caption\":\"\u732b\u5934\u54e5\"},\"description\":\"\u732b\u5934\u54e5\u64c5\u957f\u5927\u578b\u7f51\u7ad9\u6280\u672f\u67b6\u6784\uff0c\u5927\u578b\u7814\u53d1\u56e2\u961f\u6280\u672f\u7ba1\u7406\uff0c\u591a\u7aef\u7814\u53d1\u3001\u5168\u6808\u7814\u53d1\uff0c\u6b22\u8fce\u968f\u65f6\u54a8\u8be2\u3002\",\"url\":\"https:\\\/\\\/www.techvc.net\\\/index.php\\\/author\\\/piaohailin@techvc.net\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql\u9519\u8befcould-not-find-any-file-associated-with-the-tablespace-id\/","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net","og_description":"\u6545\u969c\u63cf\u8ff0\uff1a\u6570\u636e\u5e93\u7269\u7406\u6587\u4ef6\u88ab\u624b\u52a8\u5220\u9664\uff0c\u5bfc\u81f4MySQL\u65e0\u6cd5\u542f\u52a8\u3002 \u89e3\u51b3\u529e\u6cd5\uff1a\u542f\u52a8\u6062\u590d\u6a21\u5f0f\uff0c\u4fee\u6539my.cnf \u8fd9\u65f6\u5019 […]","og_url":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql\u9519\u8befcould-not-find-any-file-associated-with-the-tablespace-id\/","og_site_name":"\u6cf0\u514b\u7ef4\u897f@techvc.net","article_published_time":"2023-09-26T08:26:58+00:00","article_modified_time":"2023-10-02T15:50:50+00:00","og_image":[{"width":763,"height":371,"url":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/09\/\u6cf0\u514b\u7ef4\u897f\u80cc\u666f-edited.jpg","type":"image\/jpeg"}],"author":"\u732b\u5934\u54e5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u732b\u5934\u54e5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/#article","isPartOf":{"@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/"},"author":{"name":"\u732b\u5934\u54e5","@id":"https:\/\/www.techvc.net\/#\/schema\/person\/4d6bfbcd614005ea07c82a30df5a1bb1"},"headline":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID:","datePublished":"2023-09-26T08:26:58+00:00","dateModified":"2023-10-02T15:50:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/"},"wordCount":15,"commentCount":0,"publisher":{"@id":"https:\/\/www.techvc.net\/#organization"},"articleSection":["MySQL"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/","url":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/","name":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID: - \u6cf0\u514b\u7ef4\u897f@techvc.net","isPartOf":{"@id":"https:\/\/www.techvc.net\/#website"},"datePublished":"2023-09-26T08:26:58+00:00","dateModified":"2023-10-02T15:50:50+00:00","breadcrumb":{"@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.techvc.net\/index.php\/2023\/09\/26\/mysql%e9%94%99%e8%af%afcould-not-find-any-file-associated-with-the-tablespace-id\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.techvc.net\/"},{"@type":"ListItem","position":2,"name":"MySQL\u9519\u8befCould not find any file associated with the tablespace ID:"}]},{"@type":"WebSite","@id":"https:\/\/www.techvc.net\/#website","url":"https:\/\/www.techvc.net\/","name":"\u6cf0\u514b\u7ef4\u897f@techvc.net","description":"\u89e3\u653e\u7a0b\u5e8f\u5458\uff0c\u5e2e\u52a9\u521b\u4e1a\u8005","publisher":{"@id":"https:\/\/www.techvc.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.techvc.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/www.techvc.net\/#organization","name":"\u5317\u4eac\u6cf0\u514b\u7ef4\u897f\u79d1\u6280\u6709\u9650\u516c\u53f8","url":"https:\/\/www.techvc.net\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.techvc.net\/#\/schema\/logo\/image\/","url":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/09\/logo\u5b9d\u5251-edited.png","contentUrl":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/09\/logo\u5b9d\u5251-edited.png","width":820,"height":820,"caption":"\u5317\u4eac\u6cf0\u514b\u7ef4\u897f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"image":{"@id":"https:\/\/www.techvc.net\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.techvc.net\/#\/schema\/person\/4d6bfbcd614005ea07c82a30df5a1bb1","name":"\u732b\u5934\u54e5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/10\/\u6734\u6d77\u6797_avatar_1696137507.png","url":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/10\/\u6734\u6d77\u6797_avatar_1696137507.png","contentUrl":"https:\/\/www.techvc.net\/wp-content\/uploads\/2023\/10\/\u6734\u6d77\u6797_avatar_1696137507.png","caption":"\u732b\u5934\u54e5"},"description":"\u732b\u5934\u54e5\u64c5\u957f\u5927\u578b\u7f51\u7ad9\u6280\u672f\u67b6\u6784\uff0c\u5927\u578b\u7814\u53d1\u56e2\u961f\u6280\u672f\u7ba1\u7406\uff0c\u591a\u7aef\u7814\u53d1\u3001\u5168\u6808\u7814\u53d1\uff0c\u6b22\u8fce\u968f\u65f6\u54a8\u8be2\u3002","url":"https:\/\/www.techvc.net\/index.php\/author\/piaohailin@techvc.net\/"}]}},"_links":{"self":[{"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/posts\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":1,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"predecessor-version":[{"id":335,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/posts\/334\/revisions\/335"}],"wp:attachment":[{"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techvc.net\/index.php\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}