That’s great you have a backup to restore the WordPress database and live again your blog. I used “That’s great” because you are on some serious owners they backup their blog database from time to time. Most of the bloggers and website owners never take a backup of their database.
If you are on this page by accident and not taking your database backup then start form today, So that you don’t have to regret in the future if you lose your blog content for any reason. Don’t know how then read our guide “How to Backup The WordPress Database?“
Restore WordPress Database Using phpMyAdmin
Do you you have a backup SQL file then you can easily restore WordPress Database using phpMyAdmin, if you don’t have then try to get a backup file from server auto backups read “Backup using cPanel“
Follow these steps to restore using phpMyAdmin
Login to cPanel, cPanel link and details can be found in a welcome email if you don’t have then contact your hosting provider support.
On Dashboard Go to the “Database” section and click on the “phpMyAdmin” option.
Now phpMyAdmin will open in two parts, in the left part name of databases will show click on your blog database name.
Don’t know the database name then read
How to find the Database name in WordPress?
Now all tables under that database will show in the right-side panel.
In the top menu, click on the “Import” button.
On the next screen select SQL file from your computer using the “Browse” field.
Scroll to the bottom of the page and click on the ‘Go” button.
Now restore the database process will start, Did you seen a success message?
Yes
Congrulation! The database restored successfully.
No, problem to restore and showing error message then your SQL backup file is corrupt. You will see the exact error in phpMyAdmin, read the error carefully and try with any other backup SQL file if you have.