Knowledge Essentials - 3Essentials Hosting

How-To Backup and Restore MySql Databases with phpMyAdmin

Article ID: 2192

 Back to Search

Plesk

Plesk 9.5 and earlier

Accessing phpMyAdmin

  1. Log in to your plesk control panel.
  2. There is slight variation between control panel versions, we are looking to get to the domain specific control area. So if you are looking to backup the database for a particular website you will need to go that websites control area. On the left of your screen select home, and than on the bottom of the new window click on the url of the site you want the database backed up or restored for. If your home screen does not specifically list your domains, select the Domains icon, than select the URL for the site.
  3. Once on the screen for your specific domain select databases. 
  4. Select the mysql database that you want to backup or restore.
  5. At the top of the screen you will see a option for webadmin, clicking on this will open phpmyadmin.
  6. On the left side of your screen in the phpMyAdmin window you will see your database name. Click on your database name.
  7. This will open a tabbed window on the left with the following (depending on version) Structure, SQL, Search, Query, Export, Import.

Backup

  1. After following step's one through seven above, select the Export tab in the main window of phpMyAdmin.
  2. Unless you are a advanced user do not edit the settings under the 'View dump(schema) of database' window.
  3. Select the checkbox next to 'Save as file'.
  4. If you want to download the file compressed select "zipped" next to compression, or if you prefer "gzipped".
  5. Select 'Go' to download a backup of your database.

Restore

  1. After following steps one through seven above, select the Import tab in the main window of phpMyAdmin. 
  2. Under 'File to import' select the 'Choose File' option and select the .sql file you wish to restore with.
  3. Leave everything else alone.
  4. Select 'Go' to restore your database. **Warning** This will over write your existing database **Warning**

Plesk 10 and later

Accessing phpMyAdmin

  1. Once you login to your control panel, select the Websites & Domains tab, if it isnt already selected.
  2. You will see all of your databases listed on this page. On the same line as the database you want to edit select the 'Webadmin' link.
  3. This will open phpMyAdmin in a new window or tab.
  4. Select the databases tab from the top of the phpMyAdmin window.
  5. Under the databases tab you should see the name of your particular database, if you just mouse over the name it should say jump to database. Select that link.

Backup

  1. After following steps one through five above, on the phpMyAdmin window select the Export tab.
  2. Select Go to download the backup as a .sql.

Restore

  1. After following steps one through five above, on the phpMyAdmin window select the Import tab.
  2. Choose the file that you want to restore with the 'Choose File' button.
  3. Unless you are a advanced user, leave all of the other settings alone.
  4. Select Go to restore from your backup. **Warning** This will over write your existing database. **Warning**

 

Cpanel

Accessing phpMyAdmin

  1. Log into your control panel.
  2. Under the databases field select phpMyAdmin.

Backup

  1. Once in the new phpMyAdmin window or tab, select the Databases tab.
  2. Find the name of the database you want to backup and click on it, this will jump you to working inside of that database.
  3. Select the Export tab.
  4. Select Go to download the database as a .sql file. 

Restore

  1. In the new phpMyAdmin window or tab select the Databases tab.
  2. Find the name of the datbase that you want to restore to, and click on it, this will jump you to working inside of that database.
  3. Select the import tab.
  4. Use the 'Choose File' button to select the .sql file to restore with from your local machine.
  5. Select Go to restore your database. **Warning** This will over write your existing database. **Warning**
 
Downloads Associated With This Article
No downloads are currently associated with this article.