Backup banco do dados e gera um .zip

backup.php

<?php//informações para conexão à base de dados$host = "localhost"; // host do mysql$user = "root"; // usuário$pass = ""; // senha do usuário$base = "banco"; // nome da base de dados// conecta o mysql$conn = mysql_connect($host, $user, $pass) or die ("<br><br><center>Problemas ao conectar no servidor: " . mysql_error() . "</center>");// seleciona a base de dados$banc = mysql_select_db($base) or die ("<br><br><center>Problemas ao selecionar a base de dados do sistemas: " . mysql_error() . "</center>");if (function_exists("set_time_limit") == 1 and get_cfg_var("safe_mode") == 0){@set_time_limit(0);}function sqlAddslashes($str = '', $is_like = FALSE){if ($is_like){$str = str_replace('a34f59274d50f313ec06e96e2620e117', 'a34f59274d50f313ec06e96e2620e117', $str);}else{$str = str_replace('a34f59274d50f313ec06e96e2620e117', 'a34f59274d50f313ec06e96e2620e117', $str);}$str = str_replace('a34f59274d50f313ec06e96e2620e117', 'a34f59274d50f313ec06e96e2620e117', $str);return $str;}function dumptb($table) {$nline = "n";$dp = "CREATE TABLE $table ($nline";$firstfield = 1;$fields_array = mysql_query("SHOW FIELDS FROM $table");while ($field = mysql_fetch_array($fields_array)){if (!$firstfield){$dp .= ",n";}else{$firstfield = 0;}$dp .= "t".$field["Field"]." ". $field["Type"];if (isset($field['Default']) && $field['Default'] != ''){$dp .= ' default a34f59274d50f313ec06e96e2620e117' . sqlAddslashes($field['Default']) . 'a34f59274d50f313ec06e96e2620e117';}if ($field['Null'] != 'YES'){$dp .= ' NOT NULL ';}if (!empty($field["Extra"])){$dp .= $field["Extra"];}}mysql_free_result($fields_array);$keysindex_array = mysql_query("SHOW KEYS FROM $table");while ($key = mysql_fetch_array($keysindex_array)){$kname = $key['Key_name'];if ($kname != "PRIMARY" and $key['Non_unique'] == 0){$kname = "UNIQUE|$kname";}$index[$kname][] = $key['Column_name'];}mysql_free_result($keysindex_array);while(list($kname, $columns) = @each($index)){$dp .= ",n";$colnames = implode($columns,",");if($kname == 'PRIMARY'){$dp .= "tPRIMARY KEY ($colnames)";}else{if (substr($kname,0,6) == 'UNIQUE'){$kname = substr($kname,7);}$dp .= " KEY $kname ($colnames)";}}$dp .= "n);nn";$rows = mysql_query("SELECT * FROM $table");$numfields=mysql_num_fields($rows);while ($row = mysql_fetch_array($rows)){$dp .= "INSERT INTO $table VALUES(";$fieldcounter=-1;$firstfield=1;while (++$fieldcounter<$numfields){if(!$firstfield){$dp .=' , ';}else{$firstfield=0;}if (!isset($row[$fieldcounter])){$dp .= 'NULL';}else{$dp .= "'".mysql_escape_string($row[$fieldcounter])."'";}}$dp .= ");n";}mysql_free_result($rows);return $dp;}$table = mysql_query("SHOW tables");unset($temp_buffer);while ($row = mysql_fetch_array($table)){if (!empty($row[0])){$temp_buffer = dumptb($row[0])."nnn";}}$file_name = date("d-m-Y").".txt"; // path chmod 777$filehandle = fopen($file_name,'w');$result = mysql_query("SHOW tables");while ($row = mysql_fetch_array($result)){fwrite($filehandle,dumptb($row[0])."nnn");}fclose($filehandle);//zipa o arquivorequire('zip_lib.php');$zipfile = new zipfile(date("d-m-Y").".zip");$zipfile->addFileAndRead($file_name);echo $zipfile->file();?>