Home › Knowledgebase › KB-890

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

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.

Prerequisites

Before starting, ensure you have your cPanel login credentials for your 220 Internet Services hosting account. You will need access to the cPanel dashboard to perform the steps outlined below.

Quick Fix Steps

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

Detailed Instructions

Backing Up Website Files

Database backups should be performed before any website changes or updates to ensure you have a restore point if something goes wrong.

  1. Log in to cPanel using your 220 Internet Services credentials.
  2. In the Files section, click Backup. Alternatively, click Backup Wizard for a guided step-by-step process.
  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.
A full backup includes your website files, email accounts, and databases. It is ideal for complete disaster recovery.
Backup file size limits and timeout risks apply to large accounts. If your website contains large media libraries or extensive email archives, the backup file may be too large to download via the browser, or the generation process may time out. Consider excluding cache or temporary files from file backups to reduce size.

Backing Up MySQL Databases

  1. In cPanel, go to the Databases section and click phpMyAdmin.
  2. Select your database from the left-hand menu. Verify the database name before import to avoid overwriting the wrong database.
  3. Click the Export tab in the top navigation bar.
  4. Choose Quick export method and SQL format.
  5. Ensure all tables are selected and check the Add DROP TABLE option to ensure a clean import.
  6. Click Go to download the .sql file.
Always verify backup integrity after download. Open the file or check the file size to ensure the download completed successfully and was not corrupted.

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 Ticket.

When opening a support ticket for full backup restoration, include the following information to help our Brisbane team assist you quickly:

Restoring a MySQL Database

  1. In cPanel, go to the Databases section and click phpMyAdmin.
  2. Select your database from the left-hand menu. Verify the database name before import to avoid overwriting the wrong database.
  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.
Importing a database will overwrite existing data in the selected database. Ensure you have a current backup before proceeding.

Backup Frequency and Retention

Small businesses should perform manual backups at least once a week, and before any major website changes, plugin updates, or content migrations. Retain at least three recent backup copies in separate locations, such as an external drive and cloud storage, to protect against hardware failure or data corruption.

Testing Your Backups

It is recommended to test your backups periodically by restoring them to a staging environment. This verifies that the backup files are complete and functional, and ensures you can recover your website quickly in the event of an emergency.

Troubleshooting

Backup Fails to Generate

Backup File Too Large to Download

Cannot Download Backup File

Database Import Timeout

For added protection, consider setting up automated backups through cPanel or scheduling regular off-site backups.
Never store your only backup on the same server as your website. If the server fails, you could lose both your live site and your backup.

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

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket