|
|
|
一段php代码：备份、恢复sql数据库（支持sql文本，zip。。。
作者:佚名 来源:本站教程 点击: 日期:2007-01-11 |
|
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 . $HTT
|
|
|
|
【文章评论】
【收藏本文】
【推荐好友】
【打印本文】
【论坛讨论】 |
 相关文章: |
|
|
文章评论:(条) |
|
|
|
|
责任编辑:一分 声明：刊登此文章是为了传递更多信息,文章内容仅供参考,转载请注明出处。 |
|
设为主页
收藏本站
