论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2005-03-25 17:26 |只看该作者 |倒序浏览

php代码：备份、恢复sql数据库
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' . "
" .
               '# http://www.XXXXXX.com' . "
" .
               '#' . "
" .
               '# Database Backup For ' . STORE_NAME . "
" .
               '# Copyright (c) ' . date('Y') . ' ' . STORE_OWNER . "
" .
               '#' . "
" .
               '# Database: ' . DB_DATABASE . "
" .
               '# Database Server: ' . DB_SERVER . "
" .
               '#' . "
" .
               '# Backup Date: ' . date(PHP_DATE_TIME_FORMAT) . "
";
      $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 . ';' . "
" .
                  'create table ' . $table . ' (' . "
";
      $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 .= ',' . "
";
      }
      $schema = ereg_replace(",
$", '', $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 .= ',' . "
";
         $columns = implode($info['columns'], ', ');
         if ($kname == 'PRIMARY') {
            $schema .= '  PRIMARY KEY (' . $columns . ')';
         } elseif ($info['unique']) {
            $schema .= '  UNIQUE ' . $kname . ' (' . $columns . ')';
         } else {
            $schema .= '  KEY ' . $kname . ' (' . $columns . ')';
         }
      }
      $schema .= "
" . ');' . "
";
      // 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("
#", "
".'#', $row);
            $schema_insert .= ''' . $row . '', ';
            } else {
            $schema_insert .= ''', ';
            }
         }
         $schema_insert = ereg_replace(', $', '', $schema_insert) . ');' . "
";
         $schema .= $schema_insert;
      }
      $schema .= "
";
      }
      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; $iadd_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');
  }
?>
>
">

" valign="top">" cellspacing="1" cellpadding="1" class="columnLeft">

















             

read()) {
   if (!is_dir(DIR_FS_BACKUP . $file)) {
      $contents[] = $file;
   }
}
sort($contents);
for ($files=0; $filesfile)) {
      echo '             ' . "
";
      $onclick_link = 'file=' . $buInfo->file . '&action=restore';
   } else {
      echo '             ' . "
";
      $onclick_link = 'file=' . $entry;
   }
?>
            '">' . tep_image(DIR_WS_ICONS . 'file_download.gif', ICON_FILE_DOWNLOAD) . ' ' . $entry; ?>
            '">
            '"> bytes
            file) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?> 

close();
  }
?>


            ' . tep_image_button('button_backup.gif', IMAGE_BACKUP) . ''; if ( ($HTTP_GET_VARS['action'] != 'restorelocal') && ($dir) ) echo '  ' . tep_image_button('button_restore.gif', IMAGE_RESTORE) . ''; ?>


            ' . TEXT_FORGET . ''; ?>


'' . TEXT_INFO_HEADING_NEW_BACKUP . '');
   $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' => '
' . tep_draw_radio_field('compress', 'no', true) . ' ' . TEXT_INFO_USE_NO_COMPRESSION);
      $contents[] = array('text' => '
' . tep_draw_radio_field('download', 'yes', true) . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*
*' . TEXT_INFO_BEST_THROUGH_HTTPS);
   } else {
      $contents[] = array('text' => '
' . 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' => '
' . tep_draw_checkbox_field('download', 'yes') . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*
*' . TEXT_INFO_BEST_THROUGH_HTTPS);
   }
   $contents[] = array('align' => 'center', 'text' => '
' . tep_image_submit('button_backup.gif', IMAGE_BACKUP) . ' ' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '');
   break;
case 'restore':
   $heading[] = array('text' => '' . $buInfo->date . '');
   $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' => '
file . '&action=restorenow') . '">' . tep_image_button('button_restore.gif', IMAGE_RESTORE) . ' file) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '');
   break;
case 'restorelocal':
   $heading[] = array('text' => '' . TEXT_INFO_HEADING_RESTORE_LOCAL . '');
   $contents = array('form' => tep_draw_form('restore', FILENAME_BACKUP, 'action=restorelocalnow', 'post', 'enctype="multipart/form-data"'));
   $contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL . '
' . TEXT_INFO_BEST_THROUGH_HTTPS);
   $contents[] = array('text' => '
' . tep_draw_file_field('sql_file'));
   $contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL_RAW_FILE);
   $contents[] = array('align' => 'center', 'text' => '
' . tep_image_submit('button_restore.gif', IMAGE_restore) . ' ' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '');
   break;
case 'delete':
   $heading[] = array('text' => '' . $buInfo->date . '');
   $contents = array('form' => tep_draw_form('delete', FILENAME_BACKUP, 'file=' . $buInfo->file . '&action=deleteconfirm'));
   $contents[] = array('text' => TEXT_DELETE_INTRO);
   $contents[] = array('text' => '
' . $buInfo->file . '');
   $contents[] = array('align' => 'center', 'text' => '
' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' file) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '');
   break;
default:
   if (is_object($buInfo)) {
      $heading[] = array('text' => '' . $buInfo->date . '');
      $contents[] = array('align' => 'center', 'text' => 'file . '&action=restore') . '">' . tep_image_button('button_restore.gif', IMAGE_RESTORE) . ' file . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '');
      $contents[] = array('text' => '
' . TEXT_INFO_DATE . ' ' . $buInfo->date);
      $contents[] = array('text' => TEXT_INFO_SIZE . ' ' . $buInfo->size);
      $contents[] = array('text' => '
' . TEXT_INFO_COMPRESSION . ' ' . $buInfo->compression);
   }
   break;
  }
  if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
echo '          ' . "
";
$box = new box;
echo $box->infoBox($heading, $contents);
echo '          ' . "
";
  }
?>






本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/3876/showart_17728.html

文库|博客

返回列表

Chinaunix › 论坛 › 操作系统 › Linux新手园地 › Linux文档专区 › php代码：备份、恢复sql数据库

php代码：备份、恢复sql数据库 [复制链接]