A database dump is used to either backup or duplicate a database. It is basically a file containing database structure and content. 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.
To save a copy of a database:
Go to Websites & Domains > Databases > Export Dump .
You can then save the dump to a directory on the server. Select the directory.
To save a dump on your local computer as well as on the server, select Automatically download dump after creation after that the dump file will be dowloaded to your computer.
In Plesk, database dumps are created in the SQL format and saved as ZIP archives.
To Import your copy of a database in Plesk:
Go to Websites & Domains > Databases > Import Dump
Select a dump to deploy:
You can either upload a dump from your local computer or import a dump stored on your hosting server.
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.
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.
