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 ]
Restoring a backup of a MySql database :
- To restore a database, you click the SQL tab.
- On the “SQL”-page , unclick the show query here again.
- Browse to your backup of the database.
- Click Go.
- You done !
[ Click on the image for Original size ]
