[How To] Take MySQL Database Backup Of WordPress Blog Using phpmyadmin

MySQL Database Backup is really a important Step to execute daily in a Blog’s as well as Blogger’s Life as MySQL Database contains all the information of Blog related to plugins , theme settings , content of posts , pages along with Blog’s Settings .  So , WordPress Blog stores its each and every information in the MySQL database which looks like abc.sql where abc is any name and .sql is the extension .

From the above introduction , it is completely clear that if any person losses his Database by any chance , his / her WordPress Blog will be shattered . So having the backup of MySQL database is must for every Blogger . Though there are many plugins , which can backup MySQL Database of your Blog that too automatically with ease but sometimes , it becomes necessary to have a manual backup once in a while via phpmyadmin .


What made me write this blog post is the Serious trouble I had and i wish , my fellow readers and friends who do Blogging must not face the same . I usually take a daily backup of MySQL database of my Blog via using WordPress Plugin so as to preserve My Blog as well as my hard work if by any chance , My Blog gets into trouble either due to my hackers or my own experiments which i tend to do every now or then .

My Blog was doing Good as usual and everything worked well until all of a sudden my friend ignorantly deleted everything on my server while doing some other installations . I was panicked about what to do to save my Blog . All I had was Database with me which somewhat relieved me that My Blog’s content was still secure and I could get my images from Google . But the real problem started when my Database was not getting restored or should I Say i Was reluctant to admit that My Database was corrupted . I checked almost my entire month’s database backup, and all I could get was a Corrupted MySQL Database again and again .

Though , somehow I managed to get my Blog live out of that corrupted Database after those 5 dreadful days for which my Blog remained Dead . I have now made a particular habbit of having Mysql database backup once in a week manually . I strongly suggest you to do the same atleast once in every 15 days so that if you are proned to Hackers or face any problem like i Had due to any of your experiments , You should not face such problem .

Steps For MySQL Databse Backup using Phpmyadmin

Step 1 :

Login in Your Cpanel and Click on phpmyadmin . Then You need to select the Particular Database corresponding to your WordPress Blog from left . Like in my case , I have only Database as “test” .select mysql database

Step 2 :

After Selecting the particular Database (in case if you have many Databases) , you will have to click on export like shown below . By default , all the tables will be selected already . In case , they are not , just click on Select all option .

export mysql database

Step 3 :

Now is the time to take back up . Just select in what mode you want to have back up at the end of the page i.e simple sql file , or zipped (compressed) or gzip file of the database . In my case , I always select gzipped option as it saves me from downloading large sized database by compressing it to maximum value . Then Click on Go button which lies to the extreme right at the end of page .

gzip mysql gzip the database

 
 
 
 
 

Step 4 :

After Clicking the Go button , The downloading of database will start .

download mysql database

14 thoughts on “[How To] Take MySQL Database Backup Of WordPress Blog Using phpmyadmin

  1. Deepak

    I knew about the back up done from wordpress and Cpanel but was unknown about this type of back up, thanks for this information.

    Reply
  2. Navneet Singh

    Good post i don’t know this, is there any way i can frequently download database.sql in some interval without opening phpmyadmin ???

    I using currently using WordPress DB plugin.

    Reply
    1. Amandeep Singh Nagpal Post author

      No . For such manual back up , you need to go to phpmyadmin .. Auto backups via plugin help but still I Would suggest you to have manual back up once in a while . 🙂

      Reply
  3. Vinod Kumar

    Thanks for the tutorial mate.Very well written.
    Just one question how would be restore the site using this backup?
    We we would need to change the db username/pass somewhere right?

    Reply
    1. Amandeep Singh Nagpal Post author

      Once the back up is made , you do not need user and password to restore the site . Just create a dummy database and import your backed up database there .

      Reply
  4. Sanjeev

    Backup database via Phpmyadmin really a easy way. I don’t know about it before, thanks for sharing this easy way.

    Reply
  5. Technology Updates

    Recently i just transferred my blog, but i was not knowing exactly how to do and i just lost every pictures. By this its Extremely affected to my blog.
    Nice way to take back Amandeep.
    Thank you.

    Reply

Leave a Reply

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