Hosting. Domains. Your next step online.

Restore a single MySQL database safely

How-to Guides Backups & maintenance

Use a logical SQL backup and validate the restore before switching your website over.

  1. 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.
  2. 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.
  3. 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.

Read the cPanel documentation