Knowledge Base

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.
  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.
  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.