php数据库备份下载,thinkphp数据库在线备份下载和还原

创建好备份类,注意命名空间

比如此时放到放到Thinkphp/Library/Org/Util/目录下

```

namespace Org\Util;

class MySQLReback {

private $config;

private $content;

private $dbName = array();

const DIR_SEP = DIRECTORY_SEPARATOR;

public function __construct($config) {

$this->config = $config;

header("Content-type: text/html;charset=utf-8");

$this->connect();

}

private function connect() {

if (mysql_connect($this->config['host'] . ':' . $this->config['port'], $this->config['userName'], $this->config['userPassword'])) {

mysql_query("SET NAMES '{$this->config['charset']}'");

mysql_query("set interactive_timeout=24*3600");

} else {

$this->throwException('无法连接到数据库!');

}

}

public function setDBName($dbName = '*') {

if ($dbName == '*') {

$rs = mysql_list_dbs();

$rows = mysql_num_rows($rs);

if ($rows) {

for ($i = 0; $i < $rows; $i++) {

$dbName = mysql_tablename($rs, $i);

$block = array('information_schema', 'mysql');

if (!in_array($dbName, $block)) {

$this->dbName[] = $dbName;

}

}

} else {

$this->throwException('没有任何数据库!');

}

} else {

$this->dbName = func_get_args();

}

}

private function getFile($fileName) {

$this->content = '';

$fileName = $this->trimPath($this->config['path'] . self::DIR_SEP . $fileName);

if (is_file($fileName)) {

$ext = strrchr($fileName, '.');

if ($ext == '.sql') {

$this->content = file_get_contents($fileName);

} elseif ($ext == '.gz') {

$this->content = implode('', gzfile($fileName));

} else {

$this->throwException('无法识别的文件格式!');

}

} else {

$this->throwException('文件不存在!');

}

}

private function setFile() {

$recognize = '';

$recognize = implode('_', $this->dbName);

$fileName = $this->trimPath($this->config['path'] . self::DIR_SEP . $recognize . '_' . date('YmdHis') . '_' . mt_rand(100000000, 999999999) . '.sql');

$path = $this->setPath($fileName);

if ($path !== true) {

$this->throwException("无法创建备份目录目录 '$path'");

}

if ($this->config['isCompress'] == 0) {

if (!file_put_contents($fileName, $this->content, LOCK_EX)) {

$this->throwException('写入文件失败,请检查磁盘空间或者权限!');

}

} else {

if (function_exists('gzwrite')) {

$fileName .= '.gz';

if ($gz = gzopen($fileName, 'wb')) {

gzwrite($gz, $this->content);

gzclose($gz);

} else {

$this->throwException('写入文件失败,请检查磁盘空间或者权限!');

}

} else {

$this->throwException('没有开启gzip扩展!');

}

}

if ($this->config['isDownload']) {

$this->downloadFile($fileName);

}

}

private function trimPath($path) {

return str_replace(array('/', '\\', '//', '\\\\'), self::DIR_SEP, $path);

}

private function setPath($fileName) {

$dirs = explode(self::DIR_SEP, dirname($fileName));

$tmp = '';

foreach ($dirs as $dir) {

$tmp .= $dir . self::DIR_SEP;

if (!file_exists($tmp) && !@mkdir($tmp, 0777))

return $tmp;

}

return true;

}

private function downloadFile($fileName) {

ob_end_clean();

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header('Content-Description: File Transfer');

header('Content-Type: application/octet-stream');

header('Content-Length: ' . filesize($fileName));

header('Content-Disposition: attachment; filename=' . basename($fileName));

readfile($fileName);

}

private function backquote($str) {

return "`{$str}`";

}

private function getTables($dbName) {

@$rs = mysql_list_tables($dbName);

$rows = mysql_num_rows($rs);

$dbprefix = $this->config['dbprefix'];

for ($i = 0; $i < $rows; $i++) {

$tbName = mysql_tablename($rs, $i);

if (substr($tbName, 0, strlen($dbprefix)) == $dbprefix) {

$tables[] = $tbName;

}

}

return $tables;

}

/*private function chunkArrayByByte($array, $byte = 5120) {

$i = 0;

$sum = 0;

foreach ($array as $v) {

$sum += strlen($v);

if ($sum < $byte) {

$return[$i][] = $v;

} elseif ($sum == $byte) {

$return[++$i][] = $v;

$sum = 0;

} else {

$return[++$i][] = $v;

$i++;

$sum = 0;

}

}

return $return;

}*/

private function chunkArrayByByte($array) {

$arr = array();

foreach ($array as $v) {

$arr[] = $v;

}

return $arr;

}

public function backup() {

$this->content = '/* This file is created by MySQLReback ' . date('Y-m-d H:i:s') . ' */';

foreach ($this->dbName as $dbName) {

$qDbName = $this->backquote($dbName);

$rs = mysql_query("SHOW CREATE DATABASE {$qDbName}");

if ($row = mysql_fetch_row($rs)) {

mysql_select_db($dbName);

$tables = $this->getTables($dbName);

foreach ($tables as $table) {

$table = $this->backquote($table);

$tableRs = mysql_query("SHOW CREATE TABLE {$table}");

if ($tableRow = mysql_fetch_row($tableRs)) {

$this->content .= "\r\n /* 创建表结构 {$table} */";

$this->content .= "\r\n DROP TABLE IF EXISTS {$table};/*end*/ {$tableRow[1]};/*end*/";

$tableDateRs = mysql_query("SELECT * FROM {$table}");

$valuesArr = array();

$values = '';

while ($tableDateRow = mysql_fetch_row($tableDateRs)) {

foreach ($tableDateRow as &$v) {

$v = "'" . addslashes($v) . "'";

}

$valuesArr[] = '(' . implode(',', $tableDateRow) . ')';

}

$temp = $this->chunkArrayByByte($valuesArr);

/*if (is_array($temp)) {

foreach ($temp as $v) {

$values = implode(',', $v) ;

if ($values != '') {

$this->content .= "\r\n // 插入数据 {$table} ";

$this->content .= "\r\n INSERT INTO {$table} VALUES {$values}";

}

}

}*/

if (is_array($temp)) {

for ($i=0;$i

$this->content .= "\r\n /* 插入数据 {$table} */";

$this->content .= "\r\n INSERT INTO {$table} VALUES {$temp[$i]};/*end*/";

}

}

}

}

} else {

$this->throwException('未能找到数据库!');

}

}

if (!empty($this->content)) {

$this->setFile();

}

return true;

}

public function recover($fileName) {

$this->getFile($fileName);

if (!empty($this->content)) {

$content = explode('/*end*/', $this->content);

foreach ($content as $i => $sql) {

$sql = trim($sql);

if (!empty($sql)) {

$dbName = $this->dbName[0];

if (!mysql_select_db($dbName))

$this->throwException('不存在的数据库!' . mysql_error());

$rs = mysql_query($sql);

if ($rs) {

if (strstr($sql, 'CREATE DATABASE')) {

$dbNameArr = sscanf($sql, 'CREATE DATABASE %s');

$dbName = trim($dbNameArr[0], '`');

mysql_select_db($dbName);

}

} else {

$this->throwException('备份文件被损坏!' . mysql_error());

}

}

}

} else {

$this->throwException('无法读取备份文件!');

}

return true;

}

private function throwException($error) {

throw new Exception($error);

}

}

?>

```

#####创建控制器

```

namespace Home\Controller;

use Think\Controller;

class BackupController extends Controller {

/**

* 数据库备份、下载、还原、删除

*/

public function index(){

$DataDir = "databak/";

is_dir($DataDir) || mkdir($DataDir);

if (!empty($_GET['Action'])) {

//import("Common.Org.MySQLReback");

$config = array(

'host' => C('DB_HOST'),

'port' => C('DB_PORT'),

'userName' => C('DB_USER'),

'userPassword' => C('DB_PWD'),

'dbprefix' => C('DB_PREFIX'),

'charset' => 'UTF8',

'path' => $DataDir,

'isCompress' => 0, //是否开启gzip压缩

'isDownload' => 0

);

$mr = new \Org\Util\MySQLReback($config);

$mr->setDBName(C('DB_NAME'));

if ($_GET['Action'] == 'backup') {

$res = $mr->backup();

//echo "";

$this->success( '数据库备份成功！');die;

} elseif ($_GET['Action'] == 'RL') {

$mr->recover($_GET['File']);

//echo "";

$this->success( '数据库还原成功！');

} elseif ($_GET['Action'] == 'Del') {

if (@unlink($DataDir . $_GET['File'])) {

$this->success('删除成功！');

//echo "";

} else {

$this->error('删除失败！');

}

}

if ($_GET['Action'] == 'download') {

function DownloadFile($fileName) {

ob_end_clean();

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header('Content-Description: File Transfer');

header('Content-Type: application/octet-stream');

header('Content-Length: ' . filesize($fileName));

header('Content-Disposition: attachment; filename=' . basename($fileName));

readfile($fileName);

}

DownloadFile($DataDir . $_GET['file']);

exit();

}

}

$lists = $this->MyScandir('databak/');

$this->assign("datadir",$DataDir);

$this->assign("lists", $lists);

$this->display();

}

private function MyScandir($FilePath = './', $Order = 0) {

$FilePath = opendir($FilePath);

while (false !== ($filename = readdir($FilePath))) {

$FileAndFolderAyy[] = $filename;

}

$Order == 0 ? sort($FileAndFolderAyy) : rsort($FileAndFolderAyy);

return $FileAndFolderAyy;

}

}

```

######注意数据库配置 和C()函数如果是tp5则是config读取到的数据库配置名称是否一样

#####html页面

```

数据库备份、下载、还原、删除

教程：Thinkphp数据库在线备份下载和还原

序号	文件名	备份时间	文件大小	操作
{$key-1}	没有找到相关数据。

备份添加

```

#####效果