Backing up your database is a hassle, but necessary in case a hacker, you or your web hosting companies accidental deletes or breaks your database. Well, there is a plug-in for WordPress which makes it a lot easier to backup your WordPress with a click of a button. You can also set WordPress to send you a zip file with your database file in it.
I have been using WP-DB-Backup for a few months for backing up my core WordPress tables like Posts, links, tags, categories, pages, user names, etc and WordPress Plugin tables like Broken link checker, popular posts, etc.
It is very easy to use. You just have to install WP-DB Backup plug-in, and press the backup button to save my WordPress Database to my computer or e-mail it to my e-mail’s inbox.
To use it, you go to the Tools section in your WordPress Dashboard. In the Tools heading, you click the Backup sub heading which appears after you installed the plug-in.
You have the option of backing up the core tables for WordPress like comments, links, options, postmeta, posts, term relationships, wp term taxonomy, wp terms, wp usermeta, wp users, and can also include tables for your plug-ins like SABRE, Scaptcha, etc.
If you need to make a backup of your database manually, you have the option of saving your database to your web server folder in wp-content/backup folder, download to your computer, or e-mail the database as an attachment to your e-mail address. The databases are also automatically Gziped to help you download your database faster and to save space on your computer and e-mail inbox storage space since databases can be 100-1000 MBs in size on a very big blog.
You can also schedule automatic back ups of your database file and send it to your e-mail as a Gzip attachment to never, once hourly, twice daily, once daily, once weekly.
If you get a lot of comments per day and write a lot of post, I recommend setting automatic back ups to once hourly, twice daily, or once daily.
If you rarely write new content or get many comments, once weekly or never “with manual backups” would be the best option.
If you choose to do automatic e-mail back ups make sure to keep the e-mail address a secret, and that no spyware, or malware is on your computer since if someone hacks your e-mail or computer they can steal your database which has your WordPress admin user name and password on it, so they can hack your blog very easily unless you password protect your WP-Admin folder in your web hosting control panel with a different user name and password then your default user password.
I also recommend learning how to export and import your wordpress database in Phpmyadmin, so if you can’t log into your WordPress Admin account, you can still backup your database in Phpmyadmin which is usually found in your web hosting control panel.
It is also important to use FileZilla or some other FTP client to backup your WordPress Blog folder on your web server. To reconnect your database, all you do is edit your WP-config.php file to the new database address, user name, and password.
The Simplest way to Backup all your post, pages, comments, custom fields, categories, and tags is in WordPress is with the Export and import tools in WordPress Dashboard Tools.