والله من فترة شفت هاك بالشركة وأعجبني مرررررررررررة وهو يصغر القاعدة بشكل رهيب أنا قاعدة بياناتي حجمها 15ميجا بهالهاك صارت 2ميجا وشوي
بسم الله نبدأ الطريقة
1- أفتح ملف admin/template.php
أبحث عن
cpfooter();
?>
قبل هذا أضف
/######### MySQL Database Backup/Restore Hack Ver. 1.0 ###########
//######### by Birdie501 ###########
//######### Variable, please modify ###########
$db_host="Host-name";
$db_username="mysql-username";
$db_passwort="mysql-passwort";
$db_name="database-name";
$pfad="root/your folder to your forum/admin/backup"; // root without / at the end
// If you don't know the root, just upload root.php on your server and call it!
$download_url="http://"; // http://... with / at the end
$dateiname=date('U'); // not to change!. Unique filename will be used
//######### please do not modify lines below ###########
// ###################### Start Backup #######################
if ($action=="backup") {
doformheader("template","dobackup");
makehiddencode("templateid",$templateid);
makehiddencode("group",$group);
maketableheader("Confirm backup");
makedescription("Are you sure you want to backup your mysql database?");
doformfooter("Yes","",2,"No");
}
// ###################### Start Dobackup #######################
if ($HTTP_POST_VARS['action']=="dobackup") {
$programm="mysqldump";
$parameter=" -l --add-drop-table -h ".$db_host." -u".$db_username." -p".$db_passwort." ".$db_name." 2>".$pfad."/error.txt >".$pfad."/".$dateiname.".sql";
echo("<b>Start MySQL Dump:</b> \n");
exec($programm . " " . $parameter, $lines, $result);
echo("done!<br>\n");
echo("<b>compress file:</b> \n");
exec("gzip -c ".$pfad."/".$dateiname.".sql > ".$pfad."/".$dateiname.".sql.gz", $lines, $result);
echo("done!<br>\n");
echo("<b>delete not compressed file:</b> \n");
exec("rm ".$pfad."/".$dateiname.".sql", $lines, $result);
echo("done! \n");
echo("<b><br>Before you can restore this file, you have to rename to backp.sql.gz:</b> \n");
echo("<p>\n");
echo("<a href=\"".$download_url.$dateiname.".sql.gz\" target=\"_blank\">Download File</a>");
}
// ###################### Start Restore #######################
if ($action=="backup") {
doformheader("template","dorestore");
makehiddencode("templateid",$templateid);
makehiddencode("group",$group);
maketableheader("Confirm restore");
makedescription("Are you sure you want to restore your mysql database? <font color='red'>Attention: All datas will be overwritten!</font>");
doformfooter("Yes","",2,"No");
}
// ###################### Start Dorestore #######################
if ($HTTP_POST_VARS['action']=="dorestore") {
if(file_exists($pfad."/backup.sql.gz")==1):
$programm="mysql";
$parameter="--host=".$db_host." --user=".$db_username." --password=".$db_passwort." --database=".$db_name." <".$pfad."/backup.sql";
echo("<b>decompress backup:</b> \n");
exec("cd ".$pfad, $lines, $result);
exec("gzip -d ".$pfad."/backup.sql.gz", $lines, $result);
echo("done!<br>\n");
echo("<b>restore file to database:</b> \n");
exec($programm." ".$parameter, $lines, $result);
echo("done!<br>\n");
else:
echo("<b>File <font color='red'>".$pfad."/backup.sql.gz</font> not found!</b> \n");
endif;
}
//######### End of MySQL Database Backup/Restore Hack Ver. 1.0 ###########
//######### by Birdie501 ###########