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.

MariaDB database card: phpMyAdmin, Export dump, Import dump, Copy database
MariaDB database card: phpMyAdmin, Export dump, Import dump, Copy database

Export dump

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

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

  1. In the database card, click Import dump.
  2. 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.
  3. The Recreate the database checkbox deletes the current database contents before importing.
  4. Click Import Dump.
Import Database Dump window
Import Database Dump window

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.
Questions and answers
Export dumps only the selected database. If a site uses several databases, export each one.
Yes, upload a .sql file or an archive with it.