.png&w=3840&q=75)
Websites & Hosting4 min
How to Restore a MySQL Database from a cPanel Backup
NS
NameSilo Staff8/26/2026
Share
To restore a MySQL database from a backup, log into cPanel and navigate to the Backup tool to use the built-in database restore feature. Alternatively, open phpMyAdmin, select the corrupted database, drop the existing tables, click the Import tab, and upload your clean .sql backup file to execute the restoration.
What Is an SQL Database Dump?
A .sql file, often called a database dump, is a plain-text script containing every command needed to recreate your database from scratch: table structures, column definitions, and every row of data, all expressed as executable SQL statements.
Restoring isn't copying a file. It's running that script against your database server, which rebuilds every table and repopulates every row exactly as it existed at the moment the backup was created.
Why It Matters: Instant Disaster Recovery
A bad plugin update, a destructive query run by accident, or a failed migration can leave a WordPress site completely broken in seconds. Waiting on a support ticket queue to fix it can mean hours of downtime.
Knowing how to restore a database yourself turns a potential multi-hour outage into a five-minute fix, reverting the entire site to its last known-good state without depending on anyone else's schedule.
Method 1: The Automated cPanel Route
Step 1: Log into cPanel and locate the Backup section.
Step 2: Under "Restore a MySQL Database Backup," click Choose File and select your backup archive.
Step 3: Click Upload. cPanel handles the restoration process automatically, including table recreation.
This route works well for a full, straightforward restore when you have a proper cPanel-generated backup archive on hand.
Method 2: The Manual phpMyAdmin Route
Step 1: Open phpMyAdmin from the Databases section of cPanel.
Step 2: Select the corrupted database from the left-hand panel.
Step 3: Drop the existing tables first. Select all tables, choose "Drop" from the action menu, and confirm. This step is not optional; skipping it causes the import to fail.
Step 4: Click the Import tab.
Step 5: Click Choose File, select your .sql backup, confirm the format is set to SQL, and click Go.
Note on file size: phpMyAdmin's browser upload limit is typically 50MB. Larger backup files will time out or fail through the web interface and need to be imported via SSH instead.
Common Mistakes
Skipping the "Drop" step before importing: This is the single most common restoration failure. Your backup file contains CREATE TABLE statements for tables that already exist in the corrupted database. Without dropping them first, phpMyAdmin returns a "Table already exists" error and the import halts, leaving you with a mix of old corrupted data and a failed import instead of a clean restoration.
Assuming import always merges data safely: Importing over existing tables doesn't blend old and new data. It either fails outright on the table conflict, or in some configurations, duplicates rows and breaks primary key constraints.
Not verifying the database exists first: phpMyAdmin imports into an existing database; it cannot create one from the Import tab itself. Create the target database via the MySQL Database Wizard first if it doesn't already exist.
What This Means for You
NameSilo Hosting includes full cPanel and phpMyAdmin access for exactly this kind of manual database recovery. Since maintaining your own current backups is essential for fast recovery, consider a scheduled export routine or a WordPress backup plugin to keep a clean .sql file ready before you ever need it. Need a fresh domain for a rebuild? Search available names.
Frequently Asked Questions
How do I restore a database in cPanel?
Use the Backup section's restore tool, or import manually via phpMyAdmin.
What is a .sql file?
A text file containing SQL commands to recreate a database's structure and data.
How do I import a database in phpMyAdmin?
Select the database, click Import, choose your file, and click Go.
Should I drop tables before importing a database?
Yes, always. Skipping this causes table conflict errors during import.
How do I fix a corrupted WordPress database?
Drop the corrupted tables, then import a clean .sql backup via phpMyAdmin.
What happens if a database import times out?
Large files exceeding the browser upload limit require SSH import instead.
Can I restore just one table in MySQL?
Yes, if your backup file is structured per table or edited to isolate it.
Does NameSilo hosting perform automatic backups?
Maintain your own backups via a plugin or scheduled export for reliable recovery.
.png&w=2048&q=75)
NameSilo StaffThe NameSilo staff of writers worked together on this post. It was a combination of efforts from our passionate writers that produce content to educate and provide insights for all our readers.
More articleswritten by NameSilo
.png&w=3840&q=75)