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 :
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 .
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 .
Step 4 :
After Clicking the Go button , The downloading of database will start .