How to Restore your WordPress Database
The easy and secure way, using phpMyAdmin. A good backup copy of your database can be Restored simply, even if your current database has been corrupted!
Required for phpMyAdmin Restore of WordPress database
- Hosting Control Panel access, like cPanel or Plesk, including username and password – obtained from hosting admin.
- Backup of WordPress Database Zip file
Always have a Backup!
How to backup? Click the link below
Once you have a backup Zip file of your database, and access to your hosting Control Panel – ready to go!
Using phpMyAdmin to Restore WordPress Database
- Go Login to your Control Panel
- Scroll menus for a reference to Databases – Click on phpMyAdmin link
- phpMyAdmin homepage – Top left corner shows Database names, WordPress Database ends in “_wrdp1″ or similar. Click on the database name you would like to Restore to, see picture below. If there is no database intact, Create one, or Install WordPress, then return. Click on the database name you would like to Restore to.
The next screen appears, showing current database with tables revealed.
On the same page, Scroll down
Click Check All to select all tables – these will be trashed, to make way for the backup, which will slide into an empty database!
Select [Drop] to drop all the tables – When prompted, Click YES to complete.
You will now have an empty database called whatever_wrdp1
Click Import on the top menu, to upload your WordPress Database Backup
The Import screen shows next
Click [Browse] button to Select your backup Zip file on your computer.
Click [Go] button to upload – Restore your good database.
You are done. Congratulations, your WordPress Database is Restored!
Restoring Your Database From Backup – WordPress Codex