Creating regular backups of your WordPress database is undoubtedly the best thing you can do to save yourself from the severity of catastrophic situations, such as: when your website is hacked or you get locked out of your WordPress admin accidentally. If any of such situation happens, you can run your database backup to restore the database to a hack-free and a more recent version.
You can choose to create a backup of your WordPress database manually, or using plugins as you deem perfect. Through this post, I’ll make you aware of both these approaches for creating backup of your WordPress database. But, before getting any further, let us take a look at the WordPress files present in the database that you’ll need to backup:
- All your WordPress posts and pages
- Post-related data present in your site, including meta-descriptions, authors, and categories.
- All of the readers’ comments.
How You Can Backup Your WordPress Database Automatically?
Since most website owners and bloggers are not tech-savvy, they prefer using a WordPress plugin to do the job automatically. Below are 3 of the most popular WordPress database plugins worth a look:
Downloaded over 5 million times, WP-DB-Backup is one of the most sought-after and widely used WordPress backup plugins worth a try. The plugin focuses only on creating a backup of the WordPress website database. It’s an excellent tool for users who don’t have access to phpMyAdmin tool that is required for backing up WordPress database manually.
The plugin makes the process of creating database backups extremely simple and straightforward. It also provides the option to schedule automatic database backups (on hourly, daily, or weekly basis) and even help in restoring the database. You can download this plugin for free from the official WordPress Plugin directory.
The plugin not just help to backup your WordPress site database, but also enables to optimize, restore and delete the backed up database automatically according to the set schedule.
What’s more? WP-DBManager even allows to reduce the size of a WordPress website database, as it helps empty the records of all the tables and even remove the table from the database. The plugin is free to use.
3. WP Database Backup
This is a relatively new and free-to-use WordPress plugin that helps backup your database, but does not help to backup your WordPress files. It even helps restore the backup with just a single click. It automatically creates a backup of the database on a repeating schedule.
This plugin allows to download the backup file directly from your WordPress website admin panel. Most importantly, it helps store the backup on secure storage places like Dropbox, email and FTP.
How to Backup Your WordPress Database Manually?
While using a plugin makes the process of creating a backup of WordPress database easy, but still it is advised that you should know how you create a backup for your WordPress site’s database manually. Here, I’ll let you know two different methods that help in creating WordPress Database Backup without using a plugin.
1. Use MySQL to Create Database Backup
The very first method requires using MySQL to make the backup of the database, using the following steps:
- Access your phpMyAdmin using the login credentials. Once you’ve entered the phpMyAdmin, search for your WordPress Database and select your website database.
- After selecting the database, hit the tab titled as “Export”.
- Next, you’ll have to compress the database files. For this, choose a compression method (preferably gzip), and then click on the “Execute” button.
- Now you’ll be able to see a message inside your browser window, asking you to “Download this file”. Simply, click on the “Yes” option and the backup of your database will be created.]
2. cPanel Backup Method
The second recommended method to make backup of the WordPress database requires using the cPanel. First off, login to your cPanel. After successfully logging into the cPanel screen, click on “Backups”, and from that option, scroll down to the option that says: “Download a MySQL Database Backup”. You just need to click on your website database (the one you want to backup), and finally download the backup.
Rules To Follow When Creating a WordPress Backup:
Irrespective of what backup solution you prefer to use for your WordPress database, make sure to follow the below rules to perform the task efficiently:
- Make sure to backup the database of your WordPress website prior to installing a new upgrade.
- Remember to save your database backups in 3 different forms and/or places (like a DVD, your email account, etc.)
- Often plugins can add bloat to your website database and can exceed the size of database files. Thus, make sure to keep a backup of the most important plugins that are installed on your site.
- Do carry out a manual backup of the database to keep it protected from malicious hacks while using any automated backup solution.
Have you been seeking out ways to backup your WordPress site’s database? Well, then I’ll recommend you to carefully read the methods covered in this post to make the database backup to do your job efficiently. Also, be sure about following the rules before getting started with the process of backing up your website database.
Author Biography: Samuel Dawson is a instinct expert in Designs2html Ltd with a great passion to work on consistent methodologies of web design and development. He is able to convert html to wordpress in a creative manner. Samuel has shared a great article above on how a database of a WordPress can backed up.