thinkphp mysqldump

<?php
namespace app\index\controller;

use think\Controller;
use think\Db;

class Backup extends Controller
{
    public function index()
    {
        // 数据库连接配置
        $dbConfig = [
            'type' => 'mysql',
            'hostname' => '127.0.0.1',
            'database' => 'test',
            'username' => 'root',
            'password' => 'root',
            'hostport' => '3306',
        ];

        // 要备份的表名
        $tables = ['table1', 'table2'];

        // 创建 mysqldump 命令
        $command = "mysqldump -h{$dbConfig['hostname']} -u{$dbConfig['username']} -p{$dbConfig['password']} {$dbConfig['database']} " . implode(' ', $tables);

        // 执行命令并保存结果到文件
        exec($command, $output);
        file_put_contents('./backup.sql', implode("\n", $output));

        echo '备份完成';
    }
}