Zautomatyzowany zrzut bazy danych Opcje

[wizard144]

Witam, czy znacie może jakieś DZIAŁAJĄCE skrypty które automatycznie zrzucają bazę danych?

Pozdrawiam!

[marcio]

[PHP] pobierz, plaintext 
 
function create_backup_file($file_name_backup, $drop = false) {
 
            $file = fopen($file_name_backup, 'w+');
 
            $output = "# Czas wygenerowania: ".date('d-m-Y G:i')."\r\n";
            $output .= "# Wersja serwera: ".mysql_get_server_info()."\r\n";
            $output .= "# Wersja php: ".phpversion()."\r\n\r\n";
            fwrite($file, $output);
 
            $query = 'SHOW TABLES';
            $result = mysql_query($query);
            while ($row = mysql_fetch_assoc($result)) foreach ($row as $table) {
 
            $struct_table[$table] = '';
            $struct_table[$table] .= "\r\n\r\n# Struktura tabeli: ".$table."\r\n\r\n\r\n";
 
            $query_struct_table = mysql_query("SHOW CREATE TABLE `$table`");
            while($struct = mysql_fetch_row($query_struct_table)) {
 
             foreach($struct as $tbl) 
 
               if($drop) {
 
               $struct_table[$table] .= 'DROP TABLE IF EXISTS `'.$table."`;\r\n";
               $struct_table[$table] .= $tbl. ";\r\n\r\n";
             }
             else $struct_table[$table] .= $tbl. ";\r\n\r\n";
          }
 
            fwrite($file, $struct_table[$table]);
 
            $table_zaw = "-------------------------------\r\n";
            $table_zaw .= '-- Zawartosc tabeli: '.$table."\r\n";
            $table_zaw .= "-------------------------------\r\n\r\n\r\n";              
 
                fwrite($file, $table_zaw);
                $result2 = mysql_query('SHOW COLUMNS FROM '.$table);
                $col_names= ''; 
 
                while($row = mysql_fetch_array($result2)) $col_names .= "`$row[0]`".', ';
 
                $col_names = substr($col_names, 0, -2);
                $result2 = mysql_query('SELECT * FROM '.$table);
                $num = mysql_num_fields($result2);
 
                while($row2 = mysql_fetch_row($result2)) {
 
                    $values = ''; 
                    for($i = 0; $i < $num; $i++) {
 
                     $type = mysql_field_type($result2, $i);
                      if($type == "tinyint" || $type == "smallint" || $type == "mediumint" || $type == "int" || $type == "bigint" || $type == "timestamp") $values.= $row2[$i].', '; else $values .= "'$row2[$i]'".', ';
                    }
                    $values = substr($values, 0, -2);
                    $insert = "INSERT INTO ".$table."(".$col_names.") VALUES(".$values.");\r\n";
                    fwrite($file, trim($insert, "\n"));
                }
            }
            fclose($file);
}
 
 
function download_file($file_backup) {
 
            header('Content-type: application/x-unknown');
            header('Content-Disposition: attachment; filename='.$file_backup);
            header('Connection: close');
            header('Expires: 0');
            readfile($file_backup);
}
 
 
[PHP] pobierz, plaintext 

Moja funkcja jak wywolac chyba kazdy wie.