sevstudio/sev-mysqlbackup

php mysql backup helper

v1.0 2025-03-12 14:12 UTC

Requires

• php: >=7.0

MIT

• 10287093

README

介绍

mysql备份还原

使用说明

require_once __DIR__ . '/vendor/autoload.php';

/*
//备份示例
try{
    $hp = new \Sevstudio\SevMysqlBackup\Helper([
        'host' => '127.0.0.1',
        'port' => 3306,
        'uid' => 'root',
        'pwd' => 'root',
        'dbname' => 'gaolb',
        'charset' => 'utf8',
        'prefix' => 'lyg_',
    ]);
    //参数1:备份到哪个目录，参数2：生成备份文件的前缀
    $data = $hp->Backup(__DIR__ , 'aaaa_');
    var_dump($data);
}catch(\PDOException $pdoex){
    //出错了
    echo $pdoex->getMessage();
}
*/

/*
//还原示例
try{
    $hp = new \Sevstudio\SevMysqlBackup\Helper([
        'host' => '127.0.0.1',
        'port' => 3306,
        'uid' => 'root',
        'pwd' => 'root',
        'dbname' => 'abc_com',
        'charset' => 'utf8',
        'prefix' => 'lyg_',
    ]);
    //参数：要还原的备份文件完整路径
    $data = $hp->Restore(__DIR__  . '/aaaa_67d1935d860f9.sql');
    var_dump($data);
}catch(\PDOException $pdoex){
    //出错了
    echo $pdoex->getMessage();
}
*/