Yes, you can entirely replace the live site with the content built on the staging site.
This article can be used when you are developing an entirely different staging site from scratch with new themes/plugins and layouts and when you want to replace the content on the live site.
A full overview of the hosting panel can be found here.
Step 1. Log in to your WPX account
You can log in to your WPX account here.
Step 2. Navigate to your hosting plan
You can either find your hosting service through the navigation menu or within your dashboard. Once you log in to your WPX account select My Services (1) → WordPress Hosting (2).
Then you will see all of your hosting services with us. When you find the plan that you want to manage, you need to select the orange button Manage service.
Step 3. Delete Live Site Database
To fully replace the content on the live site, start by deleting its existing database. Deleting the live site database will result in brief downtime until the content migration is complete using the Merge to Live function.
Start by going to Databases menu (1) and use the phpMyAdmin button (2) to enter the specific database of the live site you want to replace:
After logging into phpMyAdmin, you’ll see a list of all databases for your sites. Locate and select the specific database that your live site uses, then select all its tables.
Each time you deploy a staging instance, a similar database will appear with a name ending in “_staging” to differentiate it from the live site database.
For example, in the image below, we selected the live database named wpxexamp (1) and then clicked Check all (2) to select all tables.
After you selected all the tables, you will need to use the drop-down menu to select (1) and choose Drop (2) from the options:
That will lead you to a confirmation page where you need to select to finish the process:
Step 4. Delete Live Site files
After deleting all tables from the live site database, the next step is to delete all files except one wp-config.php. The Merge to Live function uses the file to merge the contents of your live and staging sites, so you need to have that one present.
Open the File Manager menu as shown below.
Open the public_html folder of the live site you’re working with. Then select all files with one checkmark NAME (1) and de-select wp-config.php (2).
To delete the selected files, simply right-click on any of them and choose Delete from the menu.
Then a prompt with a final confirmation will appear on the screen. The screen will contain a list of the selected files to be deleted.
Step 5. Merge the Live Site and Staging Site
Now the easy part is to Merge to Live. Go to Manage Websites (1) and select Merge To Live (2) to complete the process:
On the next pop-up click Yes to confirm the operation.
On the next window, remove the check from Make a personal backup of the Live Site first (there is no point in doing it, as you already deleted its content). And click on the Continue with Merging button.
You can close this notification and continue working with the control panel if needed. The process will be completed in the background and you’ll receive a notification once it is completed.
If you get stuck with anything discussed on this page, please get in touch with the WPX Support Team via live chat (use the bottom right-hand widget) and they will respond and help within 30 seconds or less.