Move a site . sql

November 15, 2014 - Tech-Admin

UPDATE `wp_site` SET `domain`=REPLACE(`domain`, 'insidelaw', 'lawmaint');

UPDATE `wp_sitemeta` SET `meta_value`=REPLACE(`meta_value`, 'insidelaw', 'lawmaint');

UPDATE `wp_options` SET `option_value`=REPLACE(`option_value`, 'insidelaw', 'lawmaint');

UPDATE `wp_3_options` SET `option_value`=REPLACE(`option_value`, 'insidelaw', 'lawmaint');

UPDATE `wp_4_options` SET `option_value`=REPLACE(`option_value`, 'insidelaw', 'lawmaint');

UPDATE `wp_blogs` SET `domain`=REPLACE(`domain`, 'insidelaw', 'lawmaint');

UPDATE `wp_posts` SET `post_content`=REPLACE(`post_content`, 'insidelaw', 'lawmaint');

UPDATE `wp_3_posts` SET `post_content`=REPLACE(`post_content`, 'insidelaw', 'lawmaint');

UPDATE `wp_4_posts` SET `post_content`=REPLACE(`post_content`, 'insidelaw', 'lawmaint');

UPDATE `wp_posts` SET `guid`=REPLACE(`guid`, 'insidelaw', 'lawmaint');

UPDATE `wp_3_posts` SET `guid`=REPLACE(`guid`, 'insidelaw', 'lawmaint');

UPDATE `wp_4_posts` SET `guid`=REPLACE(`guid`, 'insidelaw', 'lawmaint');