WP Network Site Move SQL

gistfile1.sql

-- Make sure ZZZ is the number of the site in the `wp_sites` table. Your root site has no entry so it would be `wp_posts`
--   but your first site in the Network Admin > Sites list would be `wp_1_posts`
-- OLDSITE.TLD and NEWSITE.TLD should be complete FQDNs.  If a site was www.olddomain.com make sure you replace it
--   completely so that you don't end up with www.www.newsite.com

UPDATE wp_ZZZ_postmeta SET meta_value = replace(meta_value,'OLDSITE.TLD','NEWSITE.TLD') WHERE meta_value like '%OLDSITE.TLD%';
UPDATE wp_ZZZ_posts SET guid = replace(guid, 'OLDSITE.TLD','NEWSITE.TLD');
UPDATE wp_ZZZ_posts SET post_content = replace(post_content, 'OLDSITE.TLD','NEWSITE.TLD');
-- Close comments on all existsing posts and pages
UPDATE wp_ZZZ_posts SET ping_status = 'closed', comment_status = 'closed' WHERE post_type IN ('post,'page');