SQL queries to change domain name on a WordPress site

queries.sql

# see https://sql.sh/988-requetes-migrer-wordpress

# Change the URL of the site
UPDATE wp_options
SET option_value = replace(option_value, 'http://localhost:8888/site', 'http://www.site.fr')
WHERE option_name = 'home'
OR option_name = 'siteurl';

# Change GUID URL
UPDATE wp_posts
SET guid = REPLACE (guid, 'http://localhost:8888/site', 'http://www.site.fr');

# Change media URL in posts and pages
UPDATE wp_posts
SET post_content = REPLACE (post_content, 'http://localhost:8888/site', 'http://www.site.fr');

# Change metadata URL
UPDATE wp_postmeta
SET meta_value = REPLACE (meta_value, 'http://localhost:8888/site','http://www.site.fr');