Danke!
Aber die Werte $cur_date und der $filetype sind es leider nicht!
ich poste mal den kompletten Code ich möchte das Ergebniss( ein SQL Backup ) per FTP weiterleiten!
//Erstelle Struktur von Datenbank
function get_def($dbname, $table) {
global $verbindung;
$def = "";
$def .= "CREATE TABLE $table (\n";
$result = mysql_db_query($dbname, "SHOW FIELDS FROM $table",$verbindung);
while($row = mysql_fetch_array($result)) {
$def .= " $row[Field] $row[Type]";
if ($row["Default"] != "") $def .= " DEFAULT '$row[Default]'";
if ($row["Null"] != "YES") $def .= " NOT NULL";
if ($row["Extra"] != "") $def .= " $row[Extra]";
$def .= ",\n";
}
$def = ereg_replace(",\n$","", $def);
$result = mysql_db_query($dbname, "SHOW KEYS FROM $table",$verbindung);
while($row = mysql_fetch_array($result)) {
$kname=$row["Key_name"];
if(($kname != "PRIMARY") && ($row["Non_unique"] == 0)) $kname="UNIQUE|$kname";
if(!isset($index[$kname])) $index[$kname] = array();
$index[$kname][] = $row["Column_name"];
}
while(list($x, $columns) = @each($index)) {
$def .= ",\n";
if($x == "PRIMARY") $def .= " PRIMARY KEY (" . implode($columns, ", ") . ")";
else if (substr($x,0,6) == "UNIQUE") $def .= " UNIQUE ".substr($x,7)." (" . implode($columns, ", ") . ")";
else $def .= " KEY $x (" . implode($columns, ", ") . ")";
}
$def .= "\n);";
return (stripslashes($def));
}
//Erstelle Eintäge von Tabelle
function get_content($dbname, $table) {
global $verbindung;
$content="";
$result = mysql_db_query($dbname, "SELECT * FROM $table",$verbindung);
while($row = mysql_fetch_row($result)) {
$insert = "INSERT INTO $table VALUES (";
for($j=0; $j<mysql_num_fields($result);$j++) {
if(!isset($row[$j])) $insert .= "NULL,";
else if($row[$j] != "") $insert .= "'".addslashes($row[$j])."',";
else $insert .= "'',";
}
$insert = ereg_replace(",$","",$insert);
$insert .= ");\n";
$content .= $insert;
}
return $content;
}
//Funktion um Backup auf dem Server zu speichern
function write_backup($val,$newfile,$newfile_data)
{
global $compression,$path,$cur_date,$filetype,$backup_pfad;
$backup_pfad[] = $path.$val."_structur_".$cur_date.".".$filetype;
$backup_pfad[] = $path.$val."_data_".$cur_date.".".$filetype;
if ($compression==1)
{
$fp = gzopen($path.$val."_structur_".$cur_date.".".$filetype,"w9");
gzwrite ($fp,$newfile);
gzclose ($fp);
$fp = gzopen($path.$val."_data_".$cur_date.".".$filetype,"w9");
gzwrite ($fp,$newfile_data);
gzclose ($fp);
}
else
{
$fp = fopen ($path.$val."_structur_".$cur_date.".".$filetype,"w");
fwrite ($fp,$newfile);
fclose ($fp);
$fp = fopen($path.$val."_data_".$cur_date.".".$filetype,"w");
fwrite ($fp,$newfile_data);
fclose ($fp);
}
}
//Backup per Email verschicken
function mail_att($to, $from, $subject, $message) {
// $to Empfänger
// $from Absender ("email@domain.de" oder "Name <email@domain.de>")
// $subject Betreff
// $message Inhalt der Email
global $backup_pfad; //Die Pfade zu den Dateien
if(is_array($backup_pfad) AND count($backup_pfad) > 0)
{
$mime_boundary = "-----=" . md5(uniqid(rand(), 1));
$header = "From: ".$from."\r\n";
$header.= "MIME-Version: 1.0\r\n";
$header.= "Content-Type: multipart/mixed;\r\n";
$header.= " boundary=\"".$mime_boundary."\"\r\n";
$content = "This is a multi-part message in MIME format.\r\n\r\n";
$content.= "--".$mime_boundary."\r\n";
$content.= "Content-Type: text/plain charset=\"iso-8859-1\"\r\n";
$content.= "Content-Transfer-Encoding: 7bit\r\n\r\n";
$content.= $message."\r\n";
//Dateien anhaengen
foreach($backup_pfad AS $file)
{
$name = basename($file);
$data = chunk_split(base64_encode(implode("", file($file))));
$len = filesize($file);
$content.= "--".$mime_boundary."\r\n";
$content.= "Content-Disposition: attachment;\r\n";
$content.= "\tfilename=\"$name\";\r\n";
$content.= "Content-Length: .$len;\r\n";
$content.= "Content-Type: application/x-gzip; name=\"".$file."\"\r\n";
$content.= "Content-Transfer-Encoding: base64\r\n\r\n";
$content.= $data."\r\n";
}
if(mail($to, $subject, $content, $header)) return true;
else return false;
}
return false;
}
//Backup erstellen
while (list(,$val) = each($dbname))
{
$newfile="# Strukturbackup: $cur_time \r\n# www.php-einfach.de \r\n";
$newfile_data="# Datenbackup: $cur_time \r\n# www.php-einfach.de \r\n";
//backup schreiben
$tables = mysql_list_tables($val,$verbindung);
$num_tables = @mysql_num_rows($tables);
$i = 0;
while($i < $num_tables)
{
$table = mysql_tablename($tables, $i);
$newfile .= "\n# ----------------------------------------------------------\n#\n";
$newfile .= "# structur for Table '$table'\n#\n";
$newfile .= get_def($val,$table);
$newfile .= "\n\n";
$newfile_data .= "\n# ----------------------------------------------------------\n#\n";
$newfile_data .= "#\n# data for table '$table'\n#\n";
$newfile_data .= get_content($val,$table);
$newfile_data .= "\n\n";
$i++;
}
write_backup($val,$newfile,$newfile_data);
} //End: while
//Backup per Email senden
if($send == 1)
{
$text="Datenbank-Backup vom: ".date("d.m.Y H:i")."\n\n\n www.php-einfach.de PHP lernen leicht gemacht";
$from = "backup@server.de";
if(!mail_att($email, $from, "Datenbank-Backup ".date("Y-m-d"), $text))
echo "Es konnte <b>keine</b> Email gesendet werden<br>";
}
//Backup per FTP senden
if ($use_ftp == '1') {
if ($compression == '1') {
$mode = FTP_BINARY;
} else {
$mode = FTP_ASCII;
}
$ftp_id = ftp_connect($ftp_server);
$login_result = ftp_login($ftp_id, $ftp_user_name, $ftp_user_pass);
$upload = ftp_put($ftp_id, $ftp_path , [b]??????[/b] , $mode);
ftp_close($ftp_id);
}
echo "<h3>Backup ist fertig</h3>";
