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'));
}
