Database auto backup

[faizrashid]

Hi guys, I'm kinda a newbie here in database.
Anyone here know the coding to make the auto backup database for a php system?

 

[LostNerd]

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.

 

[faizrashid]

I wanted to backup a single database only. Can it be done by using a .php code?

 

[LostNerd]

<?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.

 

[cPanelMichael]

Hello

Note that you can also backup a database through the cPanel interface or using "mysqldump" from the command line.

Thank you.