Database Backups

Having a recent database backup is one of the most recommended things to take care of when managing a WordPress based website.

Given the fact that the WordPress platform is so large and flexible, at some points some things can go wrong and break your database, thus breaking your website.

Luckily, there are a lot of tools to help you have the most recent working database backup at all times.

Hosting Backups

Most hosting providers back up your website regularly, both the website files and database.

As an example, we will show how to access recent database backups in a SiteGround hosting account.

WordPress Plugins

There are a great number of WordPress plugins that provide the options of making full website backups from time to time (once a week for example) and send these backups via a DropBox link to your email or another location of your own choice.

UpdraftPlus WordPress Backup

One of the highest rated back up plugins on WordPress.org UpdraftPlus WordPress Backup is a powerful tool. Its free to use, and you can back up your entire site to the cloud (Amazon S3, Dropbox, Google Drive, FTP, Email and various other options). Using this plugin will allow you to restore your site in a single click, you can schedule back ups, and even split larger sites into multiple archives. Packed full of features, and with ease of use I would highly recommend this plugin.

Just make sure that you’re not running your back ups too often, especially on shared hosting, as this may use up your data allocation.

If you don’t have your own cloud storage options, or want premium support with the plugin, you can upgrade to UpdraftPlus Premium, this will store all of your backups on their own cloud service.

BlogVault

BlogVault is simple to use, its safe, and it makes backing up your site painless. To make a back up of your site you should first sign up for a BlogVault account, then you can download and install the plugin (they also offer to do this for you). As soon as the plugin is activated it will make a back up of your entire site, thats the database and files. The plugin will then make regular back ups of your site, and it only backs up new site information daily. You can then revert back to any previous version in the last 60 days. You can also download a full back up of your site to your computer, or use the featured to migrate a site to a new domain or hosting.

BlogVault also has a really unique feature called “Test Restore” which allows you to check the back up version before you go live with it. You can simply choose an old back up version, temporarily restore it on BlogVaults test servers, and review it before pushing it live on your own.

BlogVaults pricing starts from $9.00 a month or $89.00 for the year for single site.

VaultPress

VaultPress was founded by Matt Mullenweg, one of the co-founders of WordPress, and developed by his team at Automattic. Its a great way to keep your site secure, with regular malware checks, daily back ups, automated restores and a 30 day back up archive its a great tool. Much like BlogVault you can also use the plugin to migrate your site from one hosting to another.

Another added bonus with VaultPress is the built in spam protection it offers with integrated Askimet, so you can be sure to prevent spam attacks on your site. Once you get this plugin set up it should be nothing but plain sailing for you.

VaultPress plans starts from $9.00 a month or $99.00 for the year for single site.

BackWPup

BackWPup is a free plug-in that allows you to create a full back up on the cloud for your site (Dropbox, FTP, Amazon S3). With a single backup zip file you can easily restore your site. See the following article on how to create a free back up here.

With BackWPup, you can back up your database and export WordPress XML. Another good feature of this free WordPress backup plugin is you can check, repair and optimize your WordPress database easily.

There is a BackWPup Pro version available for more comprehensive cover starting from $75 for the year, with a $45 yearly renewal fee.

Manual Database Backup

Backing up your WordPress Database

  • Find your phpMyAdmin option, its generally located in “database tools”.
  • You should then be in your phpMyAdmin admin panel, on the right select the database you want to backup. In order to find the correct Data base, it is necessary to check the wp-config.php file: wp-config-editthen open it and find the line  that starts with “define(‘DB_NAME’ ”
    wp-confid-db-name
  • Now that you know the Database name, you can click on it in phpMyAdmin and export it:
    exp
  • Finally you’ll get to the export page, you’ll want to use the quick export method, and then simply hit go:
    export

Thats it! You’ve now successfully completed a full back up of your site.