} 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); }