This tutorial will teach you multiple and simple ways to backup your WordPress Database.
There are many reasons why it is important to make regular backups of your WordPress Database. For starters, the WordPress publishing platform is regularly updated and sometimes something on your WordPress site such as a plugin might not be compatible with the latest update which puts your site in danger of being wiped out or going offline. Essentially you always want to have a recent back up of your site in the case that something goes wrong or you experience an hacking attempt.
Ways To Backup WordPress Database –
There are many ways to do this including using a plugin, creating a backup through your cpanel, or manually using the PHPmyadmin.
How to Backup your WordPress Database with CPanel
- With this method, the first step is to login to your CPanel admin provided by your Hosting company. You can typically find your Cpanel login in your welcome email from your Host.
- Once logged into your CPanel, you will click on the Backup icon in the Files area.
- Then click on the WordPress database name – it will be listed under the section of ‘Download a MySQL Database backup’.
- Following that, a compressed SQL script file will be created and should download automatically to your computer.
How to Backup WordPress database using phpMyAdmin
The phpMyAdmin offers you a way to manually back up your WordPress database. The easiest way to access your phpMyAdmin is from the Databases area through your CPanel provided to you by your hosting company. The steps to backup your WordPress database from the phpMyAdmin are listed below.
- Log in to your Cpanel. You will find phpMyAdmin located under your Database tools. Click on phpMyAdmin.
- Once logged into your phpMyAdmin admin panel, click on the databases tab to see a list of the tables your database contains.
- Now select all the tables you want to back up and then click on Export (you can use the Quick export or Custom export) to export and backup the WordPress database to a file. You should set the format to SQL, and click the Go button.
And that’s it. You now have a full backup of your WordPress database that will come in handy should your site ever experience an emergency.
How Backup WordPress Database using a Plugin
Backing up through a Plugin is the preferred method for many WordPress users, especially beginners who might not be as comfortable or experienced with using the Cpanel. The UpDraftPlus Plugin is arguably the number one WordPress plugin for backing up your database in 2017, so we will be using this as our example today. You can check out our earlier tutorial on how to install WordPress plugins in case you’re new to all this.
Install the Plugin:
- The first step is to install the UpDraftPlus plugin by logging into your WordPress Dashboard, navigating to Plugins on the left sidebar, and then clicking the Add New button. Add New.
- Using the search bar on the top right, search for UpDraftPlus, then click on Install Now, and Activate.
Manually Backup Your Database:
UpDraftPlus offers you a number of different ways to back up your WP database. These ways including the ability to back up locally on your server, to your computer, or to a cloud storage such as Google Drive, Microsoft Onedrive, DropBox or even your email.
The simplest way is to create a backup and save it to your computer. The step by step method for that is below.
1. First click the “Backup Now” button on the UpdraftPlus dashboard.
3. The backup begins. Upon completion, you should click on the “Existing Backups” tab, to download the backup to your computer from there.
To Schedule Backups
UpDraftPlus also gives the option to have regular automatic backups by simply scheduling it. To schedule your backups, visit Settings, UpdraftPlus Backups to select a backup schedule for both your files and database.
A good setting for your files is ‘Fortnightly’ while ‘Weekly’ is recommended for your database. These settings however depend on how often you update your content. For example, if you publish stories daily, you can change your files backup schedule to ‘Daily’. Lastly, you then select the location of our remote storage, and you are able to pick more than one storage location.