How to Export and Import Database Dumps in Plesk?

A file containing the content and structure of a database is called a database dump. It can be utilized as a backup. Only the database management tools could be used to make dumps in previous iterations of Plesk. However, Plesk now provides a quicker method for generating database dumps, storing them, and deploying previously generated dumps on the server.

To export a database dump in Plesk means to store the source database as a file that may be distributed or stored at a later time. Restoring data from a database dump file to a destination database is referred to as importing it. A database can be imported to the same database server or to a different one. The source and destination databases must be of the same kind, such as MySQL, which is the only restriction.

In Plesk, SQL format is used to create database dumps and are saved as ZIP archives. For creating a dump in another format or doing custom settings for a dump, use the native functionality of database management tools (phpPgAdmin, phpMyAdmin, or myLittleAdmin).

Steps to Save a Copy of a Database

1. In the database tools pane, go to Websites & Domains > Databases > Export Dump.

2. Save a dump:

• For saving a dump in a certain directory on the server, select the directory and click on OK. By default, the home directory of your subscription is used.

• For saving a dump on your local computer as well as on the server, select Automatically download dump after creation and click on OK.

Steps to Deploy Your Copy of a Database in Plesk

1. In the database tools pane, go to Websites & Domains > Databases > Import Dump.

2. Select a dump to deploy:

• For deploying a dump from your local computer, select Upload and click Choose file. Then select the ZIP archive that contains the dump file and click on OK.

• For deploying a dump from a directory on the server, select Import and select the dump file and click on OK.

3. Choose Recreate the database to deploy the dump into a freshly constructed database. A new database with the same name will be established and the old one will be removed.

In this way you can export and import database dumps in Plesk.

How To Find The Database Details Of Your WordPress In cPanel?