sitename-change-D7.sql

-- Verificar donde existe
SELECT *
FROM `variable`
WHERE `value` LIKE '%sites%'
LIMIT 0 , 30;

-- Modificar las variables de sites
UPDATE variable SET file_public_path = REPLACE(file_public_path, 'www.example.com', 'www.drupalexample.com');
UPDATE variable SET file_private_path = REPLACE(file_private_path, 'www.example.com', 'www.drupalexample.com');

-- Otros datos serializados que puedan aparecer
UPDATE variable SET value = REPLACE(value, 's:36:"sites/www.example.com', 's:42:"sites/www.drupalexample.com');