This article helps you to understand how to restore wordpress database.
This article consists of following things:
- Why I need so?
- How can do it myself without impacting websites?
- Difficulty level [Easy, Medium, Hard].
- Total time consumed.
Why I need so?
The following instructions will replace your current database with the backup, reverting your database to the state it was in when you backed up.
How can do it myself without impacting websites?
Using phpMyAdmin :
Login to phpMyAdminand show the phpMyadmin
Search to browser url/cpanel as show picture
After then show this picture and click to phpMyAdmin
show this picture:
Click to wp(means database name) option after then show all table wp.
Click to Export button and select sql and click to goi button
Show data base table export file
And follow step by step:
Click to wp database
After then click to start export
All database export your site.Next step: Import database
Choose download export file then click to start import
Import file successfully now complete backup site