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 Plesk Panel is the preferred choice for hosting service providers, web designers, and website owners. Plesk Obsidian 18 is the latest release from Plesk and offers a range of new benefits and features for every user type. server or on a remote FTP File Transfer Protocol (FTP) is a standard network protocol used to transfer files from one host to another host over a TCP-based network, such as the Internet. 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 MySQL is the world's most used open source relational database management system that runs as a server providing multi-user access to a number of databases.). 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.