====== Migration base de donnée ====== [[https://gist.github.com/Golgarud/9574e152952c23f7223a21c088bcdc1f|Gist]] [[https://interconnectit.com/products/search-and-replace-for-wordpress-databases/|Interconnectit script]] [[https://github.com/interconnectit/Search-Replace-DB|Repo Git]] SQL : # 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}');