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>";

   }