Learn about how to access phpMyAdmin from What is phpMyAdmin?, then begin at Step 3.
Log in to your portal.
In the option_value field, enter the URL, then click Go.
As in Step 5, in the option_value field, enter the URL, and then click Go to save the change.This method requires SSH access. First see How to enable SSH access. If you are a Nexcess Cloud client, SSH access is on by default.
use <database>
UPDATE wp_options SET option_value = replace(option_value, 'http://www.<old_url>', 'http://www.<new_url>') WHERE option_name = 'home' OR option_name = '<siteurl>';
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.<old_url>', 'http://www.<new_url>');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.<old_url>','http://www.<new_url>');
Log in to your site's server using the SSH creds in the portal. In order to be able to use WP-CLI, you will need to be using Terminal (Mac) or Putty (Windows).
ls
cd public_html
You have to be in the valid folder of the WordPress install in order to be able to use WP-CLI commands.
The WP-CLI commands to use will be as follows;
wp search-replace '73955dabdf.nxcli.net' 'sitedomain.com' --recurse-objects --skip-columns=user_email,guid --all-tables
wp search-replace 'https://73955dabdf.nxcli.net' 'https://sitedomain.com' --recurse-objects --skip-columns=user_email,guid --all-tables
wp option update home 'https://sitedomain.com'
wp option update siteurl 'https://sitedomain.com'
wp rewrite flush
wp cache flush
You will need to replace sitedomain.com with the actual live domain that are you going to change to.
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.
Our award-winning customer care team is here for you.
Contact Support
