Exemplo n.º 1
0
$db_name = EZSQL_DB_NAME;
//---- Your database name.
$db_user = EZSQL_DB_USER;
//---- Your database username.
$db_pass = EZSQL_DB_PASSWORD;
//---- Your database password.
$dowhat = "backup";
//$dowhat = "restore";
if ($dowhat == "backup") {
    // This code doesn't export dates
    //$structure_only = false;
    //$output = "./backup/backup_data.txt";
    //$backup = new mysql_backup($db_host,$db_name,$db_user,$db_pass,$output,$structure_only);
    //$backup->backup();
    require_once "../libs/backup/mysql_backup/init.php";
    $b = new backup();
    $b->dbconnect($GonxAdmin["dbhost"], $GonxAdmin["dbuser"], $GonxAdmin["dbpass"], $GonxAdmin["dbname"], "", $GonxAdmin["dbtype"]);
    $b->generate();
    $structure_only = true;
    $output = "./backup/MySQL-Structure-Backup-" . $b->filename;
    $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only);
    $backup->backup();
}
if ($dowhat == "restore") {
    $output = "./backup/backup_structure.txt";
    $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only);
    $backup->restore(";");
    $output = "./backup/backup_data.txt";
    $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only);
    $backup->restore(");");
}
Exemplo n.º 2
0
/**
 * All controls
 */
function backup()
{
    if (BACKUP_DB) {
        $db = new mysql_backup();
        $db->backup();
        $log = date('Y-m-d H:i:s') . "已成功导出MYSQL数据" . $GLOBALS['sql_name'] . "\r\n";
    }
    $file = new file_backup();
    $ret = $file->backup();
    $log .= date('Y-m-d H:i:s') . "已成功备份" . $ret['filenum'] . "个文件( " . byte_format(filesize($ret['filename'])) . " )\r\n";
    switch (BACKUP_TYPE) {
        case '1':
            //仅云端
            $sendok = $file::sendfile($ret['filename']);
            if ($sendok) {
                $log .= date('Y-m-d H:i:s') . "已成功存储到云端" . $ret['filename'] . "\r\n";
            } else {
                $log .= date('Y-m-d H:i:s') . "存储到云端失败" . $ret['filename'] . "\r\n";
            }
            unlink('./' . $ret['filename']);
            break;
        case '2':
            //仅本地
            $log .= date('Y-m-d H:i:s') . "已存储到本地" . $ret['filename'] . "\r\n";
            break;
        case '3':
            ///云端和本地
            $log .= date('Y-m-d H:i:s') . "已存储到本地" . $ret['filename'] . "\r\n";
            $sendok = $file::sendfile($ret['filename']);
            if ($sendok) {
                $log .= date('Y-m-d H:i:s') . "已成功存储到云端" . $ret['filename'] . "\r\n";
            } else {
                $log .= date('Y-m-d H:i:s') . "存储到云端失败" . $ret['filename'] . "\r\n";
            }
            break;
        default:
            $log .= "备份参数不正确\r\n";
            break;
    }
    return $log;
}