Your database contains all your important information if the database is erased or corrupted you lose everything.
Sometimes accident can happen when we least expert it. If you can have made a careless mistake and your database is gone how can you restore your data in your database?
So Backup your database regularly.
If you are use WordPress so you can use backup plugins for take database backup.
WP-Database-Backup :When plugin is installed and active. you can backup your blog database easily in single click. Some time you have create database backup on your server or localhost and if some one hack your site or you have made some mistake then how can you recover your database which include important information. So it is important to save your database safer place like FTP, on your Email or Dropbox.
We have added new feature in WP Database backup which store your database backup on safer places like FTP, Email, Dropbox. Also you get email after successfully database backup created.
WP Database Backup menu will appear in Dashboard->Tool->WP-DB-Backup.
Manual backups may be performed by clicking the ‘Create New Database Backup’ button which can be found in the backups section of WP Database Backup. That’s it really, just click the button and let WP Database Backup create database backup easily on single click.
1) Click on Create New Database Backup
That’s it! Do this once a month, week or even daily. You can store as many archives as desired on their hosting provider’s server, however, we recommend doing some cleanup once in a while.
Add your email address to the status updates option and WP Database Backup will send you a status email when your backup is done.
All your backup archives should be downloaded and stored somewhere safe. The Backups section of the plugin displays a list of all your backups. Clicking the download link will save it to your desktop.
We recommend doing this for every backup and saving it somewhere safe like Dropbox or google drive.
Cleanup Your Server
While you may leave as many backups as you want on your hosting provider’s server, we recommend that you do some cleanup every once in a while. Some hosts have very limiting disk quotas so saving a lot of backups will use up your limited space.
Why not use the WP Database Backup retention setting to tell WP ALL Backup how many backups you would like to be on your host. Once you set it WP Database Backup will handle the cleanup for you or you can delete backup manually on click ‘remove’ button.
Don’t want to even click the button; we feel the same way. Create scheduled backups for your site from with WP Database Backup scheduled backups. Backups may be performed daily or weekly. Simply select the setting you would like backups to be performed.WP Database Backup will perform your backups on the days you requested and will even send you an email(set Email Notification) to let you know it has been completed. No need to even think about it anymore.
When using automated backups, we recommend also setting the number of archives to be stored on server.
Go to Dashboard->Tool->WP-DB-Backup->Schedule Settings in the admin dashboard. Select Auto Backup Frequency.
You’ll also be able to schedule regular backups so they run automatically without any extra configuration on your part.