If you have a database backup as a .sql (or compressed) file, restore it through phpMyAdmin:
- In cPanel's MySQL Databases, create an empty database (or use the existing one if you want to overwrite it).
- Open phpMyAdmin and select that database in the left sidebar.
- Click the Import tab, choose your backup file, and click Go.
If importing into an existing database, drop its old tables first to avoid duplicate errors. You can also use cPanel Backup Wizard > Restore > MySQL Database for a backup made there. After restoring, confirm your app's config still points to the right database name and user. Large files? See our large-database guide or open a ticket.
