How to import and export MySQL databases in SiteWorx

How to import and export MySQL databases in SiteWorx 

Overview
This article explains how Nexcess clients on physical (non-Cloud) servers can import and export MySQL databases with the phpMyAdmin control panel in SiteWorx.

The import and export functions within phpMyAdmin give you an easy way to restore or migrate databases. We recommend you run this process in a test environment before committing to any permanent changes.

Exporting tables

If you are a Nexcess client on a physical (non-Cloud) server, you can export MySQL databases using phpMyAdmin from your SiteWorx account with the below method.

ATTENTION: If you are a Nexcess Cloud client, instead see How to import and export MySQL databases in Nexcess Cloud

  1. Log in to your SiteWorx account.

  2. On the left, select Hosting Features > MySQL > PhpMyAdmin.

  1. Select the correct database from the list on the left.

  1. Select the check box corresponding to the desired table from the Table List, or click Check All.

  1. From the With selected list, click Export.

  1. Under Export Method, leave the Quick radio button selected.

  2. Under the Format list, select your desired format.

  3. Click Go, choose a location, and click Save.

Importing tables

You can import MySQL databases using phpMyAdmin from your SiteWorx account with the following procedure:

  1. Log in to your SiteWorx account.

  2. On the left, select Hosting Features > MySQL > PhpMyAdmin.
     

  1. Select the correct database from the list on the left.

  1. Click Import.

  1. Under File to Import, click Choose File and select the file to be imported. Click Go when ready.

  

For 24-hour assistance any day of the year, contact our Support Team by email or through the Client Portal.

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to configure DNS records in SiteWorx
Added on Wed, Mar 13, 2019
How to change PHP versions in SiteWorx
Added on Mon, Aug 13, 2018
What is SiteWorx?
Added on Tue, Dec 18, 2018
How to activate two-factor authentication in SiteWorx
Added on Fri, Dec 14, 2018
How to create a subdomain with SiteWorx
Added on Wed, Dec 19, 2018
How to change email account passwords in SiteWorx
Added on Wed, Dec 19, 2018
How to use SiteWorx to install ExpressionEngine
Added on Mon, Jan 14, 2019
How to create a pointer domain with SiteWorx
Added on Tue, Dec 18, 2018
How to view website statistics with SiteWorx
Added on Wed, Mar 13, 2019
How to add FTP accounts with SiteWorx
Added on Mon, Jun 11, 2018