Learn about how to access phpMyAdmin from What is phpMyAdmin?, then begin at Step 3.
Log in to your portal.
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