Here we will discuss how to backup and restore databases on Plesk. You can follow the steps for database backup in the following way:
1. Export a database dump in SQL format. This allows you to create and download the database in one file. The individual files can be restored to the same or another database. See Exporting and Importing Database Dumps section for details.
2. Backup the entire subscription. This allows you to create backup files in the selected storage (on the Plesk server or on a remote FTP server). When restoring a backup, you can select the database to restore. See the Backing Up and Restoring a Website section for details. You can restore a database either from a subscribed backup archive or from a junk SQL file in the following way:
- Import database dumps. This allows you to recover data from files in SQL format. Individual dumps can be restored to a database of the same type as the dump type (for example, MySQL). See Exporting and Importing Database Dumps section for details.
- Restore a database from a backup of the entire subscription. When restoring a backup, you can select individual databases to restore. See the Backing Up and Restoring Websites section for details.
Exporting and importing database dumps
Dump database file which contains the database structure and content. You can use it for backup purposes. In previous versions of Plesk, dumps could be created using only database management tools. Now Plesk offers a faster way to create a database dump store it, and deploy the previously created dump on the server.
In Plesk, to export a database dump means to save the source database in a file that can be used for storage or distribution. To import a database dump means to restore the data from the file to the destination database. You can import a database to the same or another database server. The only limitation is that the destination database must be of the same type, for example, MySQL.
In Plesk, database dumps are created in SQL format and saved as ZIP archives. If you need to create a dump in another format or to set special settings for the dump, use the native functions of the database management tool (phpMyAdmin, phpPgAdmin, or myLittleAdmin). For instructions on how to perform imports and exports with database management tools, refer to the tools' built-in help section.
To store a copy of the database:
1. Go to Website & Domain > Database > Export Dump in the database tools panel.
2. To save the dump in a specific directory on the Plesk server, select the directory. The home directory of the selected customer is used by default.
3. To save the dump on your local computer as well as on the server, select Automatically download dump after creation.
To deploy a copy of the database in Plesk:
1. Buka Websites & Domains >A Databases > Import Dump di panel database.
2. To select the dump from your local computer, select Upload and click Browse. Then select the ZIP archive with the dump file.
3. To select a dump from a directory on the server, select Import and select files from the dump.
4. To deploy the dump into a newly created database, select Recreate Databases. The old database will be deleted and a new one, with the same name, created.
Noted: Alternatively, you can backup the database as part of the subscription during the subscription backup and then restore it separately. See the Backing Up and Restoring a Website section for details.