Posted By

unMiracle on 01/05/11
Tagged

mysql php backup port 80
Versions (?)

Backup

/ Published in: PHP
Копирование бд через 80 порт
Expand | Embed | Plain Text
<?php
require_once("../core.php");
require_once(BASEDIR."getpage.php");
 
define("TMP_CFG", "backup_config.dat");
define("CONFIG", "backup_cfg.php");
define("FILE_TABLES", "backup_file_tables.dat");
 
$parse = "////\n";
 
chdir(BASEDIR.dirname($_SERVER['PHP_SELF'])."/");
 
if (file_exists(CONFIG)) require_once(CONFIG);
 
function structuredb(){
	include("backup_cnt.php");
 
	$struct_db = "structure_".$backup_dbname.".dat"; // файл структуры БД
	if (file_exists($struct_db)) unlink($struct_db);
	$fp = fopen($struct_db,"a+");
 
	$tables = mysql_list_tables($backup_dbname); // список таблиц
	while ($table = mysql_fetch_row($tables)) { // перебор таблиц
 
		$fields = mysql_list_fields($backup_dbname,$table[0]); // список полей таблицы
		$count_fields = mysql_num_fields($fields); // количество полей
 
		fwrite($fp,"\nTable: ".$table[0]."\n");
		for ($i = 0; $i < $count_fields; $i++){ // перебор полей
			$name_fields = mysql_field_name($fields, $i); // создание массива с именами полей для дальнейшей выборки из бд
			$type_fields = mysql_field_type($fields, $i);
			$len_fields = mysql_field_len($fields, $i);
			$flag_fields = mysql_field_flags($fields, $i);
			$name_field = mysql_field_name($fields, $i); // вывод шапки таблицы (имена полей)
			fwrite($fp,"Field: $name_fields | $type_fields | $len_fields | $flag_fields\n");
		} // END FOR #1
	} // END WHILE #1
	fclose($fp);
 
	$content = "<b>Save structure db $backup_dbname - complite.</b>";
	$fo = fopen($struct_db,"r");
	$content .= "<H3>Структура БД: $backup_dbname</H3><BR /><BR />";
 
	$data = fread($fo,filesize($struct_db));
	$data = str_replace("\n","<BR>",$data);
	$data = str_replace("Table:","<B>Table:</B>",$data);
	$data = str_replace("Field:","&nbsp &nbsp <B>Field:</B>",$data);
 
	fclose($fo);
	$content .= $data;
 
	$content .= "<hr>
<form method=\"post\" action='".$_SERVER['PHP_SELF']."'>
<input type=\"submit\" name=\"nextstep\" value=\"Туче\">
</form>";
 
	return $content; //"Function Structure DB";
}
 
function copydb($parse,$start){
	include("backup_cnt.php");
	$content = "";
	$dirdata = "database";
	if (!file_exists($dirdata) || !is_dir($dirdata)) mkdir($dirdata);
 
	$backup_ft = fopen(FILE_TABLES,"r");
	$backup_tables = fread($backup_ft,filesize(FILE_TABLES));
	fclose($backup_ft);
	$backup_table = explode("\n",$backup_tables);
 
	for ($i_table = 0; $i_table < count($backup_table); $i_table++){
		if (substr($backup_table[$i_table],0,1) != "#"){
			$fields = mysql_list_fields($backup_dbname,$backup_table[$i_table]); // список полей таблицы
			$count_fields = mysql_num_fields($fields); // количество полей
 
			$name_fields = "";
			for ($i = 0; $i < $count_fields; $i++){ // перебор полей
				$name_fields[] .= mysql_field_name($fields, $i); // создание массива с именами полей для дальнейшей выборки из бд
			} // END FOR #2
 
			$sql_count = mysql_query("SELECT count(*) AS c FROM ".$backup_table[$i_table]);
			$count_str = mysql_result($sql_count,'c');
			$max_count = 5000;
 
			if ($count_str > $max_count){
				if (empty($start)) $start = 0; else $start = intval($start);
				$file = $backup_table[$i_table].".dat";
				if (file_exists($dirdata."/".$file)){
					if (filemtime($dirdata."/".$file) < time() - 30) unlink($dirdata."/".$file);
					header("Refresh: 0;");
				}
				$fo = fopen($dirdata."/".$file,"a");
				if ($count_str >= $start + $max_count){
					$sql = mysql_query("SELECT * FROM ".$backup_table[$i_table]." LIMIT $start, $max_count"); // выборка
					$i = 0;
					while (mysql_fetch_array($sql)){
						fputs($fo,$parse);
						for ($y = 0; $y < $count_fields; $y++){
							$name_field_db = $name_fields[$y];
							$data_field = mysql_result($sql,$i,$name_field_db);
							$dstr = $data_field."\n";
							fputs($fo,"$dstr");
						} // END FOR #2
						fputs($fo,"\n\n");
						$i++;
					} // END WHILE #2
					fclose($fo);
					$start = $start + $max_count;
					print "<meta http-equiv=\"refresh\" content=\"2;url=http://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']."?s=$start\">";
					break;
				// END IF $count_str > $start + $max_count
				} elseif ($count_str > $start){ // копируем остаток таблицы
					$count = $count_str - $start;
					$sql = mysql_query("SELECT * FROM ".$backup_table[$i_table]." LIMIT $start, $count"); // выборка
					$i = 0;
					while (mysql_fetch_array($sql)){
						fputs($fo,$parse);
						for ($y = 0; $y < $count_fields; $y++){
							$name_field_db = $name_fields[$y];
							$data_field = mysql_result($sql,$i,$name_field_db);
							$dstr = $data_field."\n";
							fputs($fo,"$dstr");
						} // END FOR #2
						fputs($fo,"\n\n");
						$i++;
					} // END WHILE #2
					fclose($fo);
				}
				$backup_ft = fopen(FILE_TABLES,"w");
				for ($j = 0; $j < count($backup_table) - 1; $j++){
					if ($j == $i_table) $backup_table[$j] = "#".$backup_table[$j];
					fputs($backup_ft,$backup_table[$j]."\n");
				}
				$j = count($backup_table) - 1;
				if ($j == $i_table) $backup_table[$j] = "#".$backup_table[$j];
				fputs($backup_ft,$backup_table[$j]);
				fclose($backup_ft);
				$content .= "Table <b>".$backup_table[$i_table]."</b> ($count_str) - complite.<br>";
			} else {
				$sql = mysql_query("SELECT * FROM ".$backup_table[$i_table]); // выборка
				$file = $backup_table[$i_table].".dat";
				if (file_exists($dirdata."/".$file)) unlink($dirdata."/".$file);
				$fo = fopen($dirdata."/".$file,"a");
				$i = 0;
				while (mysql_fetch_array($sql)){
					fputs($fo,$parse);
					for ($y = 0; $y < $count_fields; $y++){
						$name_field_db = $name_fields[$y];
						$data_field = mysql_result($sql,$i,$name_field_db);
						$dstr = $data_field."\n";
						fputs($fo,"$dstr");
					} // END FOR #2
					fputs($fo,"\n\n");
					$i++;
				} // END WHILE #2
				fclose($fo);
				$backup_ft = fopen(FILE_TABLES,"w");
				for ($j = 0; $j < count($backup_table) - 1; $j++){
					if ($j == $i_table) $backup_table[$j] = "#".$backup_table[$j];
					fputs($backup_ft,$backup_table[$j]."\n");
				}
				$j = count($backup_table) - 1;
				if ($j == $i_table) $backup_table[$j] = "#".$backup_table[$j];
				fputs($backup_ft,$backup_table[$j]);
				fclose($backup_ft);
				$content .= "Table <b>".$backup_table[$i_table]."</b> ($i) - complite.<br>";
			} // if > 5000
		}
	} // END FOR #1
 
	$backup_ft = fopen(FILE_TABLES,"r");
	$backup_tables = fread($backup_ft,filesize(FILE_TABLES));
	fclose($backup_ft);
	$backup_table = explode("\n",$backup_tables);
	if (substr($backup_table[count($backup_table) - 1], 0, 1) == "#"){ // последняя строка файла
		unlink(FILE_TABLES);
		unlink(CONFIG);
		$content .= sendmail();
	}
	return $content;
}
 
function sendmail(){
	$boundary = "--".md5(uniqid(time()));
	$headers = "From: My site<[email protected]>
";
    $headers .= "Reply-To: [email protected]
";
    $headers .= "Return-Path: [email protected]
";
    $headers .= "X-Mailer: Jonel\n";
	$headers .= "MIME-Version: 1.0
";
	$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"
";
	$kod = 'windows-1251'; // utf-8
	$multipart .= "--$boundary\n";
	$multipart .= "Content-Type: text/html; charset=$kod\n";
	$multipart .= "Content-Transfer-Encoding: Quot-Printed\n\n";
	$multipart .= "Backup\n\n";
 
	global $backup_dbname;
	$path = "structure_".$backup_dbname.".dat";
	if (file_exists($path)){
		$fp = fopen($path,"r");
		if ($fp){
			$file = fread($fp,filesize($path));
			fclose($fp);
			$message_part = "";
			$message_part .= "Content-Type: application/octet-stream";
			$message_part .= "; name = \"$path\"\n";
			$message_part .= "Content-Transfer-Encoding: base64\n";
			$message_part .= "Content-Disposition: attachment; filename = \"".$path."\"\n\n";
			$message_part .= chunk_split(base64_encode($file))."\n\n";
			$multipart .= "--$boundary\n".$message_part;
			unlink($path);
		}
	}
 
	$database = opendir("database/");
	while ($filename = readdir($database)){
		$ftype = filetype("database/".$filename);
		if ($ftype != "dir" && preg_match("#.dat$#D",$filename)){
			$path = "database/".$filename;
			$fp = fopen($path,"r");
			if ($fp){
				if (filesize($path) == 0) $file = "";
				else $file = fread($fp,filesize($path));
				fclose($fp);
				$message_part = "Content-Type: application/octet-stream";
				$message_part .= "; name = \"$filename\"\n";
				$message_part .= "Content-Transfer-Encoding: base64\n";
				$message_part .= "Content-Disposition: attachment; filename = \"".$path."\"\n\n";
				$message_part .= chunk_split(base64_encode($file))."\n\n";
				$multipart .= "--$boundary\n".$message_part;
				unlink($path);
			} // END IF #2
		}
	} // END WHILE
	$multipart .= "--$boundary--\n";
 
	if (mail("[email protected]","BackUp",$multipart,$headers))
		return "Message sent.";
	else return "Error sending.";
}
 
$content = "
     <div class=\"logStyle\">
      <h2>Backup</h2>";
 
 
if (isset($_GET['s']) && !empty($_GET['s'])){
	$start = intval($_GET['s']);
	//&& isset($_GET['t']) && !empty($_GET['t'])
	//$table = htmlspecialchars($_GET['t'], ENT_QUOTES);
	$content .= copydb($parse,$start);
} elseif (isset($_POST['step_1']) && isset($_POST['servername']) && !empty($_POST['servername'])){
	$backup_fp = fopen(TMP_CFG,"w");
	$backup_server = htmlspecialchars($_POST['servername'], ENT_QUOTES);
	fwrite($backup_fp,$backup_server); // Первая строка во временном конфиге
	fclose($backup_fp);
	header("Refresh: 0;");
} elseif (file_exists(TMP_CFG)){
	if (isset($_POST['step_2']) && isset($_POST['user_db']) && isset($_POST['pass_db']) && !empty($_POST['user_db'])){
		$backup_fp = fopen(TMP_CFG,"a");
		$backup_lp = $_POST['user_db']."\n".$_POST['pass_db'];
		fwrite($backup_fp,"\n".$backup_lp); // Вторая и третья строки
		fclose($backup_fp);
 
		// Подключение к серверу и выбор базы для копирования
		$backup_fp = fopen(TMP_CFG,"r");
		$backup_data = fread($backup_fp,filesize(TMP_CFG));
		fclose($backup_fp);
		$backup_data = explode("\n",$backup_data);
		$backup_servername = $backup_data[0];
		$backup_login = $backup_data[1];
		$backup_password = $backup_data[2];
		$backup_conn = @mysql_connect($backup_servername,$backup_login,$backup_password);
		if (!$backup_conn){
			// Если неверный логин/пароль - то удаляем их из файла, тем самым попадаем на их ввод.
			$backup_fp = fopen(TMP_CFG,"w");
			fwrite($backup_fp,$backup_servername);
			fclose($backup_fp);
			header("Refresh: 5;");
			die("Could not connect: <b>Неверный логин или пароль.</b> <i>Страница перезагрузится автоматически через 5 секунд.</i>");
		} else {
			$backup_dbs = @mysql_list_dbs($backup_conn);
			$content .= "
      <form method=\"post\" action='".$_SERVER['PHP_SELF']."'>
       <h4>База данный для копирования:</h4>
       <div><select name=\"name_db\">
        <option>--</option>";
			while ($backup_db_name = mysql_fetch_object($backup_dbs)){
				$content .= "
        <option value='".$backup_db_name->Database."'"; if(isset($backup_dbname) && $backup_db_name->Database == $backup_dbname) $content .= " selected"; $content .= ">".$backup_db_name->Database."</option>";
			}
			$content .= "
       </select>
       <input type=\"checkbox\" name=\"copy_struct\" value=\"1\"><i>Копировать структуру базы.</i></div><br />
       <input type=\"submit\" name=\"step_3\" value=\"Ñîõðàíèòü\">
      </form>";
		}
	// 
	} elseif (isset($_POST['step_3']) && isset($_POST['name_db']) && !empty($_POST['name_db'])){
		$backup_fp = fopen(TMP_CFG,"a");
		fwrite($backup_fp,"\n".$_POST['name_db']); // и последнее - название бд
		fclose($backup_fp);
		$backup_fp = fopen(TMP_CFG,"r"); // после этого считываем все что есть во временном файле
		$backup_data = fread($backup_fp,filesize(TMP_CFG));
		fclose($backup_fp);
		$backup_str = explode("\n",$backup_data);
 
		$backup_servername = $backup_str[0];
		$backup_login = $backup_str[1]; 
		$backup_password = $backup_str[2];
		$backup_dbname = $backup_str[3];
 
		$backup_fp = fopen(CONFIG,"w"); //  и создаем конфиг-файл (.php)
		$backup_write = '<?php'."\n".'$backup_servername = "'.$backup_servername.'";'."\n".'$backup_login = "'.$backup_login.'";'."\n".'$backup_password = "'.$backup_password.'";'."\n".'$backup_dbname = "'.$backup_dbname.'";'."\n".'?>';
		fwrite($backup_fp,$backup_write);
		fclose($backup_fp);
		unlink(TMP_CFG);
 
		include("backup_cnt.php");
		//
		$backup_ft = fopen(FILE_TABLES,"w");
		$tables = mysql_list_tables($backup_dbname); // список таблиц
		for ($i_wf = 0; $i_wf < mysql_num_rows($tables) - 1; $i_wf++){
			$table = mysql_tablename($tables,$i_wf);
			fwrite($backup_ft,$table."\n");
		}
		fwrite($backup_ft,mysql_tablename($tables,mysql_num_rows($tables) - 1));
		mysql_free_result($tables);
		fclose($backup_ft);
		mysql_close($backup_conn);
		if (isset($_POST['copy_struct'])) $content .= structuredb();
		else $content .= copydb($parse,"");
 
	} else {
		$backup_fp = fopen(TMP_CFG,"r");
		$backup_data = fread($backup_fp,filesize(TMP_CFG));
		fclose($backup_fp);
		$backup_count_str = count(explode("\n",$backup_data));
		if ($backup_count_str == 1){
		// Переменные $backup_login/$backup_password получаются из существующего конфиг-файла (если он существует).
			$content .= "
      <form method=\"post\" action='".$_SERVER['PHP_SELF']."'>
       <h4>Login:</h4><input type=\"text\" name=\"user_db\" value=\"".$backup_login."\">
       <h4>Password:</h4><input type=\"text\" name=\"pass_db\" value=\"".$backup_password."\">
       <input type=\"submit\" name=\"step_2\" value=\"Save\">
      </form>";
		} else {
			unlink(TMP_CFG);
			if (file_exists(CONFIG)) unlink(CONFIG);
			header("Refresh: 0;");
		}
	}
// После копирования структуры бд
} elseif (isset($_POST['nextstep'])){
	$content .= copydb($parse,"");
// Удаление найденного конфига
} elseif (isset($_POST['deleteconfig'])){
	unlink(CONFIG);
	header("Refresh: 0;");
} else {
	if (file_exists(CONFIG)){
		$content .= "<h4>Найдет файл конфигурации:</h4>";
		$content .= "<b>Server Name: </b>".$backup_servername."<br>";
		$content .= "<b>Login: </b>".$backup_login."<br>";
		$content .= "<b>Password: </b>".$backup_password."<br>";
		$content .= "<b>DB Name: </b>".$backup_dbname."<br>";
		$content .= "<hr><form method=\"post\" action='".$_SERVER['PHP_SELF']."'><input type=\"submit\" name=\"deleteconfig\" value=\"Delete\"></form>";
	}
	$content .= "
      <form method=\"post\" action='".$_SERVER['PHP_SELF']."'>
       <h4>Name server:</h4><input type=\"text\" name=\"servername\" value=\"$backup_servername\">
       <input type=\"submit\" name=\"step_1\" value=\"Next\">
      </form>";
}
$content .= "</div>";
getPage($content,"");
?>
Report this snippet Tweet
Comment:
You need to login to post a comment.
Posted By

Tagged

Versions (?)

Backup

Related snippets

Choose a language for easy browsing:
