vb.org Archive - Urgent Help needed

Hi,

I recently purchased a server and after ploading my VB files then I went to do the DB only to find that when I was restoring it, certain tables and data entries were in what looks like corrupt code like:

Code:



CREATE TABLE `attachment` (



`attachmentid` int(10) unsigned NOT NULL auto_increment,

`userid` int(10) unsigned NOT NULL default '0',

`dateline` int(10) unsigned NOT NULL default '0',

`thumbnail_dateline` int(10) unsigned NOT NULL default '0',

`filename` varchar(100) NOT NULL default '',

`filedata` mediumtext NOT NULL,

`visible` smallint(5) unsigned NOT NULL default '0',

' counter` smallint(5) unsigned NOT NULL default '0',

`filesize` int(10) unsigned NOT NULL default '0',

`postid` int(10) unsigned NOT NULL default '0',

`filehash` varchar(32) NOT NULL default '',

`posthash` varchar(32) NOT NULL default '',

`thumbnail` mediumtext NOT NULL,

`thumbnail_filesize` int(10) unsigned NOT NULL default '0',



PRIMARY KEY (`attachmentid`),



KEY `filesize` (`filesize`),



KEY `filehash` (`filehash`),



KEY `userid` (`userid`),



KEY `posthash` (`posthash`,`userid`),



KEY `postid` (`postid`)



) TYPE=MyISAM;



--



-- Dumping data for table `attachment`



--



INSERT INTO `attachment` (`attachmentid`, `userid`, `dateline`, `thumbnail_dateline`, `filename`, `filedata`, `visible`, `counter`, `filesize`, `postid`, `filehash`, `posthash`, `thumbnail`, `thumbnail_filesize`) VALUES (1,18,1098798432,0,'harold.jpg','????\0JFIF\0\0H\0H\0\0??\0C\0  \n



 



\r







 \Z- \Z $.\' \",#(7),01444\'9=82<.342??\0C 



 





\r\r2!!22222222222222222222222222222222222222222222222222??\0\0V\0|\0??\0\0\0\0\0\0\0\0\0\0\0\0\0 \0??\09\0 \0\0\0\0\0!1AQa \"q??2???BRbr??#$%3c???\0\0\0\0\0\0\0\0\0\0\0\0\0\0??\0 \0\0\0\0\0\0\0!1AQ2??\0



 



\0\0?\0?EA@X4}?G?\Z\Zc??)U ????u?!?c??r,???2~??!y?S?VYg<??????-Ƒ?DnY{?Ώ??]?u Ke?!\0?3?GԬ?8?3`doM?? %?(?5?????0?h?K??p?36MTI?l\ne]?(\0C?n?v??hg6D1?x?\'??U?-?S̸$?\0?Y?tӎn?????Xߕs[?????(f?????1??[o$



 



?î\Z>?*R?Y??q??j1[?a#,q????,?D?B?88? ?ٳ?D5??\0???i|??k?



 



v??d?\0j???s?F9X????O???+?????.????y?\0???7?? \\??b?L???e?Y"???|jkL<K?w??.??\'rjj????$?f)?eB}?X???1??I???8?ۣo??Q5[[g?V\Z? ?&2??K



 



???q??y??:???pK-U?7S???=?+t ??g?ZCp˕_u\0?:??\\y???!??^w???*7Q? ?\rŨ??"K???+?ݷ??)n???k?@?-?ҷz



 



Б??w??6??sU?JȮ?+??3b??\\?n\'l???<J???????\'l???J/?\\E\'X-ld??ڱ?~?8???k?$;Ȍ@??f????^"k?&?r?5???l6???Ux???z;?{?$&??#?????K??????\\oq!??\Z????`uI,9?+?[???{ ?q??%?@??????l?P6?\n?T??+?۪Z?pX??cr?uc??Ah????~??/?=??./.?(?#F?؁?w?j3??׊?(???#u[c????)?<9???U_? ???\Z???+ɆgA?\\??JSu?z???\'k#??zPOQ ?<e???? ?8TȂO????v???$ȇ



 



j??ji????n?LmU?"?Ǣ?׺??4?I.%U?



 



|Iڳ????˖???bO$_]"v?X-???͏??Z???l?$?-qhZw?U?,!?28x?}? <?tɎ?<??űZ?c?-ę~-??\'/?M?????Y-??HPu?1??s?\0?y???K??͟?<E-?sa%ػ$D?



 



@x??m??rrsn?????v}*?"?c?(?Q??*??P??



???.?c,0 ???)?J?d-? +???H ?L?



{&??< ??8?D?ׯ



?



 



x%In??v?y? ?A ?"????Y?u+Ώ??5d???? ?܌ӳ????H?GDҦ???M:\0?w*d.xA;?=Oʜ?m?7??3i??????@@??W??-?m&? ?f1??]?Ƃ?Oo\r???\Z????˦o?#???Cv???(x?h2G?ӝU?*?ϼ1??P?^A{\Z۸??>G?m?Q!kM#?~ͬ?3????%?? 9????"?9\' ?c?:tm-?P?<w??>? r1?(??v??q??A]g@???ϟl71??z??Ye??\rw?2???S??FrEe??u



 



r?a?



???J\n]?1?l?;?%??Inc+.1???Ѣ`?h\"???\0?6Ri^???T?\\V?e?+??=??fUY????L6?W#?X???>F????qL5?Z???$fE?\0?ٟ!?u&??,H??i?M??dԎtY?Vi,1? ??PVtQ?P\"4?/?



 



??[??#?\"??g?1?????(ƣ????\\\'IW?ϵ5k~s\'?g!??? ?ȧ????q?M<2a? ?{???*??A??\0???Y?P?0?ȃen??k-LQ?)?\rJ?? ????_^?O?` .*X??tL8??????G>?\Zy??????o?????





A&???6?s



 

$SŏA?\\?k?MF<????c??9bpz?\n?{??:2??̍?O?\r\"?K??? ??? XL?Ƅu?(?a,*?l???3??\0pT???o]? .{k???E*????????!?I?Ko??9"



 



???K"?V??D?9??Vm?T??e>#????-j??~?{\Z??<H??ʁ? !Ŋ?h?yj\0R1?H??!?Pf-Ӎ\"N|X??n????\0J?s?6+\0~\"?O? ?6??ra$F????_?{?Q??&??<o;???s?=\rw?????????\rn??2????ڢ???I?C?P?_ʫ]/[?ڞ?? ?4?9߈??1??*??q???-????^?\0\Z?[???by??(?Զ???)-n?)pj??"Y??<;.??4???m?|??&x?i?5???>`?? ?????A?R48???b\\?g?w??Y???oro???? _q????+?1???Wu?G#O?Y?er?̼??փ?.?\0?Z!???c?????\0?P?????΅??x??????MF^?? ?R5? ??Q?> ?C?OO?c?9?



 



v \rW?~?]/???2HZ?9\Z?L?e??m?xĈ\\????R??<??kh?/ ???\ZF??\Z֟?݄9>??Oz,?Nɞ?m



 



WB??#$ҹ???#?*t??',1,45,2667,25553,'90e75745de55fbd86cd01b01cbf79ae6','','',0);



 



INSERT INTO `attachment` (`attachmentid`, `userid`, `dateline`, `thumbnail_dateline`, `filename`, `filedata`, `visible`, `counter`, `filesize`, `postid`, `filehash`, `posthash`, `thumbnail`, `thumbnail_filesize`) VALUES (2,72,1098838255,0,'post-18-1098776532.jpg','????-DExif\0\0II*\0\0\0\0

Then it goes on for ages, same stuff around the cronlog and datastore area, not even got half way through yet. This was a straight backup from VB admin area on one forum. The forums were meant to reopen at 8pm tonight and I don't know what the problem is. I just posted over on VB official site then thought of posing here

Thanks in Advance
Danny

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01056 seconds Memory Usage 1,748KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: