it’s recommended you should backup your WordPress 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 WordPress 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 WordPress Database
You can backup the database with the following type
- Using a plugin
- Using cPanel
- 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
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.
Backup using cPanel
Using cPanel 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:
On Dashboard Go to the “File” section and click on the “Backup” option.
On the next page, you will see many backup options go to heading “Download a MySQL Database 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.
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 cPanel and
On Dashboard Go to the “Database” section and click on the “phpMyAdmin” option.
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.
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?