PHP MySQL 資料庫備份類：匯出結構與資料

<?php
function backupMySqlData($host, $user, $pwd, $db, $saveFile='') {
    set_time_limit(0); header("Content-Type:text/html;charset=utf-8");
    $link = mysql_connect($host,$user,$pwd) or die(mysql_error());
    mysql_select_db($db) or die(mysql_error());
    mysql_query('SET NAMES utf8');
    $file = ($saveFile?$saveFile:'MySQL_backup_').date('YmdHis').'.sql';
    $tables = [];
    $res = mysql_query("SHOW TABLES FROM $db");
    while($r=mysql_fetch_row($res)) $tables[]=$r[0];
    foreach($tables as $t) {
        $r = mysql_query("SHOW CREATE TABLE $t");
        $row = mysql_fetch_row($r);
        file_put_contents($file, "DROP TABLE IF EXISTS `$t`;\n".$row[1].";\n\n", FILE_APPEND);
    }
    foreach($tables as $t) {
        $res = mysql_query("SELECT * FROM $t");
        while($row = mysql_fetch_row($res)) {
            $vals = array_map(function($v){ return "'$v'"; }, $row);
            file_put_contents($file, "INSERT INTO `$t` VALUES (".implode(',',$vals).");\n", FILE_APPEND);
        }
    }
    echo "備份完成：$file";
}
backupMySqlData('localhost','root','123456','your_db');
?>

注意：範例使用已棄用 mysql_* 函式，現代專案請改用 mysqli 或 PDO 並採用預處理語句防注入。