Backup Your Hosting Database Via Cron Job

Get Your Database Hosting Address , Name , Username and Password

mysqldump command is used for dumping a mysql database.

Set up a cron job with this command as follows,

Please change required parameter with your own.

Syntax:

mysqldump -h (hostname) -u (user-name) -–password=(password) (database-name) > (full path of backup file)

Example:

mysqldump -h p45mysql7.secureserver.net -u testebdb -–password=password mytestbdb > /home/content/q/a/b/testchep/html/backups/daily.sql

source