Backup, Restore WordPress blog using WP-DBManager plugin

WordPress is the best blogging software if you have a web hosting account. Using WordPress it is easy for anybody to create blog posts or even individual pages. All text contents, formatting etc are stored in a MySQL database. When the MySQL database is saved to your computer you can be confident that you have a backup of your entire WordPress blog. Using this MySQL database all the blog contents can be recovered if there is a server crash say for example.

WordPress does not have a built in mechanism to backup and restore MySQL databases. You have to login to phpMyAdmin to do anything with your MySQL databases. Some bloggers find it confusing to backup or restore database from phpMyAdmin.

There is a WordPress plugin called WP-DBManager. This plugin is for anybody who wants to take safe backups as well as restore MySQL database from within the WordPress admin interface. Forget about logging into phpMyAdmin. The WP-DBManager plugin takes MySQL database backups once every day / week / month set by you. The database is sent to your email address automatically. The plugin also keeps 10 previously saved database on the server for your convenience. The most useful feature of this plugin is you can restore the database to get back all your blog posts online. The plugin also optimizes the database for smooth working. MySQL database is saved either in gzip format or as plain sql.

WordPress developers could integrate this plugin functionality as a built in feature. This would be useful for novice bloggers.

WP-DBManager plugin | Lesterchan’s useful wp plugins

Also refer

Backing Up Your Database (WordPress Codex)

Restoring Your Database From Backup (WordPress Codex)

(using phpMyAdmin)