backup_restore.php

<?php

/**************************************************************
"Learning with Texts" (LWT) is released into the Public Domain.
This applies worldwide.
In case this is not legally possible, any entity is granted the
right to use this work for any purpose, without any conditions, 
unless such conditions are required by law.

Developed by J. Pierre in 2011.
***************************************************************/

/**************************************************************
Call: backup_restore.php?....
      ... restore=xxx ... do restore 
      ... backup=xxx ... do backup 
Backup/Restore LWT Database
***************************************************************/

include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";

$message = '';

// RESTORE

if (isset($_REQUEST['restore'])) {
	if ( isset($_FILES["thefile"]) && $_FILES["thefile"]["tmp_name"] != "" && $_FILES["thefile"]["error"] == 0 ) {
		$handle = gzopen ($_FILES["thefile"]["tmp_name"], "r");
		if ($handle === FALSE) {
			$message = "Error: Restore file could not be opened";
		} // $handle not OK
		else { // $handle OK
			$lines = 0;
			$ok = 0;
			$errors = 0;
			$drops = 0;
			$inserts = 0;
			$creates = 0;
			$start = 1;
			while (! gzeof($handle)) {
				$sql_line = trim(
					str_replace("\r","",
					str_replace("\n","",
					gzgets($handle, 99999))));
				if ($sql_line != "") {
					if($start) {
						if (strpos($sql_line,"-- lwt-backup-") === false ) {
							$message = "Error: Invalid Restore file (possibly not created by LWT backup)";
							break;
						}
						$start = 0;
					}
					if(strpos($sql_line, "--") === false) {
						//echo tohtml($sql_line) . "<br />"; $res=TRUE;
						$res = mysql_query($sql_line);
						$lines++;
						if ($res == FALSE) $errors++;
						else {
							$ok++;
							if (substr($sql_line,0,11) == "INSERT INTO") $inserts++;
							elseif (substr($sql_line,0,10) == "DROP TABLE") $drops++;
							elseif (substr($sql_line,0,12) == "CREATE TABLE") $creates++;
						}
					}
				}
			} // while (! feof($handle))
			gzclose ($handle);
			if ($errors == 0) {
				optimizedb();
				$message = "Success: Database restored - " .
				$lines . " queries - " . $ok . " successful (" . $drops . "/" . $creates . " tables dropped/created, " . $inserts . " records added), " . $errors . " failed.";
			} else {
				$message = "Error: Database NOT restored - " .
				$lines . " queries - " . $ok . " successful (" . $drops . "/" . $creates . " tables dropped/created, " . $inserts . " records added), " . $errors . " failed.";
			}
		} // $handle OK
	} // restore file specified
	else {
		$message = "Error: No Restore file specified";
	}
} 

// BACKUP

elseif (isset($_REQUEST['backup'])) {
	$tables = array();
	$result = mysql_query('SHOW TABLES');
	while ($row = mysql_fetch_row($result)) 
		$tables[] = $row[0];
	$fname = "lwt-backup-" . date('Y-m-d-H-i-s') . ".sql.gz";
	$out = "-- " . $fname . "\n";
	foreach($tables as $table) { // foreach table
		$result = mysql_query('SELECT * FROM ' . $table);
		$num_fields = mysql_num_fields($result);
		$out .= "\nDROP TABLE IF EXISTS " . $table . ";\n";
		$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
		$out .= str_replace("\n"," ",$row2[1]) . ";\n";
		while ($row = mysql_fetch_row($result)) { // foreach record
			$return = 'INSERT INTO ' . $table . ' VALUES(';
			for ($j=0; $j < $num_fields; $j++) { // foreach field
				if (isset($row[$j])) { 
					$return .= "'" . mysql_real_escape_string($row[$j]) . "'";
				} else { 
					$return .= 'NULL';
				}
				if ($j < ($num_fields-1)) $return .= ',';
			} // foreach field
			$out .= $return . ");\n";
		} // foreach record
	} // foreach table
	header('Content-type: application/x-gzip');
	header("Content-disposition: attachment; filename=" . $fname);
	echo gzencode($out,9);
	exit();
}
	
pagestart('Backup/Restore LWT Database',true);

echo error_message_with_hide($message,1);

?>
<form enctype="multipart/form-data" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table class="tab1" cellspacing="0" cellpadding="5">
<tr>
<th class="th1 center">Backup</th>
<td class="td1">
<p class="smallgray2">
The database <i><?php echo tohtml($dbname); ?></i> will be exported to a gzipped SQL file. Please keep this file in a safe place.<br />If necessary, you can recreate the database via the Restore function below.<br />Important: If the backup file is too large, the restore may not be possible (see limits below).</p>
<p class="right">&nbsp;<br /><input type="submit" name="backup" value="Download LWT Backup" /></p>
</td>
</tr>
<tr>
<th class="th1 center">Restore</th>
<td class="td1">
<p class="smallgray2">
The database <i><?php echo tohtml($dbname); ?></i> will be replaced by the data in the specified backup file<br />(gzipped or normal SQL file, created above).<br /><b>Please be careful - the existent database will be overwritten!</b> <br />Important: If the backup file is too large, the restore may not be possible.<br />Upload limits (in bytes): <b>post_max_size = <?php echo ini_get('post_max_size'); ?> / upload_max_filesize = <?php echo ini_get('upload_max_filesize'); ?></b><br />
If needed, increase in "<?php echo tohtml(php_ini_loaded_file()); ?>" and restart server.</p>
<p><input name="thefile" type="file" /></p>
<p class="right">&nbsp;<br /><input type="submit" name="restore" value="Restore from LWT Backup" /></p>
</td>
</tr>
<tr>
<th class="th1 center">Install<br />LWT<br />Demo</th>
<td class="td1">
<p class="smallgray2">
You may also replace the database <i><?php echo tohtml($dbname); ?></i> by the LWT demo database.</p>
<p class="right">&nbsp;<br />
<input type="button" value="Install LWT Demo Database" onclick="location.href='install_demo.php';" />
</td>
</tr>
<tr>
<td class="td1 right" colspan="2"> 
<input type="button" value="&lt;&lt; Back" onclick="location.href='index.php';" /></td>
</tr>
</table>
</form>

<?php

pageend();

?>