How to Create a MySQL Backup Print

  • Updated on 07-May-2024
  • 35

Hey there! We all understand the importance of having a safety net, and in the world of web hosting, a backup is your ultimate lifesaver. Today, we'll learn how to create a MySQL backup using two methods: through cPanel and phpMyAdmin.

For detailed instructions on how to use cPanel, please refer to our comprehensive guide on using cPanel to backup your website.

How to Create MySQL Backup Using cPanel

  1. Log in to your cPanel: Simply go to your cPanel login page and enter your username and password.
  2. Locate the 'Backup' option: Once you're in your cPanel, scroll down and find the 'Files' section. Click on 'Backup' to proceed.
  3. Choose 'Download a MySQL Database Backup': On the 'Backup' page, under the 'Download a MySQL Database Backup' section, you will find your databases.
  4. Download the backup: Click on the name of the database you want to backup. The download process will start automatically. Save the file in a secure location on your local machine.

Remember, you must avoid storing your backups in your hosting space for reasons detailed in this guide.

How to Create MySQL Backup Using phpMyAdmin

  1. Access phpMyAdmin: From your cPanel, go to 'Databases' and click on 'phpMyAdmin'.
  2. Select your database: In phpMyAdmin, locate the database you want to back up on the left panel and click on it.
  3. Export the database: With your database selected, click on the 'Export' tab on the top menu.
  4. Choose the format and execute the export: Choose the 'Quick' export method, select 'SQL' format, and then hit the 'Go' button. The database backup will be downloaded to your local machine.

Remember, it's crucial to maintain local backups. You can learn more about this in our guide on the importance of local backups.

Also, keep in mind that we at HosterPK provide courtesy backups using JetBackups. To learn how to restore your website using JetBackups in cPanel, refer to this step-by-step guide.

Note: If you're using Plesk Panel, please refer to our Plesk Panel backup guide.

Remember, backups are like insurance; you never know when you'll need them until you do. So, it's better to be prepared and regularly back up your data. Happy hosting!

For further queries or help, do not hesitate to contact our support team.

Was this answer helpful?

« Back