{"id":8846,"date":"2023-05-18T00:06:26","date_gmt":"2023-05-17T15:06:26","guid":{"rendered":"https:\/\/takuyakobayashi.jp\/blog\/?p=8846"},"modified":"2023-05-18T00:14:00","modified_gmt":"2023-05-17T15:14:00","slug":"wordpress%e3%81%ae%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%83%97%e3%83%ac%e3%83%95%e3%82%a3%e3%83%83%e3%82%af%e3%82%b9%e3%82%92%e5%a4%89%e6%9b%b4%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/takuyakobayashi.jp\/blog\/2023\/05\/18\/8846","title":{"rendered":"WordPress\u306e\u30c6\u30fc\u30d6\u30eb\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<p>wp-config.php\u3092\u958b\u304d\u3001\u300c<strong>$table_prefix = &#8216;wp_&#8217;;<\/strong>\u300d\u3092<br>\u4efb\u610f\u306e\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u300c<strong>$table_prefix = &#8216;newprefix_&#8217;;<\/strong>\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u306e\u5909\u66f4\u3057\u307e\u3059\u3002<br>\u4ee5\u4e0b\u306f\u300cwp_\u300d\u3092\u300c<strong>newprefix_<\/strong>\u300d\u306b\u30ea\u30cd\u30fc\u30e0\u3059\u308bSQL\u30b3\u30de\u30f3\u30c9\u3067\u3059\u3002phpmyadmin\u3067GUI\u3067\u5909\u66f4\u3057\u3066\u3082OK\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>RENAME table wp_commentmeta TO newprefix_commentmeta;\nRENAME table wp_comments TO newprefix_comments;\nRENAME table wp_links TO newprefix_links;\nRENAME table wp_options TO newprefix_options;\nRENAME table wp_postmeta TO newprefix_postmeta;\nRENAME table wp_posts TO newprefix_posts;\nRENAME table wp_terms TO newprefix_terms;\nRENAME table wp_termmeta TO newprefix_termmeta;\nRENAME table wp_term_relationships TO newprefix_term_relationships;\nRENAME table wp_term_taxonomy TO newprefix_term_taxonomy;\nRENAME table wp_usermeta TO newprefix_usermeta;\nRENAME table wp_users TO newprefix_users;<\/code><\/pre>\n\n\n\n<p><strong>newprefix_options<\/strong>\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304d\u3001\u6b21\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u63a2\u3057\u3066\u300cwp_\u300d\u304b\u3089\u300c<strong>newprefix_<\/strong>\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>option_name\u304c\u300cwp_user_roles\u300d \u2192 <strong>newprefix_user_roles<\/strong><\/li>\n\n\n\n<li>option_name\u304c\u300cwp_capabilities\u300d \u2192 <strong>newprefix_capabilities<\/strong><\/li>\n<\/ul>\n\n\n\n<p><strong>newprefix_usermeta<\/strong>\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30ec\u30b3\u30fc\u30c9\u3082\u540c\u69d8\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>meta_key\u304c\u300cwp_capabilities\u300d \u2192 <strong>newprefix_capabilities <\/strong><\/li>\n\n\n\n<li>meta_key\u304c\u300cwp_user_level\u300d \u2192 <strong>newprefix_user_level<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u6ce8\u610f: \u5909\u66f4\u524d\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3092\u5f37\u304f\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<br>\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3057\u305f\u5834\u5408\u3001\u95a2\u9023\u3059\u308b\u30d7\u30e9\u30b0\u30a4\u30f3\u3084\u30ab\u30b9\u30bf\u30e0\u30c6\u30fc\u30de\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u7279\u306b\u3001\u76f4\u63a5\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u30ab\u30b9\u30bf\u30e0\u30b3\u30fc\u30c9\u3084\u30af\u30a8\u30ea\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u5909\u66f4\u3057\u305f\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u306b\u5408\u308f\u305b\u3066\u4fee\u6b63\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>wp-config.php\u3092\u958b\u304d\u3001\u300c$table_prefix = &#8216;wp_&#8217;;\u300d\u3092\u4efb\u610f\u306e\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u300c$table_prefix = &#8216;newprefix_&#8217;;\u300d\u306b\u5909\u66f4 &hellip; <a href=\"https:\/\/takuyakobayashi.jp\/blog\/2023\/05\/18\/8846\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">WordPress\u306e\u30c6\u30fc\u30d6\u30eb\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3059\u308b\u65b9\u6cd5<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-8846","post","type-post","status-publish","format-standard","hentry","category-tips"],"_links":{"self":[{"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/posts\/8846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/comments?post=8846"}],"version-history":[{"count":0,"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/posts\/8846\/revisions"}],"wp:attachment":[{"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/media?parent=8846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/categories?post=8846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/takuyakobayashi.jp\/blog\/wp-json\/wp\/v2\/tags?post=8846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}