Change host DB URL Update WordPress ( No Plugins )


Do you want to update URLs after moving your WordPress site? It can be quite painful to manually edit each post or page just to replace old URLs. In this article, we will show you how to easily update URLs when moving your WordPress site.

Step 1 :  Login to your database

Step 2 : Select database -> SQL

Step 3 : Copy code below and

+ replace yourprefix_ to your database prefix

+ to your old domain

+ to your new domain

UPDATE `yourprefix_options`
SET option_value = REPLACE(option_value, '', '');

UPDATE `yourprefix_postmeta`
SET meta_value = REPLACE(meta_value, '', '');

UPDATE `yourprefix_posts`
SET post_content = REPLACE(post_content, '', '');

UPDATE `yourprefix_posts`
SET guid = REPLACE(guid, '', '');