This will show you how to automate database backup in WordPress as easily as possible.
But first, what is the database?
The WordPress database is a file stored on your hosting server that is dynamically updated whenever you edit any of your settings, or add content to your site. It’s a big part of how the magic of WordPress is done.
As such it is the most important file that needs to be backed up on a regular basis. The images, media are important as well but the database contains the core of your content and website setup. To backup your media files you can go into cPanel and do a manual backup at any time.
How To Automate Database Backup in WordPress
The easiest way to backup your database file on a schedule is to use a plugin called WP Database Backup.
Once the plugin is activated, navigate to Tools >> WP-DB-Backup.
Click on the Create New Database Backup button.
The plugin will compile your database and store it on your server. For an extra level of backup you should immediately download the file and store it onto your computer.
To automate this process, click on the Scheduler tab and tick the Enable box and choose a frequency that matches how often you tend to update the content or settings on your site.
Again you will still need to login occasionally and download the latest set of files to your computer to have a totally reliable backup.
You can read detailed documentation for the WP DB Backup plugin here.
You can also do a full file and database backup using cPanel.