I_Love_Leythers
03-07-2005, 12:50 PM
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:
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! !2222222222222222222222222222222222222222 2222222222??\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,'90e75745de 55fbd86cd01b01cbf79ae6','','',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
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:
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! !2222222222222222222222222222222222222222 2222222222??\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,'90e75745de 55fbd86cd01b01cbf79ae6','','',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