How To Backup WordPress Database Using phpMyAdmin?
August 18th, 2015 | by Ravi Chahar || 14 Comments |
Do you know how to backup your WordPress database? I am here to help you. There is a very simple way to backup database.
As you, all know that it’s very important to keep the backup of your database so that if something goes wrong then you can upload your old database again.
Moreover, when you try to transfer your website from one host to another then having the backup of your database is the necessity.
Are You Ready To Have Your WordPress Database Backup?
As I have mentioned above that most of the time you need to have WordPress backup when you transfer your website from one host to another.
And the most important thing is that you should always keep it for hard-time. You can generate the full backup of your website if you have a single website on your host.
When it comes to multiple websites then it’s obvious that there is more than one database. In that case, you need to select one particular database to backup.
You may have created the backup of your website using full backup option. But when we talk about database then you need to select your database. There are some steps you need to follow for the completion of backup.
Step 1 :- First you need to login into cPanel of your Web Hosting.
Step 2 :- Second thing is to search for Databases. In this section, you will see many options including “phpMyAdmin”. You have to open it and a new tab will appear to you.
Step 3 :- You need to look at the left-hand side of the screen where tables are shown. You can see your user name provided by your Web Hosting provider.
Now you need to click on the plus sign of that username and you will see various databases you have for your various domains present at that host. You just need to select the name of the database you want to download.
Step 4 :- After that many tables will appear in front of you. You can see on the upper side there are many options present including “Export, Import, Search”. Now you need to click on the “Export” option.
Step 5 :– This is the final step. In this step you just need to click at “Go” option and your WordPress database download will start and within few minutes, your download will be completed.
Isn’t this easy to backup WordPress database?
Don’t you think its very easy to backup database? The importance of having the backup of your WordPress database should be understood.
You should always keep it on your computer for safety. By following above mentioned steps, there will not any difficulty in doing your job. All you need to follow those steps carefully. If you still face any problem then I am here to help.