Backup
Publicado por joe roots 19/03/2006
[ Hits: 6.246 ]
Com este script, você poderá efetuar backup de seu banco de dados MySQL em formato SQL ou GZIP. Bastante útil.
<? extract($_POST); $fp3 = fopen ($path."dbinfo.php","w"); fwrite ($fp3,"<?\n"); fwrite ($fp3,"\$dbhost=\"$dbhost\";\n"); fwrite ($fp3,"\$dbuser=\"$dbuser\";\n"); fwrite ($fp3,"\$dbpass=\"$dbpass\";\n"); fwrite ($fp3,"\$dbname=\"$dbname\";\n"); fwrite ($fp3,"\$path=\"$path\";\n"); fwrite ($fp3,"?>\n"); fclose ($fp3); chmod($path."dbinfo.php", 0644); if ($recreate!=1) include "dbinfo.php"; ?> <html> <head> <title>MySQL PHP Backup :: Backup</title> <style type="text/css"> body { font-family: "verdana", sans-serif } </style> </head> <? if ($recreate!=1) { flush(); $conn = @mysql_connect($dbhost,$dbuser,$dbpass); if ($conn==false) die("password / user or database name wrong"); $path = $path . "dump/"; if (!is_dir($path)) mkdir($path, 0766); chmod($path, 0777); if(!file_exists($path . "backup.sql")) { $fp2 = fopen ($path."backup.sql","w"); fwrite ($fp2,""); fclose ($fp2); chmod($path."backup.sql", 0777); } if(file_exists($path . "backup.gz")) { unlink($path."backup.gz"); } } else { // recreate dir /dump $path = $path . "dump/"; if (!is_dir($path)) mkdir($path, 0766); chmod($path, 0777); } function get_def($dbname, $table) { global $conn; $def = ""; $def .= "DROP TABLE IF EXISTS $table;#%%\n"; $def .= "CREATE TABLE $table (\n"; $result = mysql_db_query($dbname, "SHOW FIELDS FROM $table",$conn) or die("Table $table not existing in database"); while($row = mysql_fetch_array($result)) { $def .= " $row[Field] $row[Type]"; if ($row["Default"] != "") $def .= " DEFAULT '$row[Default]'"; if ($row["Null"] != "YES") $def .= " NOT NULL"; if ($row[Extra] != "") $def .= " $row[Extra]"; $def .= ",\n"; } $def = ereg_replace(",\n$","", $def); $result = mysql_db_query($dbname, "SHOW KEYS FROM $table",$conn); while($row = mysql_fetch_array($result)) { $kname=$row[Key_name]; if(($kname != "PRIMARY") && ($row[Non_unique] == 0)) $kname="UNIQUE|$kname"; if(!isset($index[$kname])) $index[$kname] = array(); $index[$kname][] = $row[Column_name]; } while(list($x, $columns) = @each($index)) { $def .= ",\n"; if($x == "PRIMARY") $def .= " PRIMARY KEY (" . implode($columns, ", ") . ")"; else if (substr($x,0,6) == "UNIQUE") $def .= " UNIQUE ".substr($x,7)." (" . implode($columns, ", ") . ")"; else $def .= " KEY $x (" . implode($columns, ", ") . ")"; } $def .= "\n);#%%"; return (stripslashes($def)); } function get_content($dbname, $table) { global $conn; $content=""; $result = mysql_db_query($dbname, "SELECT * FROM $table",$conn); while($row = mysql_fetch_row($result)) { $insert = "INSERT INTO $table VALUES ("; for($j=0; $j<mysql_num_fields($result);$j++) { if(!isset($row[$j])) $insert .= "NULL,"; else if($row[$j] != "") $insert .= "'".addslashes($row[$j])."',"; else $insert .= "'',"; } $insert = ereg_replace(",$","",$insert); $insert .= ");#%%\n"; $content .= $insert; } return $content; } if ($recreate!=1) { $filetype = "sql"; if (!eregi("/restore\.",$PHP_SELF)) { $cur_time=date("Y-m-d H:i"); if ($table_names == "*" ) { $tables = mysql_list_tables($dbname,$conn); $num_tables = @mysql_num_rows($tables); $i = 0; while($i < $num_tables) { $table = mysql_tablename($tables, $i); $newfile .= get_def($dbname,$table); $newfile .= "\n\n"; $newfile .= get_content($dbname,$table); $newfile .= "\n\n"; $i++; } } else { $i=0; $tables=explode(";",$table_names); if (count($tables) != 0) { while($i < count($tables)) { $newfile .= get_def($dbname,$tables[$i]); $newfile .= "\n\n"; $newfile .= get_content($dbname,$tables[$i]); $newfile .= "\n\n"; $i++; } } } $fp = fopen ($path."backup.$filetype","w"); fwrite ($fp,$newfile); fclose ($fp); } } ?> <body bgcolor="#f4f4f4" link="#000000" alink="#000000" vlink="#000000"> <? if ($recreate!=1) { ?> <CENTER> <BR> <TABLE WIDTH="80%" border="0" cellspacing="0" bgcolor="#8BA5C5"> <TR> <TD height="215" valign="top"> <h4>MySQL PHP Backup :: Backup</h4> <b><font color="#990000">Your backup request was processed.</font></b> <br> <font size="2"> If you did not receive any errors on the screen, then you should find a directory called "dump" (without the quotes) in the sub-directory of MySQL PHP Backup. <br> In the "dump" directory, you should find a file titled "backup.sql" (without the quotes). <br> It contains the following tables:<br> <? if ($_POST[table_names] == "*") { $count = $num_tables; } else { $count = count($tables); } if ($count != 0 ) { $i=0; while ($i < $count) { if ($_POST[table_names] == "*") { echo " ++ <b>".mysql_tablename($tables, $i)."</b><br>"; } else { echo " ++ <b>".$tables[$i]."</b><br>"; } $i++; } } else { echo "<font color='red'>No tables have been backed-up </font><br>"; } ?> This file is an unzipped backup of your database and must have the <em>same name</em> if you wish to do a restore using MySQL PHP Backup. </font> </TD> </TR> <? } else { ?> <CENTER> <BR> <TABLE WIDTH="80%" border="0" cellspacing="0" bgcolor="#8BA5C5"> <TR> <TD valign="top"> <h4>MySQL PHP Backup :: Backup</h4> <b><font color="#990000">Your backup directory was recreated,</font></b> <br> <font size="2"> and the dbinfo.php file was created.<br> You can now upload your backup to the /dump directory.<br><br> </td> </tr> <? } ?> <TR> <TD height="27" valign="top"><B><A HREF="index.php"><font color="#FFFFFF" size="1"><br> Return to Main</font></A></B></TD> </TR> <TR> <TD height="15" valign="top" bgcolor="#FFFFFF"><div align="right"><font color="#9999CC" face="Arial, Helvetica, sans-serif" style="font-size:6Pt">MySql Php Backup © 2003 by <a href="http://www.absoft-my.com" target="_blank">AB Webservices</a></font> </div></TD> </TR> </TABLE> <BR><BR> <BR> <BR> </CENTER> </body> </html>
Função para criação de grid (tabela) dinâmico
Script Para Conectar-se Ao Banco de dados MYSQL
Base de dados das cidades do Brasil
Melhorando o tempo de boot do Fedora e outras distribuições
Como instalar as extensões Dash To Dock e Hide Top Bar no Gnome 45/46
E a guerra contra bots continua
Tradução do artigo do filósofo Gottfried Wilhelm Leibniz sobre o sistema binário
Conheça o firewall OpenGFW, uma implementação do (Great Firewall of China).
Instalando o FreeOffice no LMDE 6
Anki: Remover Tags de Estilo HTML de Todas as Cartas
Colocando uma opção de redimensionamento de imagem no menu de contexto do KDE
Como adicionar módulo de saúde da bateria dos notebooks Acer ao kernel... (19)
[Shell Script] Script para desinstalar pacotes desnecessários no OpenSuse
[Shell Script] Script para criar certificados de forma automatizada no OpenVpn
[Shell Script] Conversor de vídeo com opção de legenda
[C/C++] BRT - Bulk Renaming Tool
[Shell Script] Criação de Usuarios , Grupo e instalação do servidor de arquivos samba