<?php/** * 描述:基于ThinkPHP框架的Mysql數(shù)據(jù)庫導(dǎo)出類 * 日期:2012-07-15 * 作者:龔辟愚 */class DBExport{  /**   * @description 獲取當(dāng)前數(shù)據(jù)庫的所有表名。   * @static   * @return array   */  static protected function getTables()  {    $dbName=C('DB_NAME');    $result=M()->query("SHOW FULL TABLES FROM `{$dbName}` WHERE Table_Type = 'BASE TABLE'");    foreach ($result as $v){      $tbArray[]=$v['Tables_in_'.C('DB_NAME')];    }    return $tbArray;  }  static protected function getViews()  {    $dbName=C('DB_NAME');    $result=M()->query("SHOW FULL TABLES FROM `{$dbName}` WHERE Table_Type = 'VIEW'");    foreach ($result as $v){      $tbArray[]=$v['Tables_in_'.C('DB_NAME')];    }    return $tbArray;  }  /**   * @description 導(dǎo)出SQL數(shù)據(jù)，但不包含表創(chuàng)建代碼。   * @static   * @return string   */  static public function ExportAllData()  {    $tables = self::getTables();    $arrAll = array(      "SET FOREIGN_KEY_CHECKS=0;",      self::BuildAllTriggerDropSql(),      self::BuildTableSql(),      self::BuildViewSql()    );    $tbl = new Model();    foreach($tables as $table)    {      $arrAll[]="/r/nDELETE FROM {$table};";      /*      $rs = $tbl->query("SHOW COLUMNS FROM {$table}");      $arrFields = array();      foreach ($rs as $k=>&$v){        $arrFields[] = "`{$v['Field']}`";      }      $sqlFields = implode($arrFields,",");      */      $rs=$tbl->query("select * from `{$table}`");      foreach ($rs as $k=>&$v){        $arrValues = array();        foreach($v as $key=>$val)        {          if(is_numeric($val)){            $arrValues[]=$val;          }else if(is_null($val)){            $arrValues[]='NULL';          }else{            $arrValues[]="'".addslashes($val)."'";          }        }        $arrAll[] = "INSERT INTO `{$table}` VALUES (".implode(',',$arrValues).");";      }    }    $arrAll[]=self::BuildTriggerCreateSql();    return implode("/r/n",$arrAll);  }  static protected function BuildTableSql()  {    $tables = self::getTables();    $arrAll = array();    foreach($tables as &$val){      $rs = M()->query("SHOW CREATE TABLE `{$val}`");      $tbSql = preg_replace("#CREATE(.*)//s+TABLE#","CREATE TABLE",$rs[0]['Create Table']);      $arrAll[] = "DROP TABLE IF EXISTS `{$rs[0]['Table']}`;/r/n{$tbSql};/r/n";    }    return implode("/r/n",$arrAll);  }  static protected function BuildViewSql()  {    $views = self::getViews();    $arrAll = array();    foreach($views as &$val){      $rs = M()->query("SHOW CREATE VIEW `{$val}`");      $tbSql = preg_replace("#CREATE(.*)//s+VIEW#","CREATE VIEW",$rs[0]['Create View']);      $arrAll[] = "DROP VIEW IF EXISTS `{$rs[0]['View']}`;/r/n{$tbSql};/r/n";    }    return implode("/r/n",$arrAll);  }  /**   * @description 如果存在觸發(fā)器，生成刪除代碼。原因是:插入數(shù)據(jù)的時(shí)候可能會(huì)受到觸發(fā)器影響。   * @static   * @return string   */  static public function BuildAllTriggerDropSql()  {    $rs = M()->query("show triggers");    $arrAll = array();    foreach ($rs as $k=>&$v)    {      $arrSql = array(        'DROP TRIGGER IF EXISTS `',$v['Trigger'],'`;'      );      $arrAll[] = implode('',$arrSql);    }    return implode("/r/n",$arrAll);  }  /**   * @description 生成所有觸發(fā)器的創(chuàng)建代碼。   * @static   * @return string   */  static protected function BuildTriggerCreateSql()  {    $rs = M()->query("show triggers");    $arrAll = array();    foreach ($rs as $k=>&$v)    {      $arrSql = array(        'CREATE TRIGGER `',$v['Trigger'],'` ',$v['Timing'],' ',$v['Event'],' ON `',        $v['Table'],'` FOR EACH ROW ',$v['Statement'],';'      );      $arrAll[] = implode('',$arrSql);    }    return implode("/r/n",$arrAll);  }}

vendor('DBExport',COMMON_PATH);header('Content-type: text/plain; charset=UTF-8');$dbName = C('DB_NAME');header("Content-Disposition: attachment; filename=/"{$dbName}.sql/"");echo DBExport::ExportAllData()