Guest User

Db Dump

a guest
Oct 26th, 2017
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.32 KB | None | 0 0
  1. <html><head><title>Dump DB</title><style type='text/css'>@import url(https://fonts.googleapis.com/css?family=Ubuntu);html {
  2. background: #000000; color: #ffffff; font-family: 'Ubuntu'; font-size: 13px; width: 100%;}li {
  3. display: inline; margin: 5px; padding: 5px;}table, th, td {
  4. border-collapse:collapse; font-family: Tahoma, Geneva, sans-serif; background: transparent; font-family: 'Ubuntu'; font-size: 13px;}.table_home, .th_home, .td_home {
  5. border: 1px solid #ffffff;}th {
  6. padding: 10px;}a {
  7. color: #ffffff; text-decoration: none;}a:hover {
  8. color: gold; text-decoration: underline;}b {
  9. color: gold;}input[type=text], input[type=password],input[type=submit] {
  10. background: transparent; color: #ffffff; border: 1px solid #ffffff; margin: 5px auto; padding-left: 5px; font-family: 'Ubuntu'; font-size: 13px;}textarea {
  11. border: 1px solid #ffffff; width: 100%; height: 400px; padding-left: 5px; margin: 10px auto; resize: none; background: transparent; color: #ffffff; font-family: 'Ubuntu'; font-size: 13px;}select {
  12. width: 152px; background: #000000; color: lime; border: 1px solid #ffffff; margin: 5px auto; padding-left: 5px; font-family: 'Ubuntu'; font-size: 13px;}option:hover {
  13. background: lime; color: #000000;}</style></head><?phpecho $head.'<p align="center">';echo '<form action method=post><table width=371 class=tabnet><tr><th colspan="2">Dump DB</th></tr><tr> <td>Server </td> <td><input type=text name=server size=52></td></tr><tr> <td>Username</td> <td><input type=text name=username size=52></td></tr><tr> <td>Password</td> <td><input type=text name=password size=52></td></tr><tr> <td>DataBase Name</td> <td><input type=text name=dbname size=52></td></tr> <tr> <td>DB Type </td> <td><form method=post action="'.$me.'"> <select name=method> <option value="gzip">Gzip</option> <option value="sql">Sql</option> </select> <input type=submit value="Dump!" ></td></tr> </form></center></table>';if ($_POST['username'] && $_POST['dbname'] &&$_POST['method']){
  14. $date = date("Y-m-d");$dbserver = $_POST['server'];$dbuser = $_POST['username'];$dbpass = $_POST['password'];$dbname = $_POST['dbname'];$file = "Dump-$dbname-$date";$method = $_POST['method'];if ($method=='sql'){
  15. $file="Dump-$dbname-$date.sql";$fp=fopen($file,"w");}else{
  16. $file="Dump-$dbname-$date.sql.gz";$fp = gzopen($file,"w");}function write($data) {
  17. global $fp;if ($_POST['method']=='ssql'){
  18. fwrite($fp,$data);}else{
  19. gzwrite($fp, $data);}}mysql_connect ($dbserver, $dbuser, $dbpass);mysql_select_db($dbname);$tables = mysql_query ("SHOW TABLES");while ($i = mysql_fetch_array($tables)) {
  20. $i = $i['Tables_in_'.$dbname]; $create = mysql_fetch_array(mysql_query ("SHOW CREATE TABLE ".$i)); write($create['Create Table'].";nn"); $sql = mysql_query ("SELECT * FROM ".$i); if (mysql_num_rows($sql)) {
  21. while ($row = mysql_fetch_row($sql)) {
  22. foreach ($row as $j => $k) {
  23. $row[$j] = "'".mysql_escape_string($k)."'"; } write("INSERT INTO $i VALUES(".implode(",",$row).");n"); } }}if ($method=='ssql'){
  24. fclose ($fp);}else{
  25. gzclose($fp);}header("Content-Disposition: attachment; filename=" . $file); header("Content-Type: application/download");header("Content-Length: " . filesize($file));flush();$fp = fopen($file, "r");while (!feof($fp)){
  26. echo fread($fp, 65536); flush();} fclose($fp); }?>
Add Comment
Please, Sign In to add comment