Exporting and Importing Databases

A database dump is a file containing the structure and data of a database. It is used for backups.
Previously, dumps could not be created in the Plesk hosting panel as quickly as now, since the only way to create them was through phpMyAdmin. Today Plesk uses more advanced ways of creating database dumps.
In Plesk, database dumps are exported from MySQL to a plain text file and then packed into a ZIP archive. If you need a dump in a different format or with custom settings, you can create it with the tools (phpMyAdmin, phpPgAdmin or myLittleAdmin) available in the hosting control panel.

To save database copies, follow these instructions:
1. Go to Websites & Domains > Databases > Export Dump.
2. Save the dump:

• To save the dump to a specific location on the server, specify the folder. By default, it is the root folder of your subscription.
• To save the dump both on the server and on your local disk, select Automatically download dump after creation.

To restore a database copy in Plesk:
1. Open Websites & Domains > Databases > Import Dump in the database management section.
2. Choose the dump to restore:

• Click Upload, then Browse, and select the ZIP archive with the dump file.
• To restore a dump from a folder on the server, select Import and specify the dump file.

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

If you use the help of UkrHost, a domain registration and hosting provider, our qualified specialists will do this work for you. You won't have to spend time on it, rack your brains or worry whether you did everything right.