SQL Queries to Change Website Domain

When moving WordPress websites from one domain to another, this tool is a great time saver. Just generate the queries and run them in MySQL.

The data you input here will be stored in your browser cookies for 10 days. If you do not need it, please use it in Incognito mode.

1
2
3
4
5
6
7
8
UPDATE wp_options SET option_value = REPLACE(option_value, 'http://test.rudrastyh.com', 'https://rudrastyh.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://test.rudrastyh.com', 'https://rudrastyh.com');
UPDATE wp_posts SET post_excerpt = REPLACE (post_excerpt, 'http://test.rudrastyh.com', 'https://rudrastyh.com');
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://test.rudrastyh.com','https://rudrastyh.com');
UPDATE wp_termmeta SET meta_value = REPLACE (meta_value, 'http://test.rudrastyh.com','https://rudrastyh.com');
UPDATE wp_comments SET comment_content = REPLACE (comment_content, 'http://test.rudrastyh.com', 'https://rudrastyh.com');
UPDATE wp_comments SET comment_author_url = REPLACE (comment_author_url, 'http://test.rudrastyh.com','https://rudrastyh.com');
UPDATE wp_posts SET guid = REPLACE (guid, 'http://test.rudrastyh.com', 'https://rudrastyh.com') WHERE post_type = 'attachment';

Comments — 21

Leave a comment

php js HTML CSS Code