أسترجاع قواعد بيانات المنتدى كل الطرق فاشلة
السلام عليكم
لدي قاعدة بيانات منتدى أصدار 3.8.4 حجم قاعدة البيانات 78ميجابايت
حاولت بعدة طرق لإستعادة القادعدة دون فائدة
الطرق التي أتبعتها
بعد إيقاف الهاكات من الكونفيج
1- تقسيم قاعدة البيانات ببرنامج SQLDumpSplitter ورفعها عن طريق phpmyadmin
ولكن تظهر بعض الاجزاء أخطاء مثل
2- رفعت قاعدة البيانات على السيرفر وأستخدمت سكربت bigdump بإصداريةخطأ
إستعلام-SQL:
INSERT INTO `access` VALUES (118,2,0),(118,1,0),(118,36,0),(118,37,0),(118,38,0),(118,39,0),(118,3,0),(118,4,0),(118,6,0),(118,4 1,0),(118,47,0),(118,43,0),(118,49,0),(118,5,0),(118,7,0),(118,18,0),(118,50,0),(118,40,0),(118,34,0 ),(118,32,0),(118,13,0),(118,14,0),(118,15,0),(118,16,0),(118,31,0),(118,51,0),(118,33,0),(118,42,0) ,(118,35,0),(118,23,0),(118,22,0),(118,9,0),(118,10,0),(118,11,0),(118,12,0),(118,24,0),(118,25,0),( 118,26,0),(118,53,0),(118,55,0),(118,54,0),(118,27,0),(118,52,0),(118,28,0),(118,29,0),(118,57,0),(1 18,30,0),(118,44,0),(220,2,0),(220,1,0),(220,36,0),(220,37,0),(220,38,0),(220,39,0),(220,68,0),(220, 69,0),(220,70,0),(220,72,0),(220,3,0),(220,4,0),(220,6,0),(220,41,0),(220,7,0),(220,43,0),(220,47,0) ,(220,66,0),(220,65,0),(220,67,0),(220,5,0),(220,49,0),(220,50,0),(220,40,0),(220,73,1),(220,74,0),( 220,34,0),(220,32,0),(220,75,0),(220,13,0),(220,14,0),(220,15,0),(220,60,0),(220,61,0),(220,62,0),(2 20,16,0),(220,18,0),(220,31,0),(220,51,0),(220,64,0),(220,33,0),(220,42,[...]
MySQL قال:
#1062 - Duplicate entry '118-2' for key 1
bigdump ver. 0.21b
ظهر الخطأ التالي
bigdump v0.32bError at the line 3012: /*!40101 SET character_set_client = @saved_cs_client */;
Query: /*!40101 SET character_set_client = @saved_cs_client */;
MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
تظهر النتيجة نجاح
Congratulations: End of file reached, assuming OK
ولكن عند التوجة للمنتدى يظهر التالي
vBulletin datastore error caused by one or more of the following:
Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 224
- You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
- The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.
وبعد مرور مدة من الوقت فتح المنتدى ولكن برموز غريبة والخطأ التالي في أعلى الهيدر:
Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/includes/functions.php on line 4243
Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 4243
/*** vBulletin 3.8.4 CSS* Style: 'Default Style'; Style ID: 1*/body{ background: url(/vb/bg1.gif); color: #000000; font: 11px tahoma; margin: 0px 0px 0px 0px; padding: 0px; background-image: url(/vb/bg1.gif); background-repeat: no-repeat; background-attachment: fixed; }a:link, body_alink{ color: #000000;}a:visited, body_avisited{ color: #000000;}a:hover, a:active, body_ahover{ color: #FF4400;}.page{ color: #000000; font-family: tahoma;}td, th, p, li{ font: 11px tahoma;}.tborder{ background: #999999; font-family: tahoma; font-family: tahoma; border: 1px solid #0B198C; }.tcat{ background: #484f52; color: #FFFFFF; font: bold 11px tahoma;}.tcat a:link, .tcat_alink{ color: #FFFFFF; text-decoration: none;}.tcat a:visited, .tcat_avisited{ color: #FFFFFF; text-decoration: none;}.tcat a:hover, .tcat a:active, .tcat_ahover{ text-decoration: none;}.thead{ background: #ffc060; color: #333333; font: bold 11px tahoma;}.tfoot{ background: #484f52; color: #ffc060; font: 11px tahoma;}.tfoot a:link, .tfoot_alink{ color: #ffc060; text-decoration: none;}.tfoot a:visited, .tfoot_avisited{ color: #ffc060; text-decoration: none;}.tfoot a:hover, .tfoot a:active, .tfoot_ahover{ color: #ffc060; text-decoration: none;}.alt1, .alt1Active{ background: #FFFFFF; color: #000000; font: bold 10pt tahoma;}.alt1 a:link, .alt1_alink, .alt1Active a:link, .alt1Active_alink{ text-decoration: none;}.alt1 a:visited, .alt1_avisited, .alt1Active a:visited, .alt1Active_avisited{ text-decoration: none;}.alt1 a:hover, .alt1 a:active, .alt1_ahover, .alt1Active a:hover, .alt1Active a:active, .alt1Active_ahover{ text-decoration: none;}.alt2, .alt2Active{ background: #e8eeef; color: #000033; font: bold 10pt tahoma;}.alt2 a:link, .alt2_alink, .alt2Active a:link, .alt2Active_alink{ text-decoration: none;}.alt2 a:visited, .alt2_avisited, .alt2Active a:visited, .alt2Active_avisited{ text-decoration: none;}.alt2 a:hover, .alt2 a:active, .alt2_ahover, .alt2Active a:hover, .alt2Active a:active, .alt2Active_ahover{ text-decoration: none;}.inlinemod{ background: #316AC5; color: #CCCCCC; font-family: tahoma;}.wysiwyg{ background: #FFFFFF; color: #000000; font: 11pt tahoma; margin: 5px 10px 10px 10px; padding: 0px;}.wysiwyg a:hover, .wysiwyg a:active, .wysiwyg_ahover{ color: #FF4400;}textarea, .bginput{ background: #FFFFFF; color: #000000; font: 10pt tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.bginput option, .bginput optgroup{ font-size: 10pt; font-family: tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.button{ font: 11px tahoma;}select{ background: #FFFFFF; color: #316AC5; font: 11px tahoma;}option, optgroup{ font-size: 11px; font-family: tahoma;}.smallfont{ font: 11px tahoma;}.time{ color: #000000; font-family: tahoma;}.navbar{ background: #FFFFFF; color: #316AC5; font: 11px tahoma;}.highlight{ color: #FF0000; font: bold 11px tahoma;}.fjsel{ background: #FFFFFF; color: #CC6600;}.fjdpth0{ background: #F7F7F7; color: #660000;}.panel{ background: transparent; color: #316AC5; font-family: tahoma; padding: 10px; border: 2px outset;}.panelsurround{ background: #e8eeef; color: #333333; font-family: tahoma;}legend{ color: #000000; font: 11px tahoma;}.vbmenu_control{ background: #484f52; color: #FFFFFF; font: bold 11px tahoma; padding: 3px 6px 3px 6px; white-space: nowrap;}.vbmenu_control a:link, .vbmenu_control_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_control a:visited, .vbmenu_control_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_control a:hover, .vbmenu_control a:active, .vbmenu_control_ahover{ color: #FFFFFF; text-decoration: none;}.vbmenu_popup{ background: #316AC5; color: #999999; font-family: tahoma; border: 1px solid #0B198C;}.vbmenu_option{ background: #333333; color: #FFFFFF; font: 11px tahoma; white-space: nowrap; cursor: pointer;}.vbmenu_option a:link, .vbmenu_option_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_option a:visited, .vbmenu_option_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_option a:hover, .vbmenu_option a:active, .vbmenu_option_ahover{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite{ background: #333333; color: #FFFFFF; font: 11px tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; white-space: nowrap; cursor: pointer;}.vbmenu_hilite a:link, .vbmenu_hilite_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite a:visited, .vbmenu_hilite_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite a:hover, .vbmenu_hilite a:active, .vbmenu_hilite_ahover{ color: #FFFFFF; text-decoration: none;}/* ***** styling for 'big' usernames on postbit etc. ***** */.bigusername { font-size: 14pt; }/* ***** small padding on 'thead' elements ***** */td.thead, th.thead, div.thead { padding: 4px; }/* ***** basic styles for multi-page nav elements */.pagenav a { text-decoration: none; }.pagenav td { padding: 2px 4px 2px 4px; }/* ***** de-emphasized text */.shade, a.shade:link, a.shade:visited { color: #777777; text-decoration: none; }a.shade:active, a.shade:hover { color: #FF4400; text-decoration: underline; }.tcat .shade, .thead .shade, .tfoot .shade { color: #DDDDDD; }/* ***** define margin and font-size for elements inside panels ***** */.fieldset { margin-bottom: 6px; }.fieldset, .fieldset td, .fieldset p, .fieldset li { font-size: 11px; }html scrollbar-base-color: #A15D12; scrollbar-arrow-color: #F4E9B3; scrollbar-track-color: #F4E9B3; .quotes_header_r {background-image: url('images/quotes/quotes_06.png');background-repeat: no-repeat;background-position: center center;width: 24px;height: 38px;float: right;} .quotes_header_l {background-image: url('images/quotes/quotes_03.png');background-position: center center;background-repeat: no-repeat;width: 74px;height: 38px;float: left;} .quotes_header_c {background-image: url('images/quotes/quotes_05.png');background-repeat: repeat-x;background-position: center center;height: 38px;margin: 0 24px 0 74px;} .quotes_content_r {background-image: url('images/quotes/quotes_10.png');background-position: right center;background-repeat: repeat-y;padding-right: 15px;} .quotes_content_l {background-image: url('images/quotes/quotes_12.png');background-position: left center;background-repeat: repeat-y;padding-left: 15px;} .quotes_footer_r {background-image: url('images/quotes/quotes_16.png');background-position: center bottom;background-repeat: no-repeat;width: 24px;height: 23px;float: right;} .quotes_footer_l {background-image: url('images/quotes/quotes_13.png');background-position: center center;background-repeat: no-repeat;width: 24px;height: 23px;float: left;} .quotes_footer_c {background-image: url('images/quotes/quotes_15.png');background-position: center center;background-repeat: repeat-x;height: 24px;margin:0 24px 0 24px;} .quotes_content_line {background:white url('images/quotes/quotes_09.png') right center no-repeat;} .quotes_content_co{background:white;} .quotes_header_cont {padding-top: 18px;}
طبعاً بعد ما عملت بحث في سوالف وغيرها لم أجد أي جواب نهائياً
علماً أن لدي لوحة تحكم whm إذا ممكن أستفيد منها في حل المشكلة
شكراً
رد مع اقتباس
