Mettre à jour toutes les URLs WordPress

event 25 Juil 2016 account_circle Julien
label_outline Bash SQL WordPress

UPDATE wp_options
SET option_value = REPLACE(option_value, 'maquettes', 'new')
WHERE option_name = 'home'
OR option_name = 'siteurl';

# CHANGER URL DES GUID (GLOBAL UNIQUE IDENTIFIER)

UPDATE wp_posts
SET guid = REPLACE(guid, 'maquettes', 'new');

# CHANGER LES URL DES CONTENUS DES ARTICLES
# (LIEN, IMAGE, DOCUMENT)

UPDATE wp_posts
SET post_content = REPLACE(post_content, 'maquettes', 'new');

# CHANGER LES URL DES DONNEES META DES POSTS
UPDATE wp_postmeta
SET meta_value = REPLACE(meta_value, 'maquettes','new');

Ou sinon

wp search-replace 'example.dev' 'example.com' --skip-columns=guid