当前页面位置: » 丰搜网 » 文档中心 » 详细内容
一段php代码：备份、恢复sql数据库（支持sql文本，zip。。。）
php代码:--------------------------------------------------------------------------------
<?php
require('includes/application_top.php');
if ($http_get_vars['action']) {
switch ($http_get_vars['action']) {
case 'forget':
tep_db_query("delete from " . table_configuration . " where configuration_key = 'db_last_restore'");
$messagestack->add_session(success_last_restore_cleared, 'success');
tep_redirect(tep_href_link(filename_backup));
break;
case 'backupnow':
tep_set_time_limit(0);
$schema = '# citespa, open source e-commerce solutions' . "\n" .
'# <a href="http://www.xxxxxx.com" target="_blank">http://www.xxxxxx.com</a>' . "\n" .
'#' . "\n" .
'# database backup for ' . store_name . "\n" .
'# copyright (c) ' . date('y') . ' ' . store_owner . "\n" .
'#' . "\n" .
'# database: ' . db_database . "\n" .
'# database server: ' . db_server . "\n" .
'#' . "\n" .
'# backup date: ' . date(php_date_time_format) . "\n\n";
$tables_query = tep_db_query('show tables');
while ($tables = tep_db_fetch_array($tables_query)) {
list(,$table) = each($tables);
$schema .= 'drop table if exists ' . $table . ';' . "\n" .
'create table ' . $table . ' (' . "\n";
$table_list = array();
$fields_query = tep_db_query("show fields from " . $table);
while ($fields = tep_db_fetch_array($fields_query)) {
$table_list[] = $fields['field'];
$schema .= ' ' . $fields['field'] . ' ' . $fields['type'];
if (strlen($fields['default']) > 0) $schema .= ' default '' . $fields['default'] . ''';
if ($fields['null'] != 'yes') $schema .= ' not null';
if (isset($fields['extra'])) $schema .= ' ' . $fields['extra'];
$schema .= ',' . "\n";
}
$schema = ereg_replace(",\n$", '', $schema);
// add the keys
$index = array();
$keys_query = tep_db_query("show keys from " . $table);
while ($keys = tep_db_fetch_array($keys_query)) {
$kname = $keys['key_name'];
if (!isset($index[$kname])) {
$index[$kname] = array('unique' => !$keys['non_unique'],
'columns' => array());
}
$index[$kname]['columns'][] = $keys['column_name'];
}
while (list($kname, $info) = each($index)) {
$schema .= ',' . "\n";
$columns = implode($info['columns'], ', ');
if ($kname == 'primary') {
$schema .= ' primary key (' . $columns . ')';
} elseif ($info['unique']) {
$schema .= ' unique ' . $kname . ' (' . $columns . ')';
} else {
$schema .= ' key ' . $kname . ' (' . $columns . ')';
}
}
$schema .= "\n" . ');' . "\n\n";
// dump the data
$rows_query = tep_db_query("select " . implode(',', $table_list) . " from " . $table);
while ($rows = tep_db_fetch_array($rows_query)) {
$schema_insert = 'insert into ' . $table . ' (' . implode(', ', $table_list) . ') values (';
reset($table_list);
while (list(,$i) = each($table_list)) {
if (!isset($rows[$i])) {
$schema_insert .= 'null, ';
} elseif ($rows[$i] != '') {
$row = addslashes($rows[$i]);
$row = ereg_replace("\n#", "\n".'#', $row);
$schema_insert .= ''' . $row . '', ';
} else {
$schema_insert .= ''', ';
}
}
$schema_insert = ereg_replace(', $', '', $schema_insert) . ');' . "\n";
$schema .= $schema_insert;
}
$schema .= "\n";
}
if ($http_post_vars['download'] == 'yes') {
$backup_file = 'db_' . db_database . '-' . date('ymdhis') . '.sql';
switch ($http_post_vars['compress']) {
case 'no':
header('content-type: application/x-octet-stream');
header('content-disposition: attachment; filename=' . $backup_file);
echo $schema;
exit;
break;
case 'gzip':
if ($fp = fopen(dir_fs_backup . $backup_file, 'w')) {
fputs($fp, $schema);
fclose($fp);
exec(local_exe_gzip . ' ' . dir_fs_backup . $backup_file);
$backup_file .= '.gz';
}
if ($fp = fopen(dir_fs_backup . $backup_file, 'rb')) {
$buffer = fread($fp, filesize(dir_fs_backup . $backup_file));
fclose($fp);
unlink(dir_fs_backup . $backup_file);
header('content-type: application/x-octet-stream');
header('content-disposition: attachment; filename=' . $backup_file);
echo $buffer;
exit;
}
break;
case 'zip':
if ($fp = fopen(dir_fs_backup . $backup_file, 'w')) {
fputs($fp, $schema);
fclose($fp);
exec(local_exe_zip . ' -j ' . dir_fs_backup . $backup_file . '.zip ' . dir_fs_backup . $backup_file);
unlink(dir_fs_backup . $backup_file);
$backup_file .= '.zip';
}
if ($fp = fopen(dir_fs_backup . $backup_file, 'rb')) {
$buffer = fread($fp, filesize(dir_fs_backup . $backup_file));
fclose($fp);
unlink(dir_fs_backup . $backup_file);
header('content-type: application/x-octet-stream');
header('content-disposition: attachment; filename=' . $backup_file);
echo $buffer;
exit;
}
}
} else {
$backup_file = dir_fs_backup . 'db_' . db_database . '-' . date('ymdhis') . '.sql';
if ($fp = fopen($backup_file, 'w')) {
fputs($fp, $schema);
fclose($fp);
switch ($http_post_vars['compress']) {
case 'gzip':
exec(local_exe_gzip . ' ' . $backup_file);
break;
case 'zip':
exec(local_exe_zip . ' -j ' . $backup_file . '.zip ' . $backup_file);
unlink($backup_file);
}
}
$messagestack->add_session(success_database_saved, 'success');
tep_redirect(tep_href_link(filename_backup));
}
break;
case 'restorenow':
case 'restorelocalnow':
tep_set_time_limit(0);
if ($http_get_vars['action'] == 'restorenow') {
$read_from = $http_get_vars['file'];
if (file_exists(dir_fs_backup . $http_get_vars['file'])) {
$restore_file = dir_fs_backup . $http_get_vars['file'];
$extension = substr($http_get_vars['file'], -3);
if ( ($extension == 'sql') ($extension == '.gz') ($extension == 'zip') ) {
switch ($extension) {
case 'sql':
$restore_from = $restore_file;
$remove_raw = false;
break;
case '.gz':
$restore_from = substr($restore_file, 0, -3);
exec(local_exe_gunzip . ' ' . $restore_file . ' -c > ' . $restore_from);
$remove_raw = true;
break;
case 'zip':
$restore_from = substr($restore_file, 0, -4);
exec(local_exe_unzip . ' ' . $restore_file . ' -d ' . dir_fs_backup);
$remove_raw = true;
}
if ( ($restore_from) && (file_exists($restore_from)) && (filesize($restore_from) > 15000) ) {
$fd = fopen($restore_from, 'rb');
$restore_query = fread($fd, filesize($restore_from));
fclose($fd);
}
}
}
} elseif ($http_get_vars['action'] == 'restorelocalnow') {
if ($http_post_files['sql_file']) {
$uploaded_file = $http_post_files['sql_file']['tmp_name'];
$read_from = basename($http_post_files['sql_file']['name']);
} elseif ($http_post_vars['sql_file']) {
$uploaded_file = $http_post_vars['sql_file'];
$read_from = basename($http_post_vars['sql_file_name']);
} else {
$uploaded_file = $sql_file;
$read_from = basename($sql_file_name);
}
if ($uploaded_file != 'none') {
if (tep_is_uploaded_file($uploaded_file)) {
$restore_query = fread(fopen($uploaded_file, 'r'), filesize($uploaded_file));
}
}
}
if ($restore_query) {
$sql_array = array();
$sql_length = strlen($restore_query);
$pos = strpos($restore_query, ';');
for ($i=$pos; $i<$sql_length; $i++) {
if ($restore_query[0] == '#') {
$restore_query = ltrim(substr($restore_query, strpos($restore_query, "\n")));
$sql_length = strlen($restore_query);
$i = strpos($restore_query, ';')-1;
continue;
}
if ($restore_query[($i+1)] == "\n") {
for ($j=($i+2); $j<$sql_length; $j++) {
if (trim($restore_query[$j]) != '') {
$next = substr($restore_query, $j, 6);
if ($next[0] == '#') {
// find out where the break position is so we can remove this line (#comment line)
for ($k=$j; $k<$sql_length; $k++) {
if ($restore_query[$k] == "\n") break;
}
$query = substr($restore_query, 0, $i+1);
$restore_query = substr($restore_query, $k);
// join the query before the comment appeared, with the rest of the dump
$restore_query = $query . $restore_query;
$sql_length = strlen($restore_query);
$i = strpos($restore_query, ';')-1;
continue 2;
}
break;
}
}
if ($next == '') { // get the last insert query
$next = 'insert';
}
if ( (eregi('create', $next)) (eregi('insert', $next)) (eregi('drop t', $next)) ) {
$next = '';
$sql_array[] = substr($restore_query, 0, $i);
$restore_query = ltrim(substr($restore_query, $i+1));
$sql_length = strlen($restore_query);
$i = strpos($restore_query, ';')-1;
}
}
}
$tables_query = tep_db_query('show tables');
while ($tables = tep_db_fetch_array($tables_query)) {
list(,$table) = each($tables);
tep_db_query("drop table " . $table);
}
for ($i=0; $i<sizeof($sql_array); $i++) {
tep_db_query($sql_array[$i]);
}
tep_db_query("delete from " . table_configuration . " where configuration_key = 'db_last_restore'");
tep_db_query("insert into " . table_configuration . " values ('', 'last database restore', 'db_last_restore', '" . $read_from . "', 'last database restore file', '6', '', '', now(), '', '')");
if ($remove_raw) {
unlink($restore_from);
}
}
$messagestack->add_session(success_database_restored, 'success');
tep_redirect(tep_href_link(filename_backup));
break;
case 'download':
$extension = substr($http_get_vars['file'], -3);
if ( ($extension == 'zip') ($extension == '.gz') ($extension == 'sql') ) {
if ($fp = fopen(dir_fs_backup . $http_get_vars['file'], 'rb')) {
$buffer = fread($fp, filesize(dir_fs_backup . $http_get_vars['file']));
fclose($fp);
header('content-type: application/x-octet-stream');
header('content-disposition: attachment; filename=' . $http_get_vars['file']);
echo $buffer;
exit;
}
} else {
$messagestack->add(error_download_link_not_acceptable, 'error');
}
break;
case 'deleteconfirm':
if (strstr($http_get_vars['file'], '..')) tep_redirect(tep_href_link(filename_backup));
tep_remove(dir_fs_backup . '/' . $http_get_vars['file']);
if (!$tep_remove_error) {
$messagestack->add_session(success_backup_deleted, 'success');
tep_redirect(tep_href_link(filename_backup));
}
break;
}
}
// check if the backup directory exists
$dir_ok = false;
if (is_dir(dir_fs_backup)) {
$dir_ok = true;
if (!is_writeable(dir_fs_backup)) $messagestack->add(error_backup_directory_not_writeable, 'error');
} else {
$messagestack->add(error_backup_directory_does_not_exist, 'error');
}
?>
<html <?php echo html_params; ?>>
<head>
<meta http-equiv="content-type" content="text/html; charset=<?php echo charset; ?>">
<title><?php echo title; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#ffffff">
<!-- header //-->
<?php require(dir_ws_includes . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php echo box_width; ?>" valign="top"><table border="0" width="<?php echo box_width; ?>" cellspacing="1" cellpadding="1" class="columnleft">
<!-- left_navigation //-->
<?php require(dir_ws_includes . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageheading"><?php echo heading_title; ?></td>
<td class="pageheading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', heading_image_width, heading_image_height); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="datatableheadingrow">
<td class="datatableheadingcontent"><?php echo table_heading_title; ?></td>
<td class="datatableheadingcontent" align="center"><?php echo table_heading_file_date; ?></td>
<td class="datatableheadingcontent" align="right"><?php echo table_heading_file_size; ?></td>
<td class="datatableheadingcontent" align="right"><?php echo table_heading_action; ?> </td>
</tr>
<?php
if ($dir_ok) {
$dir = dir(dir_fs_backup);
$contents = array();
while ($file = $dir->read()) {
if (!is_dir(dir_fs_backup . $file)) {
$contents[] = $file;
}
}
sort($contents);
for ($files=0; $files<sizeof($contents); $files++) {
$entry = $contents[$files];
$check = 0;
if (((!$http_get_vars['file']) ($http_get_vars['file'] == $entry)) && (!$buinfo) && ($http_get_vars['action'] != 'backup') && ($http_get_vars['action'] != 'restorelocal')) {
$file_array['file'] = $entry;
$file_array['date'] = date(php_date_time_format, filemtime(dir_fs_backup . $entry));
$file_array['size'] = number_format(filesize(dir_fs_backup . $entry)) . ' bytes';
switch (substr($entry, -3)) {
case 'zip': $file_array['compression'] = 'zip'; break;
case '.gz': $file_array['compression'] = 'gzip'; break;
default: $file_array['compression'] = text_no_extension; break;
}
$buinfo = new objectinfo($file_array);
}
if (is_object($buinfo) && ($entry == $buinfo->file)) {
echo ' <tr class="datatablerowselected" onmouseover="this.style.cursor='hand'">' . "\n";
$onclick_link = 'file=' . $buinfo->file . '&action=restore';
} else {
echo ' <tr class="datatablerow" onmouseover="this.classname='datatablerowover';this.style.cursor='hand'" onmouseout="this.classname='datatablerow'">' . "\n";
$onclick_link = 'file=' . $entry;
}
?>
<td class="datatablecontent" onclick="document.location.href='<?php echo tep_href_link(filename_backup, $onclick_link); ?>'"><?php echo '<a href="' . tep_href_link(filename_backup, 'action=download&file=' . $entry) . '">' . tep_image(dir_ws_icons . 'file_download.gif', icon_file_download) . '</a> ' . $entry; ?></td>
<td class="datatablecontent" align="center" onclick="document.location.href='<?php echo tep_href_link(filename_backup, $onclick_link); ?>'"><?php echo date(php_date_time_format, filemtime(dir_fs_backup . $entry)); ?></td>
<td class="datatablecontent" align="right" onclick="document.location.href='<?php echo tep_href_link(filename_backup, $onclick_link); ?>'"><?php echo number_format(filesize(dir_fs_backup . $entry)); ?> bytes</td>
<td class="datatablecontent" align="right"><?php if ( (is_object($buinfo)) && ($entry == $buinfo->file) ) { echo tep_image(dir_ws_images . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(filename_backup, 'file=' . $entry) . '">' . tep_image(dir_ws_images . 'icon_info.gif', image_icon_info) . '</a>'; } ?> </td>
</tr>
<?php
}
$dir->close();
}
?>
<tr>
<td class="smalltext" colspan="3"><?php echo text_backup_directory . ' ' . dir_fs_backup; ?></td>
<td align="right" class="smalltext"><?php if ( ($http_get_vars['action'] != 'backup') && ($dir) ) echo '<a href="' . tep_href_link(filename_backup, 'action=backup') . '">' . tep_image_button('button_backup.gif', image_backup) . '</a>'; if ( ($http_get_vars['action'] != 'restorelocal') && ($dir) ) echo ' <a href="' . tep_href_link(filename_backup, 'action=restorelocal') . '">' . tep_image_button('button_restore.gif', image_restore) . '</a>'; ?></td>
</tr>
<?php
if (defined('db_last_restore')) {
?>
<tr>
<td class="smalltext" colspan="4"><?php echo text_last_restoration . ' ' . db_last_restore . ' <a href="' . tep_href_link(filename_backup, 'action=forget') . '">' . text_forget . '</a>'; ?></td>
</tr>
<?php
}
?>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($http_get_vars['action']) {
case 'backup':
$heading[] = array('text' => '<b>' . text_info_heading_new_backup . '</b>');
$contents = array('form' => tep_draw_form('backup', filename_backup, 'action=backupnow'));
$contents[] = array('text' => text_info_new_backup);
if ($messagestack->size > 0) {
$contents[] = array('text' => '<br>' . tep_draw_radio_field('compress', 'no', true) . ' ' . text_info_use_no_compression);
$contents[] = array('text' => '<br>' . tep_draw_radio_field('download', 'yes', true) . ' ' . text_info_download_only . '*<br><br>*' . text_info_best_through_https);
} else {
$contents[] = array('text' => '<br>' . tep_draw_radio_field('compress', 'gzip', true) . ' ' . text_info_use_gzip);
$contents[] = array('text' => tep_draw_radio_field('compress', 'zip') . ' ' . text_info_use_zip);
$contents[] = array('text' => tep_draw_radio_field('compress', 'no') . ' ' . text_info_use_no_compression);
$contents[] = array('text' => '<br>' . tep_draw_checkbox_field('download', 'yes') . ' ' . text_info_download_only . '*<br><br>*' . text_info_best_through_https);
}
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_backup.gif', image_backup) . ' <a href="' . tep_href_link(filename_backup) . '">' . tep_image_button('button_cancel.gif', image_cancel) . '</a>');
break;
case 'restore':
$heading[] = array('text' => '<b>' . $buinfo->date . '</b>');
$contents[] = array('text' => tep_break_string(sprintf(text_info_restore, dir_fs_backup . (($buinfo->compression != text_no_extension) ? substr($buinfo->file, 0, strrpos($buinfo->file, '.')) : $buinfo->file), ($buinfo->compression != text_no_extension) ? text_info_unpack : ''), 35, ' '));
$contents[] = array('align' => 'center', 'text' => '<br><a href="' . tep_href_link(filename_backup, 'file=' . $buinfo->file . '&action=restorenow') . '">' . tep_image_button('button_restore.gif', image_restore) . '</a> <a href="' . tep_href_link(filename_backup, 'file=' . $buinfo->file) . '">' . tep_image_button('button_cancel.gif', image_cancel) . '</a>');
break;
case 'restorelocal':
$heading[] = array('text' => '<b>' . text_info_heading_restore_local . '</b>');
$contents = array('form' => tep_draw_form('restore', filename_backup, 'action=restorelocalnow', 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => text_info_restore_local . '<br><br>' . text_info_best_through_https);
$contents[] = array('text' => '<br>' . tep_draw_file_field('sql_file'));
$contents[] = array('text' => text_info_restore_local_raw_file);
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_restore.gif', image_restore) . ' <a href="' . tep_href_link(filename_backup) . '">' . tep_image_button('button_cancel.gif', image_cancel) . '</a>');
break;
case 'delete':
$heading[] = array('text' => '<b>' . $buinfo->date . '</b>');
$contents = array('form' => tep_draw_form('delete', filename_backup, 'file=' . $buinfo->file . '&action=deleteconfirm'));
$contents[] = array('text' => text_delete_intro);
$contents[] = array('text' => '<br><b>' . $buinfo->file . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', image_delete) . ' <a href="' . tep_href_link(filename_backup, 'file=' . $buinfo->file) . '">' . tep_image_button('button_cancel.gif', image_cancel) . '</a>');
break;
default:
if (is_object($buinfo)) {
$heading[] = array('text' => '<b>' . $buinfo->date . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(filename_backup, 'file=' . $buinfo->file . '&action=restore') . '">' . tep_image_button('button_restore.gif', image_restore) . '</a> <a href="' . tep_href_link(filename_backup, 'file=' . $buinfo->file . '&action=delete') . '">' . tep_image_button('button_delete.gif', image_delete) . '</a>');
$contents[] = array('text' => '<br>' . text_info_date . ' ' . $buinfo->date);
$contents[] = array('text' => text_info_size . ' ' . $buinfo->size);
$contents[] = array('text' => '<br>' . text_info_compression . ' ' . $buinfo->compression);
}
break;
}
if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infobox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(dir_ws_includes . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(dir_ws_includes . 'application_bottom.php'); ?>
