当前位置：首页 » 软件开发

开发技术指南» 文章正文

    引言： php代码：备份、恢复sql数据库require(include

 

 

php代码：备份、恢复sql数据库
php代码:备份.恢复sql数据库

require(includes/application_top.php);

【程序编程相关:永远的英雄无敌 永远的3DO】

【推荐阅读:LINUX文件系统集成以及常用命令整合】

  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]) {

...   下一页

» 本期热门文章：

· 热门栏目：

» 相关精选文章

» 其它相关：