{"id":606,"date":"2013-05-19T17:17:25","date_gmt":"2013-05-19T16:17:25","guid":{"rendered":"http:\/\/www.ludovicfavre.ch\/blog\/?p=606"},"modified":"2013-05-19T17:18:00","modified_gmt":"2013-05-19T16:18:00","slug":"changer-le-prefix-des-tables-wordpress","status":"publish","type":"post","link":"https:\/\/www.ludovicfavre.ch\/blog\/2013\/05\/changer-le-prefix-des-tables-wordpress\/","title":{"rendered":"Changer le prefix des tables wordpress"},"content":{"rendered":"<p>Voici la proc\u00e9dure pour changer le pr\u00e9fix d&rsquo;une installation WordPress existante (par d\u00e9faut, il vaut &lsquo;wp_&rsquo;).<\/p>\n<p>Prenons par exemple, un schema <strong>test<\/strong>\u00a0sur lequel se trouve les tables, et que l&rsquo;on veut changer le pr\u00e9fix <span style=\"color: #008000;\">wp_<\/span> en\u00a0<span style=\"color: #008000;\">monPrefix_<\/span>,\u00a0\u00a0la requ\u00eate SQL suivante permet de g\u00e9n\u00e9rer les alters requis:<\/p>\n<p><code class=\"codecolorer sql default\"><span class=\"sql\"><span class=\"kw1\">SELECT<\/span>\u00a0CONCAT<span class=\"br0\">&#40;<\/span><span class=\"st0\">'RENAME TABLE '<\/span><span class=\"sy0\">,<\/span> GROUP_CONCAT<span class=\"br0\">&#40;<\/span><span class=\"st0\">'`'<\/span><span class=\"sy0\">,<\/span> TABLE_SCHEMA<span class=\"sy0\">,<\/span> <span class=\"st0\">'`.`'<\/span><span class=\"sy0\">,<\/span> <span class=\"kw1\">TABLE_NAME<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">'` TO `'<\/span><span class=\"sy0\">,<\/span> TABLE_SCHEMA<span class=\"sy0\">,<\/span> <span class=\"st0\">'`.`monPrefix_'<\/span><span class=\"sy0\">,<\/span> SUBSTR<span class=\"br0\">&#40;<\/span><span class=\"kw1\">TABLE_NAME<\/span><span class=\"sy0\">,<\/span><span class=\"nu0\">4<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">'`'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"kw1\">AS<\/span> q\u00a0<span class=\"kw1\">FROM<\/span>\u00a0<span class=\"st0\">`information_schema`<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">`Tables`<\/span> <span class=\"kw1\">WHERE<\/span> TABLE_SCHEMA<span class=\"sy0\">=<\/span><span class=\"st0\">'test'<\/span>;<\/span><\/code><\/p>\n<p>Ensuite, ouvrir wp-config.php et modifier la valeur de la variable : <em>$table_prefix<\/em> en &lsquo;<span style=\"color: #008000;\">monPrefix_<\/span>&lsquo;.<\/p>\n<p>On pourrait croire que les \u00e9tapes ci-dessus sont suffisantes, mais au moment d&rsquo;acc\u00e9der \u00e0 la console d&rsquo;administration, le message suivant appara\u00eet:<\/p>\n<blockquote><p>Vous n\u2019avez pas les droits suffisants pour acc\u00e9der \u00e0 cette page<\/p><\/blockquote>\n<p>Il faut encore modifier les valeurs en base de donn\u00e9e qui sont bas\u00e9es sur ce pr\u00e9fix :<\/p>\n<ul>\n<li>dans la table\u00a0<strong><em>wp_options<\/em><\/strong>, pour la ligne\u00a0la ligne dont le champ\u00a0<strong><em>option_nam<\/em>e<\/strong> vaut\u00a0<strong><em><span style=\"color: #008000;\">wp_<\/span>user_roles<\/em><\/strong>\u00a0, il faut le modifier en\u00a0<em><strong><span style=\"color: #008000;\">monPrefix_<\/span>user_roles<\/strong><\/em><\/li>\n<\/ul>\n<ul>\n<li>de m\u00eame, dans la table\u00a0<span style=\"color: #000000;\"><strong><em>wp_usermeta<\/em><\/strong><\/span>, il faut changer le prefix de toute les lignes ayant comme valeur de champ\u00a0<strong><em>meta_key <\/em><\/strong> les valeurs suivantes :\n<ul>\n<li><strong><em><span style=\"color: #008000;\">wp_<\/span>autosave_draft_ids<\/em><\/strong>,<\/li>\n<li><strong><em><span style=\"color: #008000;\">wp_<\/span>capabilities<\/em><\/strong>,<\/li>\n<li><strong><em><span style=\"color: #008000;\">wp_<\/span>usersettings<\/em><\/strong>,<\/li>\n<li><strong><em><span style=\"color: #008000;\">wp_<\/span>usersettingstime\u00a0<\/em><\/strong><\/li>\n<\/ul>\n<p>deviennent :<\/p>\n<ul>\n<li><span style=\"color: #008000;\"><em><strong>monPrefix_<\/strong><\/em><\/span><strong><em>autosave_draft_ids<\/em><\/strong>,<\/li>\n<li><span style=\"color: #008000;\"><em><strong>monPrefix_<\/strong><\/em><\/span><strong><em>capabilities<\/em><\/strong>,<\/li>\n<li><span style=\"color: #008000;\"><em><strong>monPrefix_<\/strong><\/em><\/span><em><strong>usersettings<\/strong>,\u00a0<\/em><\/li>\n<li><span style=\"color: #008000;\"><em><strong>monPrefix_<\/strong><\/em><\/span><strong>usersettingstime\u00a0<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Voici la proc\u00e9dure pour changer le pr\u00e9fix d&rsquo;une installation WordPress existante (par d\u00e9faut, il vaut &lsquo;wp_&rsquo;). Prenons par exemple, un schema test\u00a0sur lequel se trouve les tables, et que l&rsquo;on veut changer le pr\u00e9fix wp_ en\u00a0monPrefix_,\u00a0\u00a0la requ\u00eate SQL suivante permet &hellip; <a href=\"https:\/\/www.ludovicfavre.ch\/blog\/2013\/05\/changer-le-prefix-des-tables-wordpress\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[41,70],"tags":[61,60],"class_list":["post-606","post","type-post","status-publish","format-standard","hentry","category-coding","category-php","tag-sql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/posts\/606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/comments?post=606"}],"version-history":[{"count":32,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"predecessor-version":[{"id":639,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/posts\/606\/revisions\/639"}],"wp:attachment":[{"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicfavre.ch\/blog\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}