Urgent Help needed

[I_Love_Leythers]

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!!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

[eva01_]

do you have any other backups

seems like the backup you made was corrupt

[I_Love_Leythers]

The thing is thwe last few times they have been corrupt, is this a VB problem?

Danny

[eva01_]

well how did you do the back-up via the admincp

if so try and do it via SSH or through cPanel (if you have cPanel that is)

[I_Love_Leythers]

I would but my host didn't take kindly to me getting my own server (not a very friendly one but reliable) then he suspended my account, Then he unsuspended it and the server i used to use went down. As soon as it comes back I will try a WHM transfer but I suppose I will have to sit and wait

Danny

[eva01_]

yep do a backup that way, or use SSH. and i think it is illegal for them to suspend your account if you had paid for that month just because your getting a new host.

and fyi, never tell your host your leaving them until you have everything you need, just in case they do this to you.

[I_Love_Leythers]

Thanks very much for your time and help

Danny

[lasto]

databse dont look corrupt to me - that info above could be anything such as pics stored in the actual database.I have restored many databases with data that looks like that though Mysqlfront with Nps whatsoever.

[eva01_]

i have never had a database look like that ever, even with pictures in the database.

[lasto]

Originally Posted by eva01_

i have never had a database look like that ever, even with pictures in the database.

so how would the code look for an attachment which is stored in the database ?
Ive had many databases look exactly like that and have restored them to live site fine and to localhost fine.Until i seen this post i just assumed it was natural.