{"id":3070,"date":"2018-11-01T18:59:42","date_gmt":"2018-11-01T09:59:42","guid":{"rendered":"http:\/\/taitan916.info\/blog\/?p=3070"},"modified":"2024-02-20T18:19:39","modified_gmt":"2024-02-20T09:19:39","slug":"post-3070","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/3070","title":{"rendered":"Plesk12\u3067\u300cSQLSTATE[42S02]: Base table~~\u300d\u30a8\u30e9\u30fc\u6642\u306e\u5bfe\u5fdc\u65b9\u6cd5"},"content":{"rendered":"<p>Plesk12\u306e\u30ed\u30b0\u30a4\u30f3\u30da\u30fc\u30b8\u3092\u958b\u304f\u3068\u300cERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist (Pdo.php:234)\u300d\u3068\u8868\u793a\u3055\u308c\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u304b\u3063\u305f\u3002\u5bfe\u5fdc\u65b9\u6cd5\u306e\u30e1\u30e2\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u78ba\u8a8d\u3059\u308b<\/h2>\n<p>\/var\/log\/mysqld.log\u306b\u3042\u308bMySQL\u306e\u30ed\u30b0\u3092\u78ba\u8a8d\u3057\u305f\u3068\u3053\u308d\u4ee5\u4e0b\u30a8\u30e9\u30fc\u304c\u51fa\u529b\u3055\u308c\u3066\u3044\u305f\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[ERROR] Cannot find or open table psa\/sessions from\r\nthe internal data dictionary of InnoDB though the .frm file for the\r\ntable exists. Maybe you have deleted and recreated InnoDB data\r\nfiles but have forgotten to delete the corresponding .frm files\r\nof InnoDB tables, or you have moved .frm files to another database?\r\nor, the table contains indexes that this version of the engine\r\ndoesn't support.\r\nSee http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/innodb-troubleshooting.html\r\nhow you can resolve the problem.<\/pre>\n<p>Google\u7ffb\u8a33\u306b\u304b\u3051\u308b\u3068\u4ee5\u4e0b\u306b\u306a\u308b\u3002<\/p>\n<blockquote><p>[ERROR]\u30c6\u30fc\u30d6\u30ebpsa \/ sessions\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3002<br \/>\nInnoDB\u306e\u5185\u90e8\u30c7\u30fc\u30bf\u30c7\u30a3\u30af\u30b7\u30e7\u30ca\u30ea\u306f.frm\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u304c\u3001<br \/>\n\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3059\u308b\u3002\u304a\u305d\u3089\u304f\u3042\u306a\u305f\u306fInnoDB\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u3066\u518d\u4f5c\u6210\u3057\u305f\u3067\u3057\u3087\u3046<br \/>\n\u5bfe\u5fdc\u3059\u308b.frm\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3059\u308b\u306e\u3092\u5fd8\u308c\u3066\u3057\u307e\u3063\u305f<br \/>\nInnoDB\u30c6\u30fc\u30d6\u30eb\u306e.frm\u30d5\u30a1\u30a4\u30eb\u3092\u5225\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u79fb\u52d5\u3057\u307e\u3057\u305f\u304b\uff1f<br \/>\n\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30a8\u30f3\u30b8\u30f3\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059<br \/>\n\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u305b\u3093\u3002<br \/>\nhttp:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/innodb-troubleshooting.html\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u3069\u306e\u3088\u3046\u306b\u554f\u984c\u3092\u89e3\u6c7a\u3067\u304d\u308b\u304b\u3002<\/p><\/blockquote>\n<p>psa\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306esessions\u30c6\u30fc\u30d6\u30eb\uff1f\u3000\u3068\u304b\u3044\u3046\u306e\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u3063\u307d\u3044\u3002\u5c1a\u3001psa\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306fPlesk\u81ea\u4f53\u306e\u7ba1\u7406\u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3089\u3057\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u63a2\u3059<\/h2>\n<p>Plesk\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u81ea\u52d5\u3067\/var\/lib\/psa\/dumps\/\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3055\u308c\u308b\u3002mysql.daily.dump.*.gz(*\u90e8\u5206\u306f\u6570\u5b57)\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306b\u306a\u308b\u3002\u6700\u65b0\u306e\u3082\u306e\u3092\u30ed\u30fc\u30ab\u30eb\u306b\u843d\u3068\u3057\u3066\u4e2d\u8eab\u3092\u898b\u305f\u3068\u3053\u308dpsa\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306edump\u30d5\u30a1\u30a4\u30eb\u3060\u3063\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>psa\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u78ba\u8a8d<\/h2>\n<p>\u4ee5\u4e0b\u3067\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#SSH\u3067MySQL\u306b\u30ed\u30b0\u30a4\u30f3\r\nmysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`\r\n\r\n#psa\u30c6\u30fc\u30d6\u30eb\u306e\u78ba\u8a8d\r\nmysql&gt; show databases like 'psa';\r\n\r\n#\u4ee5\u4e0b\u306e\u5834\u5408\u3060\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3054\u3068\u7834\u640d(\u30b1\u30fc\u30b91)\r\nEmpty set (0.00 sec)\r\n\r\n#\u4ee5\u4e0b\u306e\u5834\u5408\u3060\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3042\u308b\u304c\u4e2d\u8eab\u304c\u7834\u640d(\u30b1\u30fc\u30b92)\r\n+----------------+\r\n| Database (psa) |\r\n+----------------+\r\n| psa            |\r\n+----------------+\r\n1 row in set (0.00 sec)<\/pre>\n<p>\u3061\u306a\u307f\u306b\u4eca\u56de\u306f\u30b1\u30fc\u30b92\u306e\u65b9\u3060\u3063\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30b1\u30fc\u30b91\u306e\u5834\u5408<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u89e3\u51cd(\u30ed\u30fc\u30ab\u30eb\u306e\u3082\u306e\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u3082\u3088\u3044)\r\ngunzip \/var\/lib\/psa\/dumps\/mysql.daily.dump.0.gz \r\n\r\n#\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\r\nmysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` psa &lt; \/var\/lib\/psa\/dumps\/mysql.daily.dump.0<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u30b1\u30fc\u30b92\u306e\u5834\u5408<\/h2>\n<p>dump\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306bcreate database psa\u306e\u8a18\u8ff0\u304c\u4e0a\u90e8\u306b\u3042\u308b\u306e\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u304b\u524a\u9664\u3057\u305f\u4e0a\u3067\u30b5\u30fc\u30d0\u306b\u30a2\u30c3\u30d7\u3059\u308b\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#SSH\u3067MySQL\u306b\u30ed\u30b0\u30a4\u30f3\r\nmysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`\r\n\r\n#\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\r\nsource \/hoge\/hogehoge\/psa.dump;<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u539f\u56e0<\/h2>\n<p>\u76f4\u8fd1\u3067MySQL\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3092MyISAM\u304b\u3089InnoDB\u306b\u5909\u66f4\u3057\u305f\u3002\u305d\u306e\u969b\u306b\/var\/lib\/mysql\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u3042\u308bib_logfile0\u3001ib_logfile1\u3001ibdata1\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u4ed6\u6240\u306b\u79fb\u3057\u305f\u3002\u3059\u308b\u3068information_schema\u4ee5\u5916\u3067\u901a\u5e38\u6642\u306b\u4f7f\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(psa\u4ee5\u5916)\u304c\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u8868\u793a\u3055\u308c\u308b\u3082\u306e\u306e\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u306f\u898b\u3089\u308c\u306a\u304f\u306a\u3063\u305f\u3002\u3053\u3053\u304c\u539f\u56e0\u3060\u3068\u601d\u308f\u308c\u308b\u3002<\/p>\n<p>\u901a\u5e38\u6642\u306b\u4f7f\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u3050\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u304c\u3001psa\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u8a8d\u77e5\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u3067\u7126\u3063\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u305d\u306e\u4ed6<\/h2>\n<p>\u4ee5\u524d\u306bCentOS\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u4e0a\u3052\u3066OpenSSH\u304b\u4f55\u304b\u3092\u66f4\u65b0\u3057\u305f\u969b\u306b\u3001\u4eca\u56de\u3068\u306f\u307e\u305f\u9055\u3046\u30a8\u30e9\u30fc\u3060\u3063\u305f\u3068\u306f\u601d\u3046\u304cPlesk\u306b\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u304f\u306a\u3063\u305f\u3002Plesk\u306e\u7ba1\u7406\u753b\u9762\u4e0a\u4ee5\u5916\uff08SSH\u63a5\u7d9a\u3068\u304b\uff09\u304b\u3089\u30b5\u30fc\u30d0\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b\u3068\u30ea\u30b9\u30af\u3092\u4f34\u3046\u306e\u3067\u6ce8\u610f\u3059\u308b\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u53c2\u8003\u30b5\u30a4\u30c8<\/h2>\n<p><a href=\"https:\/\/support.plesk.com\/hc\/ja\/articles\/213369589--Plesk-%E3%82%92%E9%96%8B%E5%A7%8B%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93-ERROR-PleskFatalException-Unable-to-connect-to-database-Unknown-database-psa-\" target=\"_blank\" rel=\"noopener\">https:\/\/support.plesk.com\/hc\/ja\/articles\/213369589--Plesk-%E3%82%92%E9%96%8B%E5%A7%8B%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93-ERROR-PleskFatalException-Unable-to-connect-to-database-Unknown-database-psa-<\/a><\/p>\n<p><a href=\"https:\/\/support.plesk.com\/hc\/ja\/articles\/213904125--Plesk-%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%83%80%E3%83%B3%E3%83%97%E3%82%92%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97-%E5%BE%A9%E5%85%83%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF\" target=\"_blank\" rel=\"noopener\">https:\/\/support.plesk.com\/hc\/ja\/articles\/213904125--Plesk-%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%83%80%E3%83%B3%E3%83%97%E3%82%92%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97-%E5%BE%A9%E5%85%83%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plesk12\u306e\u30ed\u30b0\u30a4\u30f3\u30da\u30fc\u30b8\u3092\u958b\u304f\u3068\u300cERROR: Zend_Db_State ... <\/p>\n","protected":false},"author":1,"featured_media":4156,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-3070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=3070"}],"version-history":[{"count":1,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3070\/revisions"}],"predecessor-version":[{"id":4778,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3070\/revisions\/4778"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/4156"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=3070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=3070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=3070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}