Change site URL and WordPress URL in Localhost

Question

I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.

My problem is that my another system localhost url is http://localhost/wordpress (not include 8080). So can you help me that is how many table update in our database

Answer 1

I use the following queries to update domain name of the site

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';

UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');

UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');

Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.

Answer 2

Fastest and best way to change the URL is to go to the wp-config.php File and place this code:

define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');