Database auto backup

Hello,

Just to clarify... Are you attempting to backup a single database or every database on your cPanel/WHM server?

If you are trying to backup your databases in one account only, the Backup Manager is very helpful.

 

Code:

<?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';

$backup_file = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass ".
           "test_db | gzip > $backup_file";

system($command);
?>

Something like this may work. Change it to your needs. However, I personally prefer using a program such as Navicat to perform backups for me.