PDO简单备份数据库

数据库备份是对数据库现有的数据文件的部分或全部、相关日志文件或参数文件生成一份副本，其目的主要针对两种突发情况。第一，硬盘介质损坏;第二，人为误操作。

话不多说直接上代码!!!

$pdo = new \PDO('mysql:host=localhost;dbname=', 'username', 'password');$tables = $pdo->query('SHOW TABLE STATUS')->fetchAll(\PDO::FETCH_ASSOC); foreach ($tables as table) { tableName=$table['Name'];$ts = $pdo->query( "show create table `$tableName")->fetchAll(\PDO::FETCH_ASSOC); foreach ($ts as $t){ $mysql.=$t['Create Table'].";\r\n"; echo $t; } $data = $pdo->query("SELECT * FROM $tableName`")->fetchAll(\PDO::FETCH_ASSOC); foreach ($data as row) { keys = array_keys($row);$keys = array_map('addslashes', $keys);$keys = join(',', $keys);$keys = "" . $keys . ""; $vals = array_values($row); $vals = array_map('addslashes',$vals); $vals = join("','",$vals); $vals = "'" .$vals . "'"; $mysql .= "insert into `$tableName`($keys) values($vals);\r\n"; } } file_put_contents(DIR . "/1.sql", $mysql);