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.
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
- Log in to your cPanel account.
- Use the Backup Wizard or the Backup interface to create a full or partial backup.
- Download the backup file to your computer.
- Verify the backup file integrity after download.
- 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.
- Log in to cPanel using your 220 Internet Services credentials.
- In the Files section, click Backup. Alternatively, click Backup Wizard for a guided step-by-step process.
- Under Full Backup, select Download a Full Account Backup.
- Choose Home Directory as the backup destination.
- Enter your email address if you want a notification when the backup is complete.
- Click Generate Backup.
- Once finished, click the backup filename to download the
.tar.gzfile to your computer.
Backing Up MySQL Databases
- In cPanel, go to the Databases section and click phpMyAdmin.
- Select your database from the left-hand menu. Verify the database name before import to avoid overwriting the wrong database.
- Click the Export tab in the top navigation bar.
- Choose Quick export method and SQL format.
- Ensure all tables are selected and check the Add DROP TABLE option to ensure a clean import.
- Click Go to download the
.sqlfile.
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:
- Your domain name and cPanel username.
- The filename and date of the backup you wish to restore.
- Whether you require a full account restore or specific files/databases only.
- Any error messages received during the backup or download process.
Restoring a MySQL Database
- In cPanel, go to the Databases section and click phpMyAdmin.
- Select your database from the left-hand menu. Verify the database name before import to avoid overwriting the wrong database.
- Click the Import tab in the top navigation bar.
- Click Choose File and select your
.sqlbackup file. - Click Go to begin the import.
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
- 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.
- If you requested an email notification for a full backup and it never arrives, check your spam or junk folder. If the email is still missing, log in to cPanel and check the Backup interface to see if the backup file was generated. If the file exists, download it manually. If not, Open a Ticket for assistance.
Backup File Too Large to Download
- Large backup files may exceed browser download limits or time out during transfer.
- Try using a download manager or a wired internet connection for improved stability.
- Exclude cache or temporary files from your file backup to reduce the overall size.
- If the file remains too large, Open a Ticket and request alternative backup retrieval options from our Brisbane support team.
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.
Database Import Timeout
- Large
.sqlfiles may cause phpMyAdmin to time out during import. - Split the database backup into smaller files and import them separately.
- Verify the database name before import to ensure you are restoring to the correct database.
- If the import continues to fail, Open a Ticket and our Brisbane team can assist with the database restoration.
If you encounter issues creating or restoring backups, Open a Ticket with our Brisbane support team.
Still Having Issues?
💻 Open a Ticket