Database export and import in Plesk
A dump is a file with the contents of a database. You need it for a backup, a site migration or a staging copy. All actions are in the database card: Databases, then the database.

Export dump
- In the database card, click Export dump.
- Choose the folder on the hosting to save the dump in, and the file name (Dump filename, a .sql.zip archive).
- To download the file to your computer right away, check Automatically download the dump after its creation.
- Click Export Dump.

Do not save the dump in httpdocs: everything in that folder is reachable from the internet. Save it to the hosting root outside httpdocs and delete it when it is no longer needed.
Import dump
- In the database card, click Import dump.
- Choose Upload a dump from your local computer and select the file, or Import a dump stored on your hosting server if the file is already on the hosting.
- The Recreate the database checkbox deletes the current database contents before importing.
- Click Import Dump.

With Recreate the database, all current data in the database is deleted. If unsure, export first.
Other actions
- phpMyAdmin — a web tool for MariaDB/MySQL: tables, queries, import and export.
- Copy database — a copy of the database, for example for a staging site (website copying).
- Check and repair — checks and repairs MariaDB/MySQL tables.
MS SQL database cards also have Export dump, Import dump and Copy database; phpMyAdmin does not work for them (MS SQL in Plesk).
Common mistakes
- Encoding problems after import — the dump was made in another encoding; create the dump in utf8mb4 on the old host.
- "Table already exists" — enable Recreate the database or empty the database.
- A large dump does not upload through the browser — upload the file via FTP and choose Import a dump stored on your hosting server.