How to back up and restore databases with Plesk

This article describes how to back up and restore your databases using Plesk.

Backing up a database

You can quickly and easily create a database backup using Plesk. When you do this, Plesk exports the database as an SQL file.

To back up a database using Plesk, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see this article.
  2. In the left sidebar, click Databases.
  3. Locate the database you want to back up, and then click Export Dump:

    Plesk - Databases - Export Dump

  4. Select a destination directory for the backup file, specify a filename, and then click OK. Plesk creates the backup file.

    To download the backup file to your local computer automatically, select the Automatically download dump after creation check box.

Restoring a database

You can quickly and easily restore a database using Plesk.

To avoid potential data loss, you should always back up the existing database to a different filename before you try to restore from a previous backup.

To do this, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see this article.
  2. In the left sidebar, click Databases.
  3. Locate the database you want to restore, and then click Import Dump:

    Plesk - Databases - Import Dump

  4. Browse to the backup file location, select the file, and then click OK.

More Information

For more information about Plesk, please visit https://www.plesk.com.

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.