5 Different and Free Ways for You to Back Up Your Blog Database

Looking for a simple, stable and significant VPS as your web hosting? Check out DigitalOcean, only $5 per month, and you can get $10 in credit just for signing up now.

How do you back up your WordPress blog database?

The most popular and easiest way for database backup is to use a WordPress plugin, such as WordPress Database Backup, which will let you back up your blog database automatically. Besides WordPress plugins, you can also back up your blog database through other ways. Below are 5 different ways for you to back up your WordPress blog database, they are all FREE and easy, too.

1. Back up your WordPress blog database with cPanel

Login your cPanel (if there is), click the "Backups", if you want to back up all the databases as well as all the files in your server, you can click the button "Download or Generate a Full Web Site Backup". And if you just want to back up a blog database, just turn to the "Partial Backups", select your database and download it to your computer disk.

2. Back up your WordPress blog database with phpMyAdmin

Click and Login your phpMyAdmin, select the blog database that you want to back up, and click Export to download the database. For better performance, you’d better select the"gzipped"compression before you click the button"Go".

3. Back up your WordPress blog database with WordPress itself

Login your WordPress Dashboard, click the “Export” under the “Tools” item, and click the button “Download Export File”, then you will download an XML file, which will contain your posts, pages, comments, custom fields, categories, and tags, just without plugin or widget settings. You can also select to download a particular author’s XML file if your blog has more than one author.

4. Back up your WordPress blog database with WordPress plugins

For most WordPress users, the easiest way to back up blog database is to use a plugin, such as WordPress Database Backup, which will let you schedule the backup time, and send the database backup to your email automatically. Besides Word Press Database Backup, you can also check out other nice WordPress backup plugins.

5. Back up your WordPress blog database with cron jobs

This way may be a little harder than the above four ways. You need to edit a script and upload it to your blog server, and create a cron job, then your blog database will be sent to your email box and saved in your server automatically. The most popular script for database backup is AutoMySQLBackup, and you can check out this tutorial for how to use it to automatically back up your blog database.

But the email attachment function of AutoMySQLBackup is only workable for those servers with Mutt installed. And unfortunately, my blog server does not support mutt, so I use AutoMySQLBackup to save the blog database in the server every time, and meanwhile, I use the plugin WordPress Database Backup to send the database to my email box daily.

How about you? How do you back up your WordPress blog database? Or do you have any other ways to back up a blog database? Share with us by adding a comment.

Spread the love
This entry was posted in Other Free Nuts and tagged , , , , . Bookmark the permalink.