2.13.1.8. Change site url in WordPress

To change the site address using database queries:

1. In the site config file takealook the name of the database to which it is connected.
2. Openup database in phpMyAdmin.
3. Execute the following three SQL queries:

   UPDATE wp_options SET option_value = REPLACE(option_value, 'http://old_domain.com', 'http://new_domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

   UPDATE wp_posts SET guid = REPLACE(guid, 'http://old_domain.com','http://new_domain.com');

   UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://old_domain.com', 'http://new_domain.com');

4. To change the site address in the metadata, you should additionally execute one more request:

   UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://old_domain.com','http://new_domain.com');

5. If the site uses comments, you should additionally execute two more requests:

   UPDATE wp_comments SET comment_content = REPLACE (comment_content, 'http://old_domain.com', 'http://new_domain.com');
   UPDATE wp_comments SET comment_author_url = REPLACE (comment_author_url, 'http://old_domain.com', 'http://new_domain.com');

6. Check the work of the site at the new address.

1. Openup Adminpanel WordPress.
2. Go to the section "Settings → General».
3. Enter the new address in the fields "WordPress address (URL)"And"Website address (URL)". The address must start with a protocol http:// or https:// and there should not be a slash at the end /... An example of a valid address: http://example.com.
4. Click "Save changes».
5. Check the work of the site at the new address.

To change the site url using the WP-CLI utility:

1. Connect to hosting via SSH and install utility, if it has not been previously installed.
2. Go to root directory site by running the command:

   cd ~/example.com/www

   In the team instead of example.com/www enter your details.

3. Replace the site address in its database by running the command:

   wp search-replace 'old-address.com' 'new-address.com'

   In the team instead of old-address.com specify the old site address instead of new-address.com - new.
   As a result of executing the command, information will be displayed about where and how many replacements were made.

4. Check the work of the site at the new address.

You can customize search with replacement more subtly (for example, only for certain tables or columns) using additional attributes described in documentation.