{"id":8185,"date":"2020-07-21T18:46:49","date_gmt":"2020-07-21T09:46:49","guid":{"rendered":"http:\/\/www.k-in.co.jp\/niwakan\/?p=8185"},"modified":"2021-11-18T09:14:07","modified_gmt":"2021-11-18T00:14:07","slug":"mysql%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e7%a0%b4%e6%90%8d","status":"publish","type":"post","link":"https:\/\/www.k-in.co.jp\/niwakan\/archives\/2020\/07\/8185\/","title":{"rendered":"MySQL\u306e\u30c7\u30fc\u30bf\u7834\u640d"},"content":{"rendered":"<p><a href=\"https:\/\/ja.wordpress.org\/plugins\/wp-slimstat\/\">Slimstat Analytics<\/a>\u306e\u89e3\u6790\u304c\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002<br \/>\nMySQL\u4e0a\u3067\u30c7\u30fc\u30bf\u304c\u7834\u640d\u3057\u305f\u6a21\u69d8\u3002<br \/>\n<!--more--><\/p>\n<p>\u4e00\u5148\u305a\u30c7\u30fc\u30bf\u3092\u9000\u907f\u3057\u307e\u3059\u3002<br \/>\nphpMyAdmin\u3092\u4f7f\u3063\u3066\u3001\u5168\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3057\u305f\u3002<br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.k-in.co.jp\/niwakan\/wp-content\/uploads\/2020\/07\/d8db0b4047d25113411a666842a7f5e6.png?resize=300%2C243&#038;ssl=1\" alt=\"\" width=\"300\" height=\"243\" class=\"alignnone size-medium wp-image-8187\" srcset=\"https:\/\/i0.wp.com\/www.k-in.co.jp\/niwakan\/wp-content\/uploads\/2020\/07\/d8db0b4047d25113411a666842a7f5e6.png?resize=300%2C243&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.k-in.co.jp\/niwakan\/wp-content\/uploads\/2020\/07\/d8db0b4047d25113411a666842a7f5e6.png?resize=150%2C121&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.k-in.co.jp\/niwakan\/wp-content\/uploads\/2020\/07\/d8db0b4047d25113411a666842a7f5e6.png?w=873&amp;ssl=1 873w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\n\u6b21\u306b\u3001\u4e00\u5fdc\u5ff5\u306e\u305f\u3081\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u3053\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u66f4\u65b0\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3002<br \/>\nMySQL\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u304b\u3063\u305f\u6a21\u69d8\u3067\u3059\u3002<br \/>\n\u30c7\u30fc\u30bf\u306e\u4e00\u90e8\u304c\u58ca\u308c\u3066\u3044\u305f\u304b\u3001\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u306e\u554f\u984c\u3067\u3057\u3087\u3046\u304b\u3002<br \/>\n\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u4e0a\u3067rm -R\u3057\u3001\u524a\u9664\u3057\u3061\u3083\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u518d\u5ea6\u540c\u540d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u308a\u3001\u5148\u7a0b\u306e\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u5fa9\u5143\u3002<br \/>\nSlimstat Analytics\u3092\u5165\u308c\u76f4\u3057\u3001\u30c7\u30fc\u30bf\u3092\u521d\u671f\u5316\u3057\u307e\u3057\u305f\u3002<br \/>\n\u304c\u3001\u4e00\u90e8\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u6210\u304c\u9055\u3046\u3068\u30a8\u30e9\u30fc\u767a\u751f\u3002<\/p>\n<p>Apache\u306e\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u8997\u3044\u3066\u307f\u308b\u3068\u4e0b\u8a18\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u304c\u3002<\/p>\n<pre class=\"lang:default decode:true \" title=\"Apache error log\" >[Tue Jul 21 09:41:57.434614 2020] [:error] [pid 1605] [client 127.0.0.1:51095] WordPress \\xe3\\x83\\x87\\xe3\\x83\\xbc\\xe3\\x82\\xbf\\xe3\\x83\\x99\\xe3\\x83\\xbc\\xe3\\x82\\xb9\\xe3\\x82\\xa8\\xe3\\x83\\xa9\\xe3\\x83\\xbc: Tablespace for table '`wordpress`.`wp_1_slim_events_archive`' exists. Please DISCARD the tablespace before IMPORT. for query \\n\\t\\t\\tCREATE TABLE IF NOT EXISTS wp_1_slim_events_archive (\\n\\t\\t\\t\\tevent_id INT(10) NOT NULL AUTO_INCREMENT,\\n\\t\\t\\t\\ttype TINYINT UNSIGNED DEFAULT 0,\\n\\t\\t\\t\\tevent_description VARCHAR(64) DEFAULT NULL,\\n\\t\\t\\t\\tnotes VARCHAR(256) DEFAULT NULL,\\n\\t\\t\\t\\tposition VARCHAR(32) DEFAULT NULL,\\n\\t\\t\\t\\tid INT UNSIGNED NOT NULL DEFAULT 0,\\n\\t\\t\\t\\tdt INT(10) UNSIGNED DEFAULT 0,\\n\\n\\t\\t\\t\\tCONSTRAINT PRIMARY KEY (event_id),\\n\\t\\t\\t\\tINDEX wp_1_slim_stat_events_archive_idx (dt)\\n\\t\\t\\t) COLLATE utf8_general_ci  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, call_user_func_array, wp_slimstat_admin::init, wp_slimstat_admin::init_environment, wp_slimstat_admin::init_tables, wp_slimstat_admin::_create_table, referer: http:\/\/www.k-in.co.jp\/main\/wp-admin\/index.php<\/pre>\n<p>\u3053\u306e\u90e8\u5206<br \/>\n<strong>Tablespace for table &#8216;`niwakan`.`wp_1_slim_events_archive`&#8217; exists. Please DISCARD the tablespace before IMPORT. for query<\/strong><br \/>\n\u3064\u307e\u308a\u3001\u4e0b\u8a18\u3092\u53c2\u7167\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308a\u76f4\u305b\u3068\u8a00\u3046\u3053\u3068\u3067\u3059\u306d\u3002<\/p>\n<p><strong>\\n\\t<\/strong>\u3092\u6539\u884c\u30fb\u30bf\u30d6\u306b\u7f6e\u304d\u63db\u3048\u308b\u3068<\/p>\n<pre class=\"lang:mysql decode:true \" title=\"Creat table sql\" >CREATE TABLE IF NOT EXISTS wp_1_slim_events_archive (\r\n\t\t\t\tevent_id INT(10) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\ttype TINYINT UNSIGNED DEFAULT 0,\r\n\t\t\t\tevent_description VARCHAR(64) DEFAULT NULL,\r\n\t\t\t\tnotes VARCHAR(256) DEFAULT NULL,\r\n\t\t\t\tposition VARCHAR(32) DEFAULT NULL,\r\n\t\t\t\tid INT UNSIGNED NOT NULL DEFAULT 0,\r\n\t\t\t\tdt INT(10) UNSIGNED DEFAULT 0,\r\n\r\n\t\t\t\tCONSTRAINT PRIMARY KEY (event_id),\r\n\t\t\t\tINDEX wp_1_slim_stat_events_archive_idx (dt)\r\n\t\t\t) COLLATE utf8_general_ci<\/pre>\n<p>SQL\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u308c\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308a\u76f4\u3059\u3053\u3068\u3067Slimstat Analytics\u304c\u52d5\u304f\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u30a8\u30e9\u30fc\u30ed\u30b0\u3063\u3066\u5049\u5927\u3067\u3059\u306d\u3047\u3002 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Slimstat Analytics\u306e\u89e3\u6790\u304c\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002 MySQL\u4e0a\u3067\u30c7\u30fc\u30bf\u304c\u7834\u640d\u3057\u305f\u6a21\u69d8\u3002<\/p>\n","protected":false},"author":1,"featured_media":8186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[115],"tags":[159,39,38,160],"class_list":["post-8185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software","tag-apache","tag-mysql","tag-php","tag-phpmyadmin"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.k-in.co.jp\/niwakan\/wp-content\/uploads\/2020\/07\/8755447866f5167b51e20b33956d6fcf.png?fit=1269%2C803&ssl=1","_links":{"self":[{"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/posts\/8185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/comments?post=8185"}],"version-history":[{"count":0,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/posts\/8185\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/media\/8186"}],"wp:attachment":[{"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/media?parent=8185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/categories?post=8185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.k-in.co.jp\/niwakan\/wp-json\/wp\/v2\/tags?post=8185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}