function __construct() { @set_time_limit(300); try { self::$link = mysql_connect(DB_HOST . ':' . DB_PORT, DB_USER, DB_PASS); mysql_select_db(DB_NAME); mysql_query("set names utf8"); } catch (Exception $e) { exit($e->getMessage()); } }
$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(");"); }
<?php $tbl = new table('backup'); if ($_POST["done"]) { // get value $name = $_POST["name"]; $date = $_POST["date"]; /* * * backup file * */ $output = 'uploads/backup/' . $name . '-' . $date . '.sql'; $structure_only = false; // mysql_backup($host,$db,$user,$pass,$output,$structure_only) $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only); $backup->backup(); // ---------------- end backup ------------------------------------ // field $field = 'id,name,date,file'; // format($str,$isComma=1) // values $values = format($tbl->getLastId() + 1, 1); $values .= format($_POST["name"], 1); $values .= format($_POST["date"], 1); $values .= format($output, 0); // insertObject($field,$value) $res = $tbl->insertObject($field, $values); if ($res) { header('location: ' . loadPage('backup')); }
<?php $id = $_GET["id"]; $tbl = new table('backup'); $res = $tbl->loadOne('id=' . $id); if ($res) { $row = mysql_fetch_array($res); $output = $row['file']; $structure_only = false; $backup = new mysql_backup($db_host, $db_name, $db_user, $db_pass, $output, $structure_only); $backup->restore(); header('location: ' . loadPage('backup')); }