How To Backup WordPress Database Using phpMyAdmin?

backup database

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.

backup mysql database

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.

wordpress database

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.

backup database

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.

by Ravi Chahar

A WordPress Professional, web developer and designer who intends to guide his readers about WordPress, Blogging, Web Development, Web Design and more. I have expertise in WordPress theme development and customization. I can set up and redesign the Thesis themes. I have been working in this field for years now.

14 comments

  1. This is a very lovely and comprehensive tutorial Ravi,
    Every bloggers knows how important it is to be backing up a blog especially one whose blog has been hacked before like myself.

    Backing up through phpmyadmin is also one of the best and simple means of doing it and that’s exactly the way i usually back up mine.

    Thanks for sharing Ravi.

    1. Hi Theodore,

      I am glad to know that you liked this post. You said it right then people need to have backup. Who knows the future. Hard time may come and may become worse. Its always good to backup your database.
      Thanks for stopping by.

      Have a great day.
      ~Ravi

    1. Hey Donna,

      I am happy to see you at my blog again.:)

      There is nothing difficult. All you need to follow some simple steps. Having the backup of your database is very important. As you have said that you have broken your blog once. At that time these backups will help you to restore your blog again.
      When we talk about database then using your cPanel is the one thing to learn about.
      Thanks for your input.

      Have a nice week ahead.:)
      ~Ravi

  2. Hey Ravi,

    Is it really that simple? That’s the question many people will ask after reading this post. The most important thing is having an backup just in case your site gets hacked or when you change hosts like you mentioned. You always want to have some to go back to on those rainy days!

    Thanks Ravi for sharing! Have a great weekend!
    Sherman Smith recently posted…My Top 6 Posts For The Months Of July And AugustMy Profile

    1. Hey Sherman,

      Most of people ask these type of simple questions. Newbies should know how to backup the database of their website. Its always good to have one safe side. Many people are afraid of using cPanel. They shouldn’t so that. At least they can try it. The steps i have described are easy to follow and anyone can backup their database.

      Thanks for stopping by.
      You too enjoy your weekend.:)
      ~Ravi

  3. Hi Ravi,

    Thanks for sharing this tips. I am new and not aware of phpmyadmin, I want to update wordpress 4.3 is there any way to take data backup with wordpress only. Can i export my all pages and content directly from wordpress

    Please help with this if you are aware of it. Thanks in Advance and Happy Weekend
    Anant Patel recently posted…How to Convert Outlook 2013 OST To PST?My Profile

    1. Hey Anant,

      Welcome to my blog.:)
      You can update WordPress into the latest version. Nothing wrong with that. Don’t worry about your database. But if you still want to backup your database then there are many free plugins like WP Database Backup, WP-DB-Backup, WP-DBManager and many more. If you want to go for premium plugins then you can use BackupBuddy.
      But I always prefer to use cPanel because of accuracy.

      Thanks for stopping by.
      Hope to see you again.
      ~Ravi

  4. Hey Ravi,

    I agree, I had my blog for over two months before I realised how to back up my computer. I am always wanting to follow the rules because if something goes wrong I turn into a mess. Then I got some advice on how to do it, reading another post. But that was a different process to yours, so I will do my back up with my web host. I like the idea of having more than one copy somewhere. Not sure if I would know what to do if I needed it, but would wait until that happens. Thanks for this informative post.

    Rachel.

    1. Hello Rachel,

      Welcome to my blog.:)
      I am happy to see you here.
      There are many ways to backup your website and database of your website. You can use plugins for having backup of your database in your computer. But if you are not afraid of using cPanel then its the best method to follow. There are many newbies in the blogosphere who don’t go through these type of technical methods. But I recommend you to start using cPanel.
      Yeah, its always good to have more than one copy of backup. Don’t worry it takes only one minute to backup the database.

      Thanks for stopping by.
      Hope to hear from you soon.:)
      ~Ravi

  5. Hi Ravi

    Reminders are a great thing. There are so many ways to backup a database and you have showed us a method using Phpmyadmin. Love the images.

    Thanks for sharing.

    1. Hey Ikechi,

      You are right. Bloggers should keep these things in their mind so that they can check their blog database in time. Having a a backup is always good. There are many plugins but using PhpMyAdmin is quite simple and effective.
      Thanks for stopping by.
      Enjoy your day.
      ~Ravi

  6. Nice Tutorial Ravi. Been using phpMyAdmin for so long, it’s the only program I use to import and expert my databases.

    One thing I do, is click the “custom” box so I can name the import-export SQL how I want. Makes it easier to remember what it was for later. Something like that 🙂

    The compression settings also come in handy when your database gets to large, as phpMyAdmin has import limits.

    1. Hey Ron,

      It’s the matter of choice. There are many people who use FTP for database import and export. But other use phpMyAdmin. I have met many newbies who are afraid of these techie things. Whenever it comes about cPanel, they get scared.

      Using phpMyAdmin is the best way for creating a database so that you can import your old database into that. I am sure it is fun to use such techie things.

      Thanks for your comment.
      Have a great week ahead.
      ~Ravi

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge