How to import and export MySQL databases in Nexcess Cloud

How to import and export MySQL databases in Nexcess Cloud

What you need

Step 1: Access phpMyAdmin

  1. Log in to the Client Portal. From the home page, click Services > Cloud Accounts.

  2. Either click its name, or select Account Dashboard from the menu toggle.

  3. Click Menu > MYSQL.

  4. Click Launch PhpMyAdmin.

Step 2a: Export the database

To learn about importing databases, go to Step 2b.

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


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


  3. From the With selected list, click Export.


  4. Under Export Method, leave the Quick radio button selected.
  5. Under the Format list, select your desired format.
  6. Click Go, choose a location, and click Save.

 

Step 2b: Import the database

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


  2. Click Import.


  3. Under File to Import, click Choose File and select the file to be imported.

  4. Click Go.

 

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 show running MySQL queries from the CLI
Added on Mon, Dec 17, 2018
How to change the password for a MySQL database user
Added on Wed, Dec 19, 2018
What are Nexcess Cloud dev sites?
Added on Thu, May 3, 2018
How to export and import MySQL tables via CLI/SSH
Added on Mon, Dec 17, 2018
How to truncate MySQL tables in SiteWorx
Added on Mon, Dec 17, 2018
How to create dev sites in Nexcess Cloud
Added on Thu, May 3, 2018
How to change permissions for MySQL users
Added on Thu, Dec 20, 2018
How to schedule cron jobs in Nexcess Cloud
Added on Fri, Jul 6, 2018
How to create MySQL databases with SiteWorx
Added on Mon, Mar 25, 2019
How to resize your Nexcess Cloud account
Added on Fri, Apr 6, 2018