"; print "

Database backup / restore

"; print "

Terug naar database menu Backup maken Backup terug zetten/dowloaden

"; if (!$do or $do == "weergeven") { Echo '

Met behulp van backup / restore kan er van de complete database een backup gemaakt worden. Dit is b.v. makkelijk als je de poel op een andere server wilt zetten, of als er wat fout is gegaan. De opgeslagen "SQL" file is alleen compatible met deze backup / restore. Indien je een ander formaat wilt, zul je b.v. een backup met "PHPMyAdmin" moeten maken.

'; } elseif ($do == "backup") { $tables = mysql_list_tables($dbaseName); $num_tables = @mysql_num_rows($tables); if ($num_tables == 0) { die("Fout: Database heeft geen tabellen"); } ?>

Database verbindingsgegevens:

Maak een backup
Je database host:
Database Gebruikersnaam:
Database Wachtwoord:
Database naam:

Database inhoud:

"; print ""; print ''; print ''; print ''; print ''; $i++; if ($bgcolor == '#96B9DC') { $bgcolor = '#B1CBE4'; } else { $bgcolor = '#96B9DC'; } } // Backup Structure only
?>
TABELLEN RIJEN AANGEMAAKT OP DATA GROOTTE kB INDEX GROOTTE kB
" . ($i + 1) . "" . $rows["Name"] . " ' . $rows['Rows'] . '' . $rows['Create_time'] . '' . number_format($rows['Data_length'] / 1024, 1) . '' . number_format($rows['Index_length'] / 1024, 1) . '

Selecteer Alles    Uncheck All    Backup File Naam: " . $backup_file . "


"; ?>
Backup wordt opgeslagen...

"); ini_set("max_execution_time", 0); $tables = mysql_list_tables($dbaseName); $num_tables = @mysql_num_rows($tables); if ($num_tables == 0) { die("Fout: Database heeft geen tabellen"); } $numtables = $num_tables - 1; function get_def($dbname, $table) { $def = ""; $def .= "DROP TABLE IF EXISTS $table;#%%\n"; $def .= "CREATE TABLE $table (\n"; $result = mysql_query("SHOW FIELDS FROM $table") or die("Table $table not existing in database"); 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_query("SHOW KEYS FROM $table"); 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)); } function get_content($dbname, $table) { $content = ""; mysql_query("LOCK TABLES " . $table . " WRITE"); $result = mysql_query("SELECT * FROM $table"); 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; } mysql_query("UNLOCK TABLES"); return $content; } extract($_POST); flush(); // start timer $starttime = time(); $conn = @mysql_connect($dbhost, $dbuser, $dbpass); if ($conn == false) die("password / user or database naam verkeerd"); mysql_select_db($dbname, $conn); $x = $_SERVER[SERVER_SOFTWARE]; if (strpos($x, "Win32") != 0) { $path = $path . "dump\\"; } else { $path = $path . "dump/"; } /* if (!is_dir($path)) mkdir($path, 0766); chmod($path, 0777); */ $fp2 = fopen($path . $backup_file, "w"); $copyr = "# Tabel backup from MySql PHP Backup\n" . "# AB Webservices 1999-" . date("Y") . "\n" . "# www.absoft-my.com/pondok\n" . "# Creation date: " . date("d-M-Y h:s", time()) . "\n" . "# Database: " . $dbname . "\n" . "# MySQL Server version: " . mysql_get_server_info() . "\n\n"; fwrite($fp2, $copyr); fclose($fp2); chmod($path . $backup_file, 0777); if (file_exists($path . "backup.gz")) { unlink($path . "backup.gz"); } $recreate = 0; $filetype = "sql"; if (!eregi("/restore\.", $PHP_SELF)) { $cur_time = date("Y-m-d H:i"); $i = 0; while ($i < $numtables + 1) { if ($tables[$i] != "") { $newfile .= get_def($dbname, $tables[$i]); $newfile .= "\n\n"; if ($structonly != "Yes") { $newfile .= get_content($dbname, $tables[$i]); $newfile .= "\n\n"; } } $i++; } $fp = fopen($path . $backup_file, "a"); fwrite($fp, $newfile); fwrite($fp, "# Valid end of backup from MySql PHP Backup\n"); fclose($fp); } ?>

MySQL PHP Backup :: Backup

Your backup request was processed. If you did not receive any errors on the screen, then you should find a directory called "dump" (without the quotes) in the sub-directory of MySQL PHP Backup. In the "dump" directory, you should find a file titled " " (without the quotes). It contains the following tables:

"; while ($i < $numtables + 1) { if ($tables[$i] != "") { echo "
  • " . $tables[$i] . "
    • "; } $i++; } echo ""; } else { echo "No tables have been backed-up
    "; } echo '
    File size: ' . round((filesize($path . $backup_file) / 1024), 1) . ' kB'; $endtime = time(); $mins = round((time() - $starttime) / 60, 0); $sec = $endtime - $starttime - ($mins * 60); echo "
    Time used: "; if ($mins > 0) { echo $mins . " minutes and "; } else { echo $sec . " seconds.

    "; } ?> This file is an unzipped backup of your database and must have the same name if you wish to do a restore using MySQL PHP Backup.
    Backup terug zetten

    "); if (get_extension_funcs('zlib')) { echo "Zlib is gevonden op de server, je kunt een gemaakte backup gezipt downloaden."; } else { echo "Zlib is niet gevonden op de server. Je kunt geen backup downloaden naar je PC!"; } extract($_REQUEST); // $path = ""; $password = $dbpass; ?>
    '; } ?>

    Poel Backup :: Backup terug zetten
    Beneden staan de backup bestanden. Druk op restore om de backup terug te zetten. Let op, de huidige inhoud wordt overschreven!
    File " . $backup_file ." extracted from $file.
    "; $file = ''; } // end of unzip } if ($file != "") { flush(); $filename = $file; set_time_limit(1000); $file = fread(fopen($path . $file, "r"), filesize($path . $file)); $query = explode(";#%%\n", $file); mysql_query($query[0]) or die(mysql_error()); for ($i = 0; $i < count($query) - 1; $i++) { mysql_query($query[$i]) or die(mysql_error()); } echo "
    Het terug zetten is uitgevoerd.
    Als er geen foutmeldingen zijn gegeven, mag je er vanuit gaan dat het terugzetten is gelukt. Als je hebt geprobeerd een SQL file terug te zetten welke niet is gegenereerd met dit script (b.v. met PHPMYADMIN) dan heb je waarschijnlijk diverse foutmeldingen gehad. Het poel backup/restore sript kan alleen backups terug zetten welke zijn zelf gemaakt met dit script.

    "; } ?>
    '; } else { echo ""; } } } closedir($dir); ?>
    File Size Date    
    ' . $file . ' ' . round(filesize($path . $file) / 1024, 2) . ' KB ' . date("d-m-Y", filemtime($path . $file)) . ' Restore View
    $file " . round(filesize($path . $file) / 1024, 2) . " KB " . date("d-m-Y", filemtime($path . $file)) . " Unzip
    '; print "
    Inhoud van: " . $bestand . "
    "; flush(); $file = $bestand; set_time_limit(1000); $file = fread(fopen($path."dump\\" . $file, "r"), filesize($path . "dump\\". $file)); $query = explode(";#%%\n", $file); for ($i = 0; $i < count($query) - 1; $i++) { print $query[$i] . "
    "; } echo ''; } ?>