} else {
$content .= ",";
}
$st_counter = $st_counter + 1;
}
}
$content .= "\n\n\n";
}
//$backup_name = $backup_name ? $backup_name : $name."___(".date('H-i-s')."_".date('d-m-Y').")__rand".rand(1,11111111).".sql";
$backup_name = $backup_name ? $backup_name : $name . ".sql";
// header('Content-Type: application/octet-stream');
// header("Content-Transfer-Encoding: Binary");
// header("Content-disposition: attachment; filename=\"".$backup_name."\"");
return $content;
exit;
}
$content = Export_Database($mysqlHostName, $mysqlUserName, $mysqlPassword, $DbName, $tables = false, $backup_name = false);
$subject = 'database backup ' . date('d/m/Y');
$file_name = "backup.sql";
$myfile = fopen($file_name, "w") or die("Unable to open file!");
fwrite($myfile, $content);
fclose($myfile);
$remoteName = "backup " . date('d-m-Y') . ".sql";
echo "now sending email";
$mg = new Mailgun("key-e3d5092ee6f3ace895af4f6a6811e53a");
$domain = "mg.faizstudents.com";
$mg->sendMessage($domain, array('from' => '*****@*****.**', 'to' => '*****@*****.**', 'subject' => $subject, 'html' => "Please find the attachment named {$remoteName}"), array('attachment' => array(array('filePath' => $file_name, 'remoteName' => $remoteName))));
echo "##########completed##############";
?>
function export_sql()
{
/* Connexion a la base de donnees de l'application, puis a la table correspondante aux donnees personnelles */
$mysqlUserName = "******";
$mysqlPassword = "******";
$mysqlHostName = "localhost";
$DbName = "site_rentree";
$backup_name = "mybackup.sql";
$tables = "data";
/* Export de la base de donnees */
Export_Database($mysqlHostName, $mysqlUserName, $mysqlPassword, $DbName, $tables = false, $backup_name = false);
}
