Backing Up and Restoring Databases

You can back up a database in the following ways:

  • Export a database dump in the SQL format. This enables you to create and download the database in a single file. An individual file can be restored into the same or another database. See the Exporting and Importing Database Dumps section for details.
  • Back up an entire subscription. This enables you to create a backup file in a selected storage (on the Plesk server or on a remote FTP server). When restoring the backup, you can select a database to restore. See the Backing Up and Recovering Websites section for details.

You can restore a database either from a subscription backup archive or from an SQL dump file in the following ways:

  • Import a database dump. This enables you to restore data from a file in the SQL format. Individual dumps can be restored into any database of the same type as the type of a dump (for example, MySQL). See the Exporting and Importing Database Dumps section for details.
  • Restore a database from a backup of an entire subscription. When restoring the backup, you can select an individual database to restore. See the Backing Up and Recovering Websites section for details.
 

Leave your comments on this page

Leave your feedback or question on this documentation topic below. For technical assistance, contact your hosting service provider or submit a request to Plesk support. Suggest new features for Plesk here. Discuss general questions on the Plesk forum. All offtopic comments will be removed.