Taking backup of database and restoring it in Plesk

Manual database backup in Plesk

1. Login to plesk panel and Go to Websites & Domains > Databases.

2. In the database tools pane Export Dump.

3. After clicking on export dump. A dialogue box appears to save dump.

• To save a dump 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”.

4. After selecting the directory, click OK.
   
   

                                                                                                                                                  Restore database dump.

1. Go to Websites & Domains > Databases .

2. Create new database by clicking on “Add Database” or you can manage your existing database.

NOTE: - The database name should be same as the old database dump name.

3.After creating the database, Click “Import Dump” in the database tools pane.

4.  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, select the dump file and click OK.

The process has completed.

Also Read