Most of webmaster uses WordPress as their blogging platform and host their blog using it. As a security measure you may need to take backups of your MySQL database of your blog. We will consider wpdatabase as name of database for our Wordpress blog. Just follow the steps and you can take backup and can restore your MySQL database easily.
Backup Procedure :
mysqldump –opt wpdatabase | gzip -9 > wpdatabase.sql.gz
Restore procedure :
gunzip wpdatabase.sql.gz
mysql -u rootusername -p **** wpdatabase < wpdatabase.sql
That’s all you have secure your wordpress databases by having its backup copy which you can restore it later using above restore command.
You can use a ready made plugin from wordpress if you want to go with easy way 
Posted under Technology Updates
This post was written by admin on May 14, 2009
