vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Urgent Help needed (https://vborg.vbsupport.ru/showthread.php?t=77658)

I_Love_Leythers 03-07-2005 12:50 PM
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

eva01_ 03-07-2005 01:07 PM
do you have any other backups

seems like the backup you made was corrupt

I_Love_Leythers 03-07-2005 01:09 PM
The thing is thwe last few times they have been corrupt, is this a VB problem?

Danny

eva01_ 03-07-2005 01:12 PM
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 03-07-2005 01:20 PM
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_ 03-07-2005 01:22 PM
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 03-07-2005 01:42 PM
Thanks very much for your time and help :D

Danny

lasto 03-07-2005 01:52 PM
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_ 03-07-2005 01:57 PM
i have never had a database look like that ever, even with pictures in the database.

Marco van Herwaarden 03-07-2005 02:11 PM
Well it is simple: check the last 10 lines of the backup file wih any editor.

If it contains a nice closed set of inserts into the "Word" table, the backup seem to be complete.

lasto 03-07-2005 02:11 PM
Quote:
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.

eva01_ 03-07-2005 02:32 PM
maybe i just haven't looked hard at them before or the program i use to look at them makes it look different or something.

but i digress

i would go for the restore now since it can't do any harm anyways.

Zachery 03-07-2005 02:57 PM
That dump looks fine, that wierd code is biniary data from attachments

Greebo 03-07-2005 05:06 PM
My backups look like that all the time. Like Zachery said, that's just the binary attachment being converted to string data. Notice how at the end of the big long blob of garbage, the text returns to normal - and the insert is for the Attachment table. :) Those clues say the file is fine.

I_Love_Leythers 03-08-2005 08:14 AM
Well I tried to restore it and it said it hadnt closed a ) in the attachment bit. Anyway you can close this if you want now because the old host server acm back online and I just got the DB through WHM transfer :D

Thanks
Danny


All times are GMT. The time now is 10:02 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01195 seconds
  • Memory Usage 1,758KB
  • 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (15)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete