Collapse

Announcement

Collapse
No announcement yet.

How to backup and restore MySQL database in Plesk Panel.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to backup and restore MySQL database in Plesk Panel.

    To backup or download the MySQL database:

    1. Login to Plesk control panel.

    2. Click on Websites & Domains.

    Click image for larger version  Name:	ftp1.png Views:	5 Size:	21.5 KB ID:	981

    3. Locate the domain for which you want to take database backup

    4. Click on Databases.

    Click image for larger version  Name:	database1.png Views:	2 Size:	11.2 KB ID:	982

    5. Find the database name that you wish to export.

    6. click Export Dump.

    Click image for larger version  Name:	database2.png Views:	1 Size:	24.4 KB ID:	983

    7. A popup box will show you the directories inside your domain.

    8. If you want to save a database in a certain directory on the server, select the directory. It will save the database on the server.

    9. If you want to download a database on your local computer, then select the Automatically download dump option.

    10. Click on the OK icon.

    Click image for larger version  Name:	database3.png Views:	1 Size:	26.1 KB ID:	984


    To restore the MySQL database:

    1. Login to Plesk control panel.

    2. Click on Websites & Domains.

    Click image for larger version  Name:	ftp1.png Views:	5 Size:	21.5 KB ID:	985

    3. Locate the domain for which you want to take database backup

    4. Click on Databases.

    Click image for larger version  Name:	database1.png Views:	2 Size:	11.2 KB ID:	986

    5. click import Dump.

    Click image for larger version  Name:	database4.png Views:	1 Size:	25.4 KB ID:	987

    6. If you want to import a database backup from your local computer, select Upload and click Browse. Then select the ZIP file of the database and click on OK.

    Click image for larger version  Name:	database11.png Views:	1 Size:	17.5 KB ID:	988

    7. If you want to import the database from a directory on the server, select Import and select the dump file.

    Click image for larger version  Name:	database12.png Views:	1 Size:	18.4 KB ID:	989

    8. If you want to restore a dump into a newly created database, then select Recreate the database.

    The old database will be deleted and a new one, with the same name, created.

    Click image for larger version  Name:	database13.png Views:	1 Size:	11.5 KB ID:	990

    In this way, you can backup and restore the database in Plesk.
    Last edited by Sayali; 01-23-2020, 05:49 PM.
Working...
X