Différences

Ci-dessous, les différences entre deux révisions de la page.

--- webdev:wordpress:migration [16/08/2017 16:18] – dolo
+++ webdev:wordpress:migration [16/08/2017 17:05] (Version actuelle) – dolo
@@ Ligne 1: / Ligne 1: @@
+====== Migration base de donnée ======
+[[https://gist.github.com/Golgarud/9574e152952c23f7223a21c088bcdc1f|Gist]] <del>[[https://interconnectit.com/products/search-and-replace-for-wordpress-databases/|Interconnectit script]]</del> [[https://github.com/interconnectit/Search-Replace-DB|Repo Git]]
+SQL :
+<Code># Changer l URL du site
+UPDATE {tabel_prefix}_options
+SET option_value = replace(option_value, '{urlSearch.org}', '{urlReplace.org}')
+WHERE option_name = 'home'
+OR option_name = 'siteurl';
+# Changer l URL des GUID
+UPDATE {tabel_prefix}_posts
+SET guid = REPLACE (guid, '{urlSearch.org}', '{urlReplace.org}');
+# Changer l URL des médias dans les articles et pages
+UPDATE {tabel_prefix}_posts
+SET post_content = REPLACE (post_content, '{urlSearch.org}', '{urlReplace.org}');
+# Changer l URL des données meta
+UPDATE {tabel_prefix}_postmeta
+SET meta_value = REPLACE (meta_value,'{urlSearch.org}', '{urlReplace.org}');</Code>

Notes