データベース (MySQL) の中身を SQL 形式でダンプする PHP スクリプト

header('Content-Type: application/octet-stream');
 
function nullcheck($values) {
 $ret = Array();
 foreach($values as $val) {
  if ($val===NULL) $ret[] = 'NULL';
  else $ret[] = '\'' . $val . '\'';
 }
 return $ret;
}
 
function mysql_dump($database) {
 $lnbr = "\r\n"; 
 $query = '';
 $tables = @mysql_list_tables($database);
 while ($row = @mysql_fetch_row($tables)) { $table_list[] = $row[0]; }
  for ($i = 0; $i < @count($table_list); $i++) {
   $results = mysql_query('SHOW CREATE TABLE ' . $database . '.' . $table_list[$i]);
   $query .= 'DROP TABLE IF EXISTS `' . $table_list[$i] . '`;' . str_repeat($lnbr, 2);
   while ($row = @mysql_fetch_assoc($results)) {
    $query .= $row['Create Table'] . ';';
   }
   $query .= str_repeat($lnbr, 2);
   $results = mysql_query('SELECT * FROM ' . $database . '.' . $table_list[$i]);
   while ($row = @mysql_fetch_assoc($results)) {
    $query .= 'INSERT INTO `' . $table_list[$i] .'` (';
    $data = Array();
    while (list($key, $value) = @each($row)) { $data['keys'][] = $key; $data['values'][] = ($value===NULL) ? NULL : addslashes($value); }
     $query .= join($data['keys'], ', ') . ')' . $lnbr . 'VALUES (' . str_replace("\r\n",'\r\n', join(nullcheck($data['values']), ', ')) . ');' . $lnbr;
   }
   $query .= str_repeat($lnbr, 2);
  }
 return $query;
}
 
$db = mysql_connect("db_host", "db_user", "db_pass");
if (!$db) {
die('failed to open the database');
}
echo mysql_dump("db_name");
mysql_close($db);