$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(");"); }
/** * 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; }