Restoring a Single Database in cPanel with JetBackup

Managing backups is essential for keeping any website or application running smoothly. JetBackup’s self‑service feature in cPanel lets you restore individual databases or single files without involving support staff. This guide walks you through the entire process—from finding the right backup to verifying that the restore was successful. The instructions apply to any cPanel installation that has JetBackup enabled, regardless of the underlying server OS.

1. Accessing JetBackup in cPanel

Before you can restore anything, you need to reach the JetBackup interface:

1. Log in to your cPanel account using the URL provided by AtoZNode (typically https://your‑domain.com:2083).
2. Enter your cPanel username and password.
3. In the Files section, click the JetBackup icon. If the icon is missing, contact your hosting provider to confirm that JetBackup is enabled for your account.

The JetBackup dashboard shows a summary of available backup sets, including daily, weekly, and monthly snapshots.

2. Locating the Desired Backup Set

JetBackup organizes backups by date and type. Follow these steps to find the correct backup:

• From the left‑hand menu, select Backups → Full Backups (or Partial Backups if you know the backup was created as a partial set).
• Use the calendar view or the list of dates to locate the backup that contains the database or file you need to restore. Hovering over a date shows a tooltip with the backup type (e.g., “Daily – 2024‑09‑15”).
• Click the date to expand the backup contents. You’ll see separate sections for Home Directory, MySQL Databases, Email, etc.

3. Restoring a Single Database

Restoring a MySQL database is straightforward. The steps below assume you have a backup that includes the target database.

3.1 Open the Database Section

• Within the selected backup date, click the MySQL Databases folder.
• You’ll see a list of databases that were part of the backup, each with a checkbox next to it.

3.2 Choose the Database to Restore

1. Check the box next to the database you want to recover.
2. Click the Restore button that appears above the list.

3.3 Confirm the Restore Options

A dialog box asks you to confirm the action. You can choose one of two options:

• Overwrite Existing Database – Replaces the current contents with the backup version.
• Restore to New Database – Creates a new database (you’ll be prompted to enter a name) and leaves the existing one untouched.

Select the option that fits your situation and click Confirm. JetBackup will begin the restoration and display a progress bar.

3.4 Verify the Restoration

1. When the process finishes, return to the cPanel MySQL® Databases page.
2. Open phpMyAdmin (found under the Databases section) and select the restored database.
3. Check that the expected tables and data are present. If you restored to a new database, update any application configuration files (e.g., wp-config.php for WordPress) to point to the new database name, user, and password.

4. Restoring a Single File or Folder

JetBackup also lets you pull out individual files, which is handy for recovering a corrupted upload, a missing configuration file, or a specific piece of content.

4.1 Navigate to the File Tree

• From the backup date view, click the Home Directory folder.
• The file tree expands, showing all directories and files that were backed up.

4.2 Find the Target File

You can either browse manually or use the search box at the top of the file list:

1. Enter the filename (or part of it) in the search field and press Enter.
2. JetBackup filters the list to matching items. Locate the exact file you need.

4.3 Initiate the Restore

• Check the box next to the file (or select an entire folder if you need multiple files).
• Click the Restore button.

4.4 Choose the Destination Path

JetBackup will ask where to place the restored file:

• Original Location – Replaces the existing file at its original path.
• Custom Location – Allows you to specify a different directory (useful for testing before overwriting).

Select the appropriate option and confirm. The interface will show a progress indicator and, upon completion, a confirmation message.

4.5 Test the Restored File

1. Open the file via a web browser or an FTP client to ensure it displays correctly.
2. If the file is part of a web application (e.g., a PHP script), navigate to the relevant page on your site and verify functionality.

5. Using the “Partial Restore” Feature for Faster Recovery

If you only need a small portion of a large backup, JetBackup’s Partial Restore can speed up the process:

1. In the backup date view, click the Partial Restore button at the top right.
2. Select the specific component you need (e.g., “MySQL Databases” or “Home Directory”).
3. Choose the individual items within that component, then click Restore.

This method avoids loading the full backup archive, reducing server load and restoring time.

6. Common Pitfalls and How to Avoid Them

• Overwriting Active Data – Always double‑check whether you’re overwriting a live database or file. When in doubt, restore to a new name and test before replacing the original.
• Permission Mismatches – Restored files inherit the permissions they had at backup time. If you encounter “403 Forbidden” or “Permission denied” errors, adjust the file or directory permissions via the cPanel File Manager or an SSH session.
• Database User Mismatch – If you restore a database to a new name, you must also create a corresponding MySQL user (or assign an existing one) and update any application config files accordingly.
• Outdated Backup Sets – JetBackup retains backups based on the retention policy set by your hosting plan. If the needed backup isn’t listed, it may have been purged; contact support for possible recovery from server‑level snapshots.

Conclusion

JetBackup’s self‑service interface gives cPanel users a reliable way to retrieve a single database or file without waiting for support. By following the steps outlined above—locating the correct backup set, selecting the exact item, confirming restore options, and verifying the result—you can minimize downtime and keep your website or application running smoothly. Regularly review your backup retention settings and test restores periodically to ensure you’re always prepared for the unexpected.