how to automate database backup in wordpress

WordPress database is file stored on your hosting server that is updated or add content to your site.   The images,  media are important as well and the database contains the core of your content and website setup.   To backup your media files you can go into cPanel and do backup at any time..   The easiest way to backup your database file on schedule is to use called WP Database Backup..   The plugin will compile your database and store it on your server.   For extra level of backup you should download the file and store it onto your computer...   To automate this process, click on Scheduler tab and tick Enable box and choose 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 totally reliable backup..   You can also do full file and backup using cPanel..   Now that you know how to automate WordPress, you can move on to something really important like getting your blog rocking, or improving your security...   Read more