Exporting MySQL DB to a sql file is usual procedure for PHP Developers and can be done with many methods. I like to use Cron Jobs. That is simple and also automatic. Just create a file with your commands to backup MySQL DB and then run it with Cron Jobs.

1. Create a folder with name backup and a file like my_backup_1d.sh in it, and then add this command to it:

#!/bin/bash\

/usr/bin/mysqldump --user=USERNAME --password=PASSWORD --host=localhost DBNAME > /home/domainfoldername/public_html/backup/db_1d_backup.sql

2. Go to cPanel and then Cron Jobs. Add a One Day time interval command like this (>/dev/null 2>&1 used for prevent Emailing from Cron Jobs):

/bin/sh /home/domainfoldername/public_html/backup/my_backup_1d.sh >/dev/null 2>&1

3. Just wait for 12:00 AM (Server Time not Local Time) and check backup folder.