程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> 關於PHP編程 >> php代碼:備份、恢復sql數據庫

php代碼:備份、恢復sql數據庫

編輯:關於PHP編程

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 . " " .
                  # <a href="http://www.XXXXXX.com" target="_blank">http://www.XXXXXX.com</a> . " " .
                  # . " " .
                  # 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 == Prima(最完善的虛擬主機管理系統)RY) {
              $schema .=   Prima(最完善的虛擬主機管理系統)RY 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 . ( . i

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved