Using phpMyAdmin
ATTENTION: SiteWorx is only available to Nexcess clients on physical (non-cloud) servers. If you are a Nexcess Cloud client, learn about how to access phpMyAdmin from What is phpMyAdmin?, then begin at Step 3.
-
Log in to your SiteWorx account.
- If you do not know your password, click Forgot your password on the login page.
- If you do not know the web address for your SiteWorx login page, either refer to your Welcome Email or contact our 24/7 support team for assistance.
- From the main menu, select Hosting Features > MySQL > PhpMyAdmin.
- From the main menu, select the desired database, then click wp_options.
- In the main table, locate the wp_options table.
- In the option_name column, locate the siteurl entry and click the corresponding Edit option.
In the option_value field, enter the URL, then click Go.
- Under the option_name column, locate the home entry, and corresponding Edit option.
As in Step 5, in the option_value field, enter the URL, and then click Go to save the change.
- If you have a WordPress caching module, flush the module's cache, and the new URLs should work correctly.
Using the command line (CLI)
This method requires SSH access. If you are a Nexcess Classic (non-Cloud) client, first see How to enable SSH access. If you are a Nexcess Cloud client, SSH access is on by default.
- Log in to your server, using SSH credentials provided to you by a Nexcess support technician.
- Enter your MySQL database by executing the below command, but replace the angled brackets (<>) and everything between them with the name of the WordPress database:
use <database>
- Execute the following commands, replacing the the angled brackets (<>) and everything between them with the indicated information:
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>');
- If you have a WordPress caching module, flush the module's cache, and the new URLs should work properly.
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.
