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.
Related free web apps:
To back up your WordPress blog database with cPanel much more easily I suggest using backupsmart because it is fully automated, easy and much more effective for your website backup than doing it manually
- spam
- offensive
- disagree
- off topic
Like