How to Backup & Restore MySQL Database in cPanel?

[HosTechS]

To backup the databases please do the following:

1. Login to your control panel and click Backups.
2. Under Download a MySQL Database Backup, click the name of the database.
3. Click Save As.
4. Select a destination for where you would like the back up to be saved, locally.

Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

To restore a database, please do the following:
1. Login to your control panel and click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the .sql.gz file which you want to be restored.
4.Click the Open button and click the Upload button.

Your database driven website should be working again.

[Wolverine]

Thank you for your advise!

[Kailash]

Thanks For Advise

[HosTechS]

Thank you for your advise!

You're most welcome:)

[dockerdan]

The best way to backup and restore a MySQL database in cPanel would be from the phpMyAdmin application:

On the cPanel Home screen, scroll down to Databases and click on phpMyAdmin.

Select the database you would like to backup from the left navigation tree.

Click the Export tab.

Choose the Quick export method and click Go.

Your export of your database will be downloaded to your local machine's default downloads location.

To restore your MySQL database from a Backup in phpMyAdmin:

Choose the database you want to restore from the left navigation tree.

The phpMyAdmin script that restores your database does not drop the tables first.

Click the Check All check box.

Click the With selected: drop down menu and choose Drop.

Confirm by clicking Yes.

Click the Import tab.

Click the Choose File button to browse for the MySQL backup.

Click Go.


Using this method will ensure that you have the exact .sql file for your database and that you can see the execution of the backup and restoration process directly in the mySQL administration console.

[Isabella020]

To backup the databases please do the following:

1. Login to your control panel and click Backups.
2. Under Download a MySQL Database Backup, click the name of the database.
3. Click Save As.
4. Select a destination for where you would like the back up to be saved, locally.

Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

To restore a database, please do the following:
1. Login to your control panel and click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the .sql.gz file which you want to be restored.
4.Click the Open button and click the Upload button.

Your database driven website should be working again.

wow that's great information thanks for share how to get sql and backup and update again on the database this is very important because of some time hacker put the script in data website distribute...