35 18 * * * root php /var/www/bckup.php


<?php
$tmpDir = "/tmp/";
$user = "root";
$password = "root";
$dbName = "ourbank";
$prefix = "ourbank_";

$subject = "db - backup";
$sqlFile = $tmpDir.$prefix.date('Y_m_d').".sql";
$attachment = $tmpDir.$prefix.date('Y_m_d').".tgz";

$creatBackup = "mysqldump -u ".$user." --password=".$password." ".$dbName." > ".$sqlFile;

$createZip = "tar cvzf $attachment $sqlFile";
exec($creatBackup);
exec($createZip);
?>