Views:

If you wish to move your MySQL database from one server to another, you can export and then import the tables and contents of your database using phpMyAdmin.

Is your database large?

If you have a very large database sometimes the backup process can time out or fail within phpMyAdmin. The workaround to this is to use a simple PHP script, uploaded to your home directory to run the mysqldump command. 

 

Exporting a MySQL Database using Plesk

  1. Navigate to Websites & Domains, click Databases (or use the sidebar “Databases” option)
  2. Identify the Correct Database. You may have a number of databases in your list, so make sure to select the correct one.
  3. Click Export Dump next to the target database. In the popup choose where to save and optionally enable “Automatically download the dump after its creation” to immediately download a .zip file.

Exporting a MySQL Database using phpMyAdmin

  1. Firstly, manage your database with phpMyAdmin by logging into Plesk and clicking on the Databases icon. Click on your database, and then the phpMyAdmin icon.
  2. Once phpMyAdmin has loaded (if it hasn't, check to make sure you allow pop-ups) click on your database in the left column.
  3. Click on the Export tab
  4. Select the tables that you wish to export. In the example below, we have selected all tables, table1, table2 and table3.
  5. Scroll to the bottom of the page, and select Save as file and click Go
  6. Save the resulting SQL dump file to a location on your computer.

Importing a MySQL Database using Plesk

  1. Navigate to Websites & Domains → Databases (or use the sidebar “Databases” option).
  2. If the database already exists, click its name. Else you will need to create a new database.
  3. Click Import Dump next to the database. In the dialog popup select either Upload from local computer: Choose the .sql or .zip file from your machine. Or select from server: If the dump is already on the server, pick it from the list.
  4. Click OK to start the import.

Importing a MySQL Database using phpMyAdmin

  1. Firstly, make sure you have created your new database in Plesk. Then manage your new database with phpMyAdmin by logging into Plesk and clicking on the Databases icon. Click on your database, and then the phpMyAdmin icon.
  2. Once phpMyAdmin has loaded (if it hasn't, check to make sure you allow pop-ups) click on your database in the left column.
  3. Click on the Import tab
  4. Browse to your saved SQL dump file, and click Go to import tables and content to the new database.

Get in touch

For any additional help, give us a call on 0800 477 333 (8AM to 10PM, 7 days a week).

Keywords: MySQL, Databases.