How to Back Up Your Small Business Website Files and MySQL Databases Using cPanel

Summary

This guide helps you troubleshoot and resolve: How to Back Up Your Small Business Website Files and MySQL Databases Using cPanel. Follow the steps below to fix the issue.

Common Causes

Regular backups are essential for protecting your small business website from accidental deletions, malware, or server failures. This guide walks you through creating manual backups of your website files and MySQL databases using cPanel so you can download them to your local computer for safekeeping.

Quick Fix Steps

1. Log in to your cPanel account.
2. Use the Backup Wizard to create a full or partial backup.
3. Download the backup file to your computer.
4. Store the file securely on an external drive or cloud storage.

Detailed Instructions

Backing Up Website Files

1. Log in to cPanel using your 220 Internet Services credentials.
2. In the Files section, click Backup.
3. Under Full Backup, select Download a Full Account Backup.
4. Choose Home Directory as the backup destination.
5. Enter your email address if you want a notification when the backup is complete.
6. Click Generate Backup.
7. Once finished, click the backup filename to download the .tar.gz file to your computer.

Backing Up MySQL Databases

1. In cPanel, go to the Databases section and click phpMyAdmin.
2. Select your database from the left-hand menu.
3. Click the Export tab in the top navigation bar.
4. Choose Quick export method and SQL format.
5. Click Go to download the .sql file.

Restoring a Backup

Full account backups (.tar.gz) cannot be restored through the standard cPanel interface on shared hosting. To restore a full backup, please open a support ticket and our Brisbane team will assist you.

Restoring a MySQL Database

1. In cPanel, go to the Databases section and click phpMyAdmin.
2. Select your database from the left-hand menu.
3. Click the Import tab in the top navigation bar.
4. Click Choose File and select your .sql backup file.
5. Click Go to begin the import.

Troubleshooting

Backup Fails to Generate

• Ensure you have sufficient disk space available on your hosting account.
• Verify that your session has not timed out; log in again and try again.
• Check that your email address is correct if notifications are not arriving.

Cannot Download Backup File

• Disable any browser pop-up blockers that may be interfering with the download.
• Try using a different web browser or clear your browser cache.
• Confirm that your internet connection is stable.

If you encounter issues creating or restoring backups, Open a Ticket with our Brisbane support team.

Still Having Issues?