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?
cPanel is a popular control panel used by many web hosts. The backup feature can be used to backup your MySQL database.And it is important to restore wordpress database.
The following instructions will replace your current database with the backup, reverting your database to the state it was in when you backed up.
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?
Restore wordpress database Process :
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:
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
Difficulty level [Easy, Medium, Hard].
Easy
Total time Consumed.
20min
Related Plugins
No
Summary
Article Name
How to restore wordpress database?
Description
cPanel is a popular control panel used by many web hosts. The backup feature can be used to backup your MySQL database.
Author
Abigail
Publisher Name
WordPress Support
