* @copyright (c) 2006 by bizeway.com
* @version $Id$
* @package ArthurXF
* @subpackage admin
*/
require_once '../config/config.inc.php';
require_once '../checklogin.php';
require_once 'class/backup.class.php';
$objWebInit = new backup();
//smarty参数
$objWebInit->arrGSmarty = $arrGSmarty;
//数据库连接参数
$objWebInit->setDBG($arrGPdoDB);
$objWebInit->db();
//访问权限检查
if (!$objWebInit->checkPopedomG($_SESSION['user_id'])) {
check::AlertExit('对不起，您没有权限访问此页', -1);
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
@set_time_limit(0);
/* 系统信息 */
$sys_info['os'] = PHP_OS;
$sys_info['web_server'] = $_SERVER['SERVER_SOFTWARE'];
$sys_info['php_ver'] = PHP_VERSION;
$sys_info['mysql_ver'] = $objWebInit->get_ver();
$sys_info['date'] = date("Y-m-d H:i:s");
$date = date("Y-m-d");
$head = "-- BIWEB SQL Dump \n" . "-- http://www.biweb.cn \n" . "-- \n" . "-- DATE : " . $sys_info["date"] . "\n" . "-- MYSQL SERVER VERSION : " . $sys_info['mysql_ver'] . "\n" . "-- PHP VERSION : " . $sys_info['php_ver'] . "\n" . "-- Vol : ";
$sql = $head . " 1 \n-- \n-- DATABASE : " . $arrGPdoDB['db_name'] . "\n-- \n\n-- ---------------------------------\n";
$zip = new phpzip();
$vol_size = $_POST['vol_size'];
* @copyright (c) 2006 by bizeway.com
* @version $Id$
* @package ArthurXF
* @subpackage admin
*/
require_once '../config/config.inc.php';
require_once '../checklogin.php';
require_once 'class/backup.class.php';
$objWebInit = new backup();
//smarty参数
$objWebInit->arrGSmarty = $arrGSmarty;
//数据库连接参数
$objWebInit->setDBG($arrGPdoDB);
$objWebInit->db();
//访问权限检查
if (!$objWebInit->checkPopedomG($_SESSION['user_id'], 'r', 'backup')) {
check::AlertExit('对不起，您没有读权限', -1);
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (!$objWebInit->checkPopedomG($_SESSION['user_id'], 'x', 'backup')) {
check::AlertExit('对不起，您没有执行权限', -1);
}
$arrTables = $objWebInit->get_table();
foreach ($arrTables as $k => $table) {
if ($objWebInit->db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
$strSQL = "OPTIMIZE TABLE `" . $table . "`";
$link = mysql_connect($arrGPdoDB['db_host'], $arrGPdoDB['db_user'], $arrGPdoDB['db_password']) or die('Could not connect: ' . mysql_error());
mysql_select_db($arrGPdoDB['db_name']) or die('Could not select database');
$result = mysql_query($strSQL) or die('Query failed: ' . mysql_error());
}
//$rs = $objWebInit->db->query($strSQL,array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));
