Database export and import in Plesk

A Database dump contains a record of the table structure and/or the data from a database and is usually in the form of a list of SQL statements. A database dump is most often used for backing up a database so that its contents can be restored in the event of data loss.  

Plesk offers a quicker way to create database dumps, store them, and deploy previously created dumps on the server. You can follow the below mentioend steps to either Export (Save a copy of database) or Import (Deploy the copy in Plesk) 
 

Export Databse or save a copy of a database

1. Go to Websites & Domains > Databases > Export Dump in the database tools pane.

2. Save a dump

   • Save copy in a specific directory on the server: Select the directory since the home directory of your subscription is used by default.

   •   Save a copy on Local Computer (as well as the server):  Select Automatically download dump after creation.

Import Database or deploy your copy of a database in Plesk

1. Go to Websites & Domains > Databases > Import Dump in the database tools pane.

2. Select a dump to deploy:

   • Extract the ".sql" file from the Zip archive.

   • To deploy a dump from your local computer, select Upload and click Browse. Then select the extracted .sql file. 

   • To deploy a dump from a directory on the server, select Import and select the dump file.

3. To deploy the dump into a newly created database, select Recreate the database. The old database will be deleted and a new one, with the same name, created.