Exporting and Importing Database Dumps

A database dump is a file containing a database structure and content. You can use it for backup purposes. In earlier Plesk versions, dumps could be created only using database management tools. Now Plesk offers a quicker way to create database dumps, store them, and deploy previously created dumps on the server.

In Plesk, to export a database dump means to save a source database in a file, which then can be used for storage or distribution. To import a database dump means to restore data from such a file to a destination database. You can import a database to the same or another database server. The only restriction is that the source and destination databases must be of the same type, for example, MySQL.

In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native functionality of database management tools (phpMyAdmin, phpPgAdmin, or myLittleAdmin). For instructions on how to import and export data by using database management tools, refer to the tools’ documentation.

To save a copy of a database:

  1. Go to Websites & Domains > Databases > Export Dump in the database tools pane.
  2. Save a dump:
    • To save a dump in a certain directory on the server, select the directory. The home directory of your subscription is used by default.
    • To save a dump on your local computer as well as on the server, select Automatically download dump after creation.

To 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:
    • To deploy a dump from your local computer, select Upload and click Browse. Then select the ZIP archive containing the dump 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.

Note: Alternatively, you can back up a database as part of a subscription during the subscription backup and then restore it separately. See the Backing Up and Recovering Websites section for details.

Related Articles

Adding a Domain Forwarder

To create a domain forwarder in Plesk: Start creating a new domain in Websites & Domains > Add Domain and specify the following: In the Domain name box, type the domain

Configuring DNS for a Domain Cover Image

Configuring DNS for a Domain

The Domain Name System (DNS) is a hierarchical naming system that translates understandable domain names into the numerical identifiers (IP addresses) associated with web hosts.

Website Status 002

Website Status

The website status defines whether a website is available over the Internet and what hosting services are provided for it. The hosting provider may need to change

Website Hosting

WEBSITE HOSTING The Website hosting means that a website is physically located on the server. For the website hosting type you can specify: Document root. The location

Our Service Locations

The Palm Beaches

Coming Soon

Miami / Fort Lauderdale

Coming Soon

Save Up To

50%Off

Select Products and Services For A limited Time!

thanksgiving celebration sale