How-to Guides Backups & maintenance
Use a logical SQL backup and validate the restore before switching your website over.
- Identify a backup from before the incident. cPanel → Backup Wizard can restore a MySQL database from a supported partial backup. If you have an export in SQL format and want an isolated test restore, create an empty database and open it in phpMyAdmin.
- Back up the live database first. Import the dump into your intended destination and check the import result. If you only have a full account or raw MySQL directory archive, ask the provider which supported restore workflow applies.
- Review tables and a sample of important data, then test using a staging copy where possible. Switch the application to the restored database during a coordinated window and keep the previous database available for recovery.
