Backup

Kode 

<?php
require("class_mysqldump.php");
require("class.phpmailer.php");

mysql_connect("localhost", "username", "password");
$dato = date("d-m-Y");
$filename = "/home/et_eller_andet/sql_backup/files/" . $dato . ".sql";
$dbnavn = "din_database"; //Database, som der skal laves backup af

$dump = new MySQLDump();
$mail = new PHPMailer();

$fp = fopen($filename, "w");
	fwrite($fp, $dump->dumpDatabase($dbnavn));
fclose($fp);

$mail->AddAddress("backup@email.adresse", "Bla bla Backup d. $dato");
$mail->Subject = "Backup the " . $dato;
$mail->Body    = "Backup sql file is an attachment";
$mail->AddAttachment($filename, "SQL_BACKUP_" . $dato . ".sql");  // optional name
$mail->Send();
?>

Jeg har haft samme problem, her er en løsning, denne sender også en kopi, af backupen til en email adresse ;=) very handy..

Kode 

<?php
require("class_mysqldump.php");
require("class.phpmailer.php");

mysql_connect("localhost", "username", "password");
$dato = date("d-m-Y");
$filename = "/home/et_eller_andet/sql_backup/files/" . $dato . ".sql";
$dbnavn = "din_database"; //Database, som der skal laves backup af

$dump = new MySQLDump();
$mail = new PHPMailer();

$fp = fopen($filename, "w");
	fwrite($fp, $dump->dumpDatabase($dbnavn));
fclose($fp);

$mail->AddAddress("backup@email.adresse", "Bla bla Backup d. $dato");
$mail->Subject = "Backup the " . $dato;
$mail->Body    = "Backup sql file is an attachment";
$mail->AddAttachment($filename, "SQL_BACKUP_" . $dato . ".sql");  // optional name
$mail->Send();
?>

Gør brug af to klasser:
phpmailer: http://phpmailer.sourceforge.net/

mysqldump: http://www.phpclasses.org/browse/file/10540.html

(Tip. sæt et cronjob, på at køre scriptet... så har du automatisk mysql backup, f.eks. hver nat