PHP code: backup and restore sql database_PHP tutorial-PHP Tutorial-php.cn

PHP code: backup and restore sql database_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Release： 2016-07-13 17:31:21

Original

1359 people have browsed it

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 = & GT; Array ());
}
$ Index [$ kname] [columns] [] = $ keys [column_name];
}
While (List ($ kname, $info) = each($index)) {
                     $schema .= , . " ", $schema .= Prima
(The most complete virtual host management system)
RY KEY ( . $columns . );
} elseif ($info[unique]) { . $kname . ( . $columns . );                                                                              }
                 $schema. = " " . ); . " "; // Dump the data
$rows_query = tep_db_query("select " . implode(,, $table_list) . " from " . $table); array ($rows_query)) {
                         $schema_insert = insert into . $table . ( . i

http://www.bkjia.com/PHPjc/509088.html

www.bkjia.com

true

http: //www.bkjia.com/PHPjc/509088.html

TechArticle