PHP完成MySQL数据库备份的源码
发布时间：2022-02-24 14:09:26 所属栏目：PHP教程 来源：互联网
导读：下面是一个php数据库备份的源代码，大家也可以根据自己的需求进行修改。 ?php // 备份数据库 $host = localhost; $user = root; //数据库账号 $password = ; //数据库密码 $dbname = mysql; //数据库名称 // 这里的账号、密码、名称都是从页面传过来的 if
|
下面是一个php数据库备份的源代码，大家也可以根据自己的需求进行修改。 <?php // 备份数据库 $host = "localhost"; $user = "root"; //数据库账号 $password = ""; //数据库密码 $dbname = "mysql"; //数据库名称 // 这里的账号、密码、名称都是从页面传过来的 if (!mysql_connect($host, $user, $password)) // 连接mysql数据库 { echo '数据库连接失败，请核对后再试'; exit; } if (!mysql_select_db($dbname)) // 是否存在该数据库 { echo '不存在数据库:' . $dbname . ',请核对后再试'; exit; } mysql_query("set names 'utf8'"); $mysql = "set charset utf8;/r/n"; $q1 = mysql_query("show tables"); while ($t = mysql_fetch_array($q1)) { $table = $t[0]; $q2 = mysql_query("show create table `$table`"); $sql = mysql_fetch_array($q2); $mysql .= $sql['Create Table'] . ";/r/n"; $q3 = mysql_query("select * from `$table`"); while ($data = mysql_fetch_assoc($q3)) { $keys = array_keys($data); $keys = array_map('addslashes', $keys); $keys = join('`,`', $keys); $keys = "`" . $keys . "`"; $vals = array_values($data); $vals = array_map('addslashes', $vals); $vals = join("','", $vals); $vals = "'" . $vals . "'"; $mysql .= "insert into `$table`($keys) values($vals);/r/n"; } } $filename = $dbname . date('Ymjgi') . ".sql"; //存放路径，默认存放到项目最外层 $fp = fopen($filename, 'w'); fputs($fp, $mysql); fclose($fp); echo "数据备份成功"; ?> 如果使用的是thinkphp可以使用下面代码来备份mysql数据库 <?php // www.Cuoxin.com class BaksqlAction extends CommonAction { public $config = ''; //相关配置 public $model = ''; //实例化一个model public $content; //内容 public $dbName = ''; //数据库名 public $dir_sep = '/'; //路径符号 //初始化数据 function _initialize() { parent::_initialize(); header("Content-type: text/html;charset=utf-8"); set_time_limit(0); // function index() { $path = $this->config['path']; $fileArr = $this->MyScandir($path); foreach ($fileArr as $key => $value) { if ($key > 1) { //获取文件创建时间 $fileTime = date('Y-m-d H:i:s', filemtime($path . '/' . $value)); $fileSize = filesize($path . '/' . $value) / 1024; //获取文件大小 $fileSize = $fileSize < 1024 ? number_format($fileSize, 2) . ' KB' : number_format($fileSize / 1024, 2) . ' MB'; //构建列表数组 $list[] = array( 'name' => $value, 'time' => $fileTime, 'size' => $fileSize ); } } $this->assign('list', $list); $this->display(); } /* - * +------------------------------------------------------------------------ * * @ 获取数据表 * +------------------------------------------------------------------------ */ function tablist() { $list = $this->model->query("SHOW TABLE STATUS FROM {$this->dbName}"); //得到表的信息 //echo $Backup->getLastSql(); $this->assign('list', $list); $this->display(); } /* - * +------------------------------------------------------------------------ * * @ 备份整个数据库 * +------------------------------------------------------------------------ */ function backall() { $tables = $this->getTables(); if ($this->backup($tables)) { $this->success('数据库备份成功！', '/public/ok'); } else { $this->error('数据库备份失败！'); } } /* - * +------------------------------------------------------------------------ * * @ 按表备份，可批量 * +------------------------------------------------------------------------ */ function backtables() { $tab = $_REQUEST['tab']; if (is_array($tab)) $tables = $tab; else $tables[] = $tab; if ($this->backup($tables)) { if (is_array($tab)) $this->success('数据库备份成功！'); else $this->success('数据库备份成功！', '/public/ok'); } else { $this->error('数据库备份失败！'); } } //还原数据库 function recover() { if ($this->recover_file($_GET['file'])) { $this->success('数据还原成功！', '/public/ok'); } else { $this->error('数据还原失败！'); } } //删除数据备份 function deletebak() { if (unlink($this->config['path'] . $this->dir_sep . $_GET['file'])) { $this->success('删除备份成功！', '/public/ok'); } else { $this->error('删除备份失败！'); } } /* - * +------------------------------------------------------------------------ * * @ 下载备份文件 * +------------------------------------------------------------------------ */ function downloadBak() { $file_name = $_GET['file']; $file_dir = $this->config['path']; if (!file_exists($file_dir . "/" . $file_name)) { //检查文件是否存在 return false; exit; } else { $file = fopen($file_dir . "/" . $file_name, "r"); // 打开文件 // 输入文件标签 header('Content-Encoding: none'); header("Content-type: application/octet-stream"); header("Accept-Ranges: bytes"); header("Accept-Length: " . filesize($file_dir . "/" . $file_name)); header('Content-Transfer-Encoding: binary'); header("Content-Disposition: attachment; filename=" . $file_name); //以真实文件名提供给浏览器下载 header('Pragma: no-cache'); header('Expires: 0'); //输出文件内容 echo fread($file, filesize($file_dir . "/" . $file_name)); fclose($file); exit; } } /* - * +------------------------------------------------------------------------ * * @ 获取 目录下文件数组 * +------------------------------------------------------------------------ * * @ $FilePath 目录路径 * * @ $Order 排序 * +------------------------------------------------------------------------ * * @ 获取指定目录下的文件列表，返回数组 * +------------------------------------------------------------------------ */ private function MyScandir($FilePath = './', $Order = 0) { $FilePath = opendir($FilePath); while ($filename = readdir($FilePath)) { $fileArr[] = $filename; } $Order == 0 ? sort($fileArr) : rsort($fileArr); return $fileArr; } /* * ******************************************************************************************** */ /* - * +------------------------------------------------------------------------ * * @ 读取备份文件 * +------------------------------------------------------------------------ * * @ $fileName 文件名 * +------------------------------------------------------------------------ */ private function getFile($fileName) { $this->content = ''; $fileName = $this->trimPath($this->config['path'] . $this->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->error('无法识别的文件格式!'); } } else { $this->error('文件不存在!'); } } /* - * +------------------------------------------------------------------------ * * @ 把数据写入磁盘 * +------------------------------------------------------------------------ */ private function setFile() { $recognize = ''; $recognize = $this->dbName; $fileName = $this->trimPath($this->config['path'] . $this->dir_sep . $recognize . '_' . date('YmdHis') . '_' . mt_rand(100000000, 999999999) . '.sql'); $path = $this->setPath($fileName); if ($path !== true) { $this->error("无法创建备份目录目录 '$path'"); } if ($this->config['isCompress'] == 0) { if (!file_put_contents($fileName, $this->content, LOCK_EX)) { $this->error('写入文件失败,请检查磁盘空间或者权限!'); } } else { if (function_exists('gzwrite')) { $fileName .= '.gz'; if ($gz = gzopen($fileName, 'wb')) { gzwrite($gz, $this->content); gzclose($gz); } else { $this->error('写入文件失败,请检查磁盘空间或者权限!'); } } else { $this->error('没有开启gzip扩展!'); } } if ($this->config['isDownload']) { $this->downloadFile($fileName); } } private function trimPath($path) { return str_replace(array('/', '//', '//', '////'), $this->dir_sep, $path); } private function setPath($fileName) { $dirs = explode($this->dir_sep, dirname($fileName)); $tmp = ''; foreach ($dirs as $dir) { $tmp .= $dir . $this->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); } /* - * +------------------------------------------------------------------------ * * @ 给字符串添加 ` ` * +------------------------------------------------------------------------ * * @ $str 字符串 * +------------------------------------------------------------------------ * * @ 返回 `$str` * +------------------------------------------------------------------------ */ private function backquote($str) { return "`{$str}`"; } /* - * +------------------------------------------------------------------------ * * @ 获取数据库的所有表 * +------------------------------------------------------------------------ * * @ $dbName 数据库名称 * +------------------------------------------------------------------------ */ private function getTables($dbName = '') { if (!emptyempty($dbName)) { $sql = 'SHOW TABLES FROM ' . $dbName; } else { $sql = 'SHOW TABLES '; } $result = $this->model->query($sql); $info = array(); foreach ($result as $key => $val) { $info[$key] = current($val); } return $info; } /* - * +------------------------------------------------------------------------ * * @ 把传过来的数据 按指定长度分割成数组 * +------------------------------------------------------------------------ * * @ $array 要分割的数据 * * @ $byte 要分割的长度 * +------------------------------------------------------------------------ * * @ 把数组按指定长度分割,并返回分割后的数组 * +------------------------------------------------------------------------ */ private function chunkArrayByByte($array, $byte = 5120) { $i = 0; $sum = 0; $return = array(); 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 recover_file($fileName) { $this->getFile($fileName); if (!emptyempty($this->content)) { $content = explode(';/* MySQLReback Separation */', $this->content); foreach ($content as $i => $sql) { $sql = trim($sql); if (!emptyempty($sql)) { $mes = $this->model->execute($sql); if (false === $mes) { //如果 null 写入失败，换成 '' $table_change = array('null' => '/'/''); $sql = strtr($sql, $table_change); $mes = $this->model->execute($sql); } if (false === $mes) { //如果遇到错误、记录错误 $log_text = '以下代码还原遇到问题:'; $log_text.="/r/n $sql"; set_log($log_text); } //Cuoxin.com } } } else { $this->error('无法读取备份文件!'); } return true; } } ?> （编辑：南平站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
