Breaking News: Grepper is joining You.com. Read the official announcement!

change url of wordpress website in database using query

Add Answer

Disgusted Dragonfly answered on November 2, 2020 Popularity 8/10 Helpfulness 5/10

answer change url of wordpress website in database using query

related wordpress sql change site url

related change site url wordpress database

related WordPress change urls database SQL

change url of wordpress website in database using query

Comment

-- Update Site URL
UPDATE wp_options SET option_value = replace(option_value, 'your_old_url', 'your_new_url') WHERE option_name = 'siteurl';

-- Update Home URL
UPDATE wp_options SET option_value = replace(option_value, 'your_old_url', 'your_new_url') WHERE option_name = 'home';

-- Update URLs in Post Content
UPDATE wp_posts SET post_content = replace(post_content, 'your_old_url', 'your_new_url');

-- Update URLs in GUID
UPDATE wp_posts SET guid = replace(guid, 'your_old_url', 'your_new_url');

-- Update URLs in Post Meta
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'your_old_url', 'your_new_url');

-- Update URLs in Options
UPDATE wp_options SET option_value = replace(option_value, 'your_old_url', 'your_new_url') WHERE option_name = 'widget_text';

Popularity 8/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: database url using whatever wordpress

Link to this answer
Share Copy Link

Contributed on Jan 27 2024

Disgusted Dragonfly

0 Answers Avg Quality 2/10

Closely Related Answers

wordpress sql change site url

Comment

# Check your table prefix
# Change all the tables 

UPDATE wp_options SET option_value = 
replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' 
OR option_name = 'siteurl';UPDATE wp_posts SET guid = 
replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Popularity 10/10 Helpfulness 9/10 Language sql

Source: www.hostinger.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 02 2020

CodeAsian

0 Answers Avg Quality 2/10

change site url wordpress database

Comment

options table
1. siteurl
2. home

######## OR ########

// Add to top of wp-config.php
define( 'WP_HOME', 'http://example.com' );
define( 'WP_SITEURL', 'http://example.com' );

Popularity 10/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: url

Link to this answer
Share Copy Link

Contributed on Dec 18 2020

Lokesh003Coding

0 Answers Avg Quality 2/10

WordPress change urls database SQL

Comment

Change urls in WordPress database SQL script

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Popularity 8/10 Helpfulness 5/10 Language css

Source: wpbeaches.com

Tags: css database da

Link to this answer
Share Copy Link

Contributed on Oct 31 2023

Poor Panther

0 Answers Avg Quality 2/10

change url of wordpress website in database using query

Contents

More Related Answers

change url of wordpress website in database using query

Closely Related Answers

wordpress sql change site url

change site url wordpress database

WordPress change urls database SQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.