Search and replace WP multisite

wp-search-replace-multisite.sql

-- ================================================
-- Script de atualização de domínio - WordPress Multisite
-- Autor: Everaldo Matias (https://everaldo.dev)
-- Licença: MIT License
-- Objetivo: Substituir todas as ocorrências de 
-- 'https://siteantigo.io' por 'https://sitenovo.dev'
-- ================================================

-- RECOMENDAÇÃO: Faça um backup completo do banco de dados antes de executar este script.

-- -------------------------------
-- Atualiza siteurl e home na tabela de opções do site principal
-- -------------------------------
UPDATE wp_options 
SET option_value = REPLACE(option_value, 'https://siteantigo.io', 'https://sitenovo.dev') 
WHERE option_name = 'siteurl' OR option_name = 'home';

-- -------------------------------
-- Atualiza siteurl da rede multisite
-- -------------------------------
UPDATE wp_sitemeta 
SET meta_value = REPLACE(meta_value, 'https://siteantigo.io', 'https://sitenovo.dev') 
WHERE meta_key = 'siteurl';

-- -------------------------------
-- Atualiza conteúdos das postagens (post_content)
-- -------------------------------
UPDATE wp_posts SET post_content = REPLACE(post_content, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_2_posts SET post_content = REPLACE(post_content, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_3_posts SET post_content = REPLACE(post_content, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_4_posts SET post_content = REPLACE(post_content, 'https://siteantigo.io', 'https://sitenovo.dev');

-- -------------------------------
-- Atualiza os GUIDs das postagens
-- Cuidado ao alterar GUIDs; isso pode afetar feeds RSS
-- -------------------------------
UPDATE wp_posts SET guid = REPLACE(guid, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_2_posts SET guid = REPLACE(guid, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_3_posts SET guid = REPLACE(guid, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_4_posts SET guid = REPLACE(guid, 'https://siteantigo.io', 'https://sitenovo.dev');

-- -------------------------------
-- Atualiza valores nos metadados das postagens
-- -------------------------------
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_2_postmeta SET meta_value = REPLACE(meta_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_3_postmeta SET meta_value = REPLACE(meta_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_4_postmeta SET meta_value = REPLACE(meta_value, 'https://siteantigo.io', 'https://sitenovo.dev');

-- -------------------------------
-- Atualiza demais valores nas tabelas de opções
-- -------------------------------
UPDATE wp_options SET option_value = REPLACE(option_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_2_options SET option_value = REPLACE(option_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_3_options SET option_value = REPLACE(option_value, 'https://siteantigo.io', 'https://sitenovo.dev');
UPDATE wp_4_options SET option_value = REPLACE(option_value, 'https://siteantigo.io', 'https://sitenovo.dev');

-- -------------------------------
-- Atualiza domínios na tabela de blogs da rede multisite
-- -------------------------------
UPDATE wp_blogs 
SET domain = REPLACE(domain, 'siteantigo.io', 'sitenovo.dev') 
WHERE domain LIKE '%siteantigo.io%';