Accidentally deleting a MySQL database can be stressful, especially if your website relies on that database for content, user data, or functionality. Fortunately, if you’re hosting with Domains.co.za, there may be ways to recover a deleted MySQL database, depending on your backup setup.
In this guide, we explain how to attempt database recovery through your Domains.co.za hosting account and cPanel.
TABLE OF CONTENTS
How to Recover a Deleted MySQL Database
This article assumes that you have already logged into your Domains.co.za Account and have accessed the cPanel Dashboard – refer below for steps on how to do this.
Follow these steps to check for and restore a deleted MySQL database:
How to Find MySQL Database
- Scroll down to Files and click Acronis Backup.
- Look for available Database Backups and find the date closest to when the database was last intact.
How to Restore MySQL Database
- Click Restore next to the desired backup. Confirm the restore action and wait for the process to be completed.
- Once restored, check your website or application to ensure the database is functioning correctly.
Additional Information
How Often Does MySQL Backup?
Domains.co.za includes automatic backups with many hosting plans, but the frequency and retention period may vary; daily backups are typically stored for up to 7–14 days.
MySQL Database Best Practice
To avoid data loss in the future, consider manually exporting your database regularly via phpMyAdmin or scheduling automatic off-site backups.
MySQL Database General Info
- If no backup is available, you may need to contact Domains.co.za support immediately to check if an earlier system-level backup can be recovered.
- Restoring a backup will overwrite the current database, so only use this option if the database is missing or irreparably damaged.
- You can verify successful recovery by connecting to the restored database through phpMyAdmin in cPanel and browsing your tables.
- If your database was connected to a WordPress site and the restore is successful, your site should return to normal without needing additional configuration.
Login to Domains.co.za Account
1. Go to the Domains.co.za Login website page.
2. Enter your Email and Password and click the “Sign In” button.
3. You will see the Domains.co.za Dashboard, displaying the Manage Account menu on the left and your Account Information, Account Overview and Open Support Tickets on the right.
Login to cPanel from your Domains.co.za Dashboard
4. Click on Manage Services to view the sub-dropdown menu and select the hosting package for the domain you want to work with – in our example we are using Web Hosting.
5. Click the Manage button to the right of the domain name you want to access.
6. The display will now show Product Information, Quick Manage, Resource Usage and Site Statistics for that domain name.
7. Under Product Information, scroll down to Control Panel, which will display cPanel to the right, and click on the Login button.
8. The cPanel Dashboard will now be displayed.
