Collapse

Announcement

Collapse
No announcement yet.

How to backup and restore MySQL database in cPanel

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

  • How to backup and restore MySQL database in cPanel

    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.
Working...
X