cPanel: How to backup a MySQL database

You can backup your MySQL database in two different ways:

1. cPanel Backup Wizard

The Backup Wizard is an automated backup feature available within cPanel. You can use it to create a full backup of your entire site (including your databases) or a backup of only certain elements.

Here is a link to instructions on how to use the Backup Wizard: http://hostpapasupport.com/kb/how-to-back-up-your-hostpapa-website/

2. phpMyAdmin

This is a part of your cPanel that lets you manage databases (and the data they contain) directly as opposed to having to do it through your website.

  1. Log in to your HostPapa dashboard: https://www.hostpapa.com/dashboard

  2. Click on My cPanel. If you have more than one domain associated with your HostPapa account, click on the appropriate domain link, then enter your cPanel password if required.

  1. From the Databases section, click on phpMyAdmin.

  2. In the left column, click the name of the database you wish to backup.

  3. Click on the Export tab on the right.

  4. Choose the tables you wish to backup, or click Select All to backup all of your tables.

  5. Scroll down and ensure the Save as File box is checked off.

  6. Click the Go button found in the lower right corner. You will be prompted to find a place on your hard drive to store the backup file, and then the download will begin.

Need more help? Please open a support ticket here: https://www.hostpapa.com/dashboard

Support ticket tips/info: http://hostpapasupport.com/kb/how-to-open-and-access-support-tickets/

This article is also available in: French, Spanish, German

  • Was this article helpful ?

  • yes   no

Related Articles