Sicherung der mySQL-DB

<?php
/*******************************************/
/* MySQL Database Backup                   */
/*******************************************/

//  -------------------------------------------------------------------------------------
// Script configuration:
$path = "../../phptmp/"; // backup path
    $host = "localhost"; // hostname
    $use_date = 1; // use date in file name

$numdb = 2; // number of databases to backup

$account[1] = "name"; // any name (used for filename)
    $user[1] = "wwXXXX"; // DB user
    $pw[1] = "XXXXXXXX"; // password
    $databasename[1] = "XXDatenbanknameXX"; // DB

$account[2] = "name2"; // any name (used for filename)
    $user[2] = "wwXXXX"; // DB user
    $pw[2] = "XXXXXXXX"; // password
    $databasename[2] = "usr_wwXXXX_1"; // DB
    

?>

<?php 
/*******************************************/
/* MySQL Database Backup for Cron Jobs     */
/*******************************************/

//  -------------------------------------------------------------------------------------
include ("config.inc");

for ($idb = 1; $idb <= $numdb; $idb++) {


$conn_id = mysql_connect($host,$user[$idb],$pw[$idb]) or die(mysql_error());

$database = $databasename[$idb];
$zaehler = 0;
$start=0;


// generate filesuffix if it should be used
if($use_date == 1) {
$datum = date(Ymd)."_"; 
} else{
$datum = ""; 
}

$file_name = $path.$datum.$account[$idb].".sql";
$file_old = $path.$database.".old";
$aktime=date("d-m-Y H:i");
$db_name = $dump1."$aktime\n";
$db_name.= $dump2."$database \r\n";
if (file_exists($file_name)){unlink($file_name);}  
$fd = fopen($file_name,"a+");
fwrite($fd, $db_name); 
fclose($fd);     
 
// Tabellenname Array auslesen und aufbauen

$tbl_array = array(); $c = 0;
$result2 = mysql_list_tables($database);
for($x=0; $x<mysql_num_rows($result2); $x++) {  
$tabelle = mysql_tablename($result2,$x);
if ($tabelle <>"") {
$tbl_array[$c] = mysql_tablename($result2,$x); $c++;$zaehler++;
}
}

flush();

// Start Ausgabe und Berechnung 
for ($y = 0; $y < $c; $y++) {  
$tabelle=$tbl_array[$y];

// Struktur der Tabelle einlesen

$def = "";
$def .= "DROP TABLE IF EXISTS $tabelle; \n";
$def .= "CREATE TABLE $tabelle (\n"; 
$result3 = mysql_db_query($database, "SHOW FIELDS FROM $tabelle",$conn_id);
while($row = mysql_fetch_array($result3)) {
$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);
$result3 = mysql_db_query($database, "SHOW KEYS FROM $tabelle",$conn_id);
while($row = mysql_fetch_array($result3)) {
$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($xy, $columns) = @each($index)) {
$def .= ",\n";
if($xy == "PRIMARY") $def .= "   PRIMARY KEY (" . implode($columns, ", ") . ")";
else if (substr($xy,0,6) == "UNIQUE") $def .= "   UNIQUE ".substr($xy,7)." (" . implode($columns, ", ") . ")";
else $def .= "   KEY $xy (" . implode($columns, ", ") . ")";
}

$def .= "\n); \n";
     
// Ende Struktur Modul
$db = @mysql_select_db($database,$conn_id); 

$tabelle="".$tabelle; 
$ergebnis=array();
$tbl_name = $dump3."$tabelle \r\n"; 
$fd = fopen($file_name,"a+"); 
fwrite($fd, $tbl_name.$def); 
fclose($fd);

unset($data);
if ($tabelle>""){  
$ergebnis[]=@mysql_select_db($database,$conn_id); 
$result=mysql_query("select * from $tabelle"); 
$anzahl= mysql_num_rows ($result); 
$spaltenzahl = mysql_num_fields($result); 
for ($i=0;$i<$anzahl;$i++) { 
$zeile=mysql_fetch_array($result); 
$data.="insert into $tabelle ("; 
for ($spalte = 0; $spalte < $spaltenzahl;$spalte++) { 
$feldname = mysql_field_name($result, $spalte); 
if($spalte == ($spaltenzahl - 1)) { 
$data.= $feldname; 
} else { 
$data.= $feldname.","; 
} 
};
$data.=") VALUES ("; 
for ($k=0;$k < $spaltenzahl;$k++){ 
if($k == ($spaltenzahl - 1)) { 
$data.="'".addslashes($zeile[$k])."'"; 
} else { 
$data.="'".addslashes($zeile[$k])."',"; 
} 
} 
$data.= ");\n"; 
} 
$data.= "\n";
} else { 
$ergebnis[]= $err; 
} 

$zeit = (date("d_m_Y")); 
$fd = fopen($file_name,"a+"); 
$zeit = time() - $start;
$speed = $speed+$zeit;

for ($i3=0;$i3<count($ergebnis);$i3++){ 
fwrite($fd, $data); 
fclose($fd); 
} 
}
$groesse = filesize($file_name) / 1024;
$place =  $place+$groesse;

mysql_close($conn_id);

}

exit; 
?>

05-01-2004 13:51
XXDBNameXX
yabbse_banned
DROP TABLE IF EXISTS yabbse_banned;
CREATE TABLE yabbse_banned (
    type tinytext NOT NULL,
    value tinytext NOT NULL
);

yabbse_boards 
DROP TABLE IF EXISTS yabbse_boards; 
CREATE TABLE yabbse_boards (
    ID_CAT tinyint(4) DEFAULT '0' NOT NULL,
    ID_BOARD int(11) NOT NULL auto_increment,
    name tinytext NOT NULL,
    description text,
    moderators text,
    boardOrder tinyint(4) DEFAULT '0' NOT NULL,
    numTopics int(11) DEFAULT '0' NOT NULL,
    numPosts int(11) DEFAULT '0' NOT NULL,
    isAnnouncement tinyint(4) DEFAULT '0' NOT NULL,
    notifyAnnouncements tinyint(4) DEFAULT '0' NOT NULL,
    count tinyint(4) DEFAULT '0' NOT NULL,
    ID_LAST_TOPIC int(11),
   PRIMARY KEY (ID_BOARD),
   KEY ID_CAT (ID_CAT),
   KEY boardOrder (boardOrder)
);
insert into yabbse_boards (ID_CAT,ID_BOARD,name,description,moderators,boardOrder,numTopics,numPosts,isAnnouncement,notifyAnnouncements,count,ID_LAST_TOPIC) VALUES ('5','1','Test','Teste bis der Arzt kommt...','test','2','1','5','0','0','1','170');
...
...
...