No announcement yet.

Any possibility to combine a damaged database with a clean one?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Any possibility to combine a damaged database with a clean one?

    Hello everybody out there,

    I have a really huge problem with my database.

    vBB 3.0 rc 3

    Link to Board
    OS: SuSe Linux

    Obviously somebody/something damaged the database, to substanitate, the tables posthash and threadviews.

    Anyway, I'm in need to move the board to a new box but, otherwise it wouldn't be that problem (yeah, slap me, I think it would be deserved ) there are no backups available.

    First of all the error which occurs when I try to post something new:

    Database error in vBulletin 3.0.0 Release Candidate 3:
    Invalid SQL:
    INSERT INTO posthash
    (userid, threadid, dupehash, dateline)
    (1, 0, '949db4f2416354251fd684d2939f08fe', 1077741777)

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Wednesday 25th of February 2004 09:42:57 PM
    Username: xxx
    IP Address: xxx
    I tried to fix the database with MySQL-Front. Doesn't work. I tried myisamchk -r, doesn't work. Just creating a mysql dump doesn't work at all, therefore I created database dump of all tables except posthash and threadviews.

    Is there any possibiliy to add these information into the more or less complete database manually? Could anybody out here provide me with the missing parts? Or could I just install a clean version of the same vBB version and try to replace all tables which are available in my dump and keep the others? Anybody an idea which putty/ssh command could be usefull? btw... I've more or less no idea about the administration of linux servers.. :/

    Thank you very much!

    Best regards from Germany.
    Johannes Lomnitz

  • #2
    Error code 28: No space left on device

    Either the swap, a partition, temp directory or hard drive on the web server is out of space or doesn't have enough space to complete the above operation.

    This is a server issue, you need to contact your hosting provider to get more space to write to. I advice you to shut down your forum to prevent more errors or data loss.


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