備份資料表

function backup_table($table_name){
global $xoopsDB;
$new_tb='backup_'.$table_name.'_'.date("Y_m_d_H_i_s");
$sql="SHOW CREATE TABLE ". $xoopsDB->prefix("$table_name");
$result = mysql_query($sql); $row = mysql_fetch_array($result);
$struc = $row[1];
$p = strtolower($xoopsDB->prefix("$table_name"));
$struc=str_replace ($p,$new_tb,$struc);
mysql_query($struc) or die($struc);
$sql_backup="INSERT INTO $new_tb SELECT * FROM ".$xoopsDB->prefix("$table_name") ;
mysql_query($sql_backup) or die($sql_backup);
}

還原資料表
function restore_table($table_name,$backup_name) {
$sql= "TRUNCATE TABLE ".$table_name;
mysql_query($sql) or die($sql);
$sql_restore="INSERT INTO $table_name SELECT * FROM $backup_name";
mysql_query($sql_restore) or die($sql_restore);
}