Backup The WordPress Database

How to Backup The WordPress Database?

it’s recommended you should backup your blog database from time to time. If you are not taking backup then one day you can come in a problem.

Thousand of hackers every day are ready to attack your site, they can remove your content or put a virus on your website. It’s also possible, a plugin or update can damage your blog, if that happens with your blog then you can restore your site again using the database backup file.

How Can I Backup The Database

You can backup the database with the following type

  1. Using a plugin
  2. Using
  3. Using phpMyAdmin

Backup using a plugin

You don’t need to do anything just install a WordPress backup plugin and sit back. In my recommendation, “BackUpWordPress” By XIBO Ltd is a free backup plugin with minimum settings. Using this plugin you can also take the backup of code files and images or your WordPress site. After install you can setup by clicking on “Setting” on the “Installed plugin” page or you can open settings using Tools->Backup left menu on any page

BackUpWordPress Wp Plugin

Click on the “+add schedule” button to add an auto or manual backup schedule, select options as you want to set back up and click on the “Done” button.

  • Backup: From drop-down select “Database Only”
  • Schedule: Select “Onse Daily” from available options.
  • Number of backups to store on this server: Ente a number how many latest backups you want to save. In my recommendation, you can enter 3.
  • Email notification: if you want a notification when backup completed then enter your email or leave blank.

Browse Best WordPress Backup plugins

Backup using

Using you can download an auto-generated database backup. From time to time you should download the backup database file and keep on your computer in a safe place, otherwise sever will replace old with the new backup file.

You should keep two-three last backups so if any backup did not work then you can use backups older than current.

Here are the easy steps using that you can download database backup file in cPanel:

Login to cPanel, link and details can be found in a welcome email if you don’t have then contact your support.

cPanel Login

On Dashboard Go to the “File” section and click on the “Backup” option.

Backup using cPanel

On the next page, you will see many backup options go to heading “Download a Backup”. If you have more then one website/blog then under this heading, you will see a list of database backup files to download. Just click on the database name you want to download and your download will start.

Remember
Form time to time download backup.

Backup using phpMyAdmin

If you want 100% accuracy and don’t like to add a plugin then you can download instant database backup through phpMyAdmin. It’s a little difficult but it’s also a better option.

Follow steps to backup using phpMyAdmin

Login to and

On Dashboard Go to the “Database” section and click on the “phpMyAdmin” option.

cPanel Database Section

Now phpMyAdmin will open in two parts, in the left part name of databases will show click on your blog database name.

Don’t know the database name then read
How to find the Database name in WordPress?.

Now all tables under that database will show in the right-side panel.

In top buttons click on the “Export” button.

On the next screen select “Custom”, for display more options.

Now go to “Object creation options” and select “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement” checkbox.

Go to the bottom of the page and click on the ‘Go” button.

Congrulation
You started backup process wait till backup complete and keep this backup safe till you not take backup again.

I recommended you need to take backup once in a day if you are making a lot of changes on your website on a daily basis. If it’s not possible, then at least in a week you should save local backup your WP database.

If you are not updating content on your website then you can backup once in a month. You will say why if nothing updated then what will be new in backup, then the answer is your plugins and WordPress core files update from time to time.

Now you are safe if the problem occurred in the blog, you have the backup to restore your blog.

Don’t know about the restore process then read our guide
How to restore WordPress Database?