Announcement

Collapse
No announcement yet.

Just moved to new server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Just moved to new server

    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:
    [size=2]
    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][email protected]…¼¤ÏŸ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
    [/size]


    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 will continue over to VB.org to see if I can find anything, just thought I would post here first though

    Thanks in Advance
    SupaJ

  • #2
    Anybody?

    Comment


    • #3
      Attachments are stored in binary. They are supposed to look like that in a SQL Dump.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X