Easy steps – Backup Database phpMyAdmin – Backup MySQL phpMyAdmin – Backup MySQL Database

by $ivateja (223) on August 8, 2009 | Leave a Comment | 1,969 views

Hear is the easy steps for backup your wordpress database through phpMyAdmin manuvally, It is very important to do backup of your MySql database, A lot of web applications use MySql for storing the content. When you have all your content as html files on your web server it is very easy to keep them safe from crashes, you just have a copy of them on your own PC and then upload them again after the web server is restored after the crash. All the content in the MySql database must also be backed up. A lot of web service providers say they do backup of all the files, but you should never blindly trust them. If you have spent a lot of time making the content and it is only stored in the Mysql server, you will feel very bad if it gets lost for ever. Backing it up once every month or so makes sure you never loose too much of your work in case of a server crash, and it will make you sleep better at night. It is easy and fast, so there is no reason for not doing it.

Steps for Backup of Mysql database:

Open phpMyAdmin
Now you are in a position to view all your wordpress database tables
Click Export button in the Menu at top for getting the database backup file

[ Click on the image for Original size ]
Make sure that select all the database tables once,
now follow the instructions as shown in the picture i gave hear

[ Click on the image for Original size ]