Backup
Publicado por joe roots 19/03/2006
[ Hits: 6.567 ]
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>
Testando servidor MySQL e base de dados
Script SQL para banco de sistemas de postagens de artigos 1.0
Classe MySQLDatabase [golfinho/Elefante]
Servidor de Backup com Ubuntu Server 24.04 LTS, RAID e Duplicati (Dell PowerEdge T420)
Visualizar câmeras IP ONVIF no Linux sem necessidade de instalar aplicativos
Atualizar Debian Online de uma Versão para outra
Proteja seu Linux Mint com o Timeshift: Restaure o sistema mesmo que ele não inicie!
Instalando Google Chrome no Debian 13
Alguém pode me recomendar um editor de textos? (0)
meus dois pen drives não são mais reconhecidos pelo meu PC apos tentar... (1)