Web Hosting Forums

Results 1 to 5 of 5

This is a discussion on Need MySQL Help in the Hosting Talk & Chit-chat forum
Following the restoration of Draco, my DB seems to be hosed. When attempting to access the SMF forums, I get a smf_messages.MYD' not found (Errcode: ...

  1. #1
    Loyal Client
    Join Date
    Feb 2007
    Posts
    85

    Exclamation Need MySQL Help

    Following the restoration of Draco, my DB seems to be hosed. When attempting to access the SMF forums, I get a smf_messages.MYD' not found (Errcode: 2) error message. In PHPMyAdmin, the table is showing as 'in use'.


    I've tried flushing the tables: No dice

    I've tried analyzing the table, checking the table, and repairing the table, both through PHPMyAdmin and command line with no luck.

    Is this thing completely hosed? I have a backup that I can try to restore it with, but it would be much easier to fix the existing one.

    Thanks for any assistance you might provide...

  2. #2
    Ron
    Ron is offline
    Loyal Client
    Join Date
    Aug 2002
    Posts
    7,503
    It's likely hosed, but as a Hail Mary you could ask support if the file exists on the backup. Unlikely.
    Good luck

  3. #3
    Loyal Client
    Join Date
    Feb 2007
    Posts
    85
    Quote Originally Posted by Ron View Post
    It's likely hosed, but as a Hail Mary you could ask support if the file exists on the backup. Unlikely.
    Hmmm. That's an idea...


    Might just give that a shot.


    I think I'll wait till Vin DSL sees this before I drop the DB though...

  4. #4
    Loyal Client
    Join Date
    Feb 2007
    Posts
    85
    That thing was hosed, and my DB BU was more current than the restore point.

    I did have support upload the DB 'cause PHPMyAdmin kept choking on it.

    Overall...


  5. #5
    Loyal Client thisisit3's Avatar
    Join Date
    Mar 2007
    Posts
    743
    The problem with backups and SQL databases is that the backup system usually doesn't "talk" to the database properly.

    Almost all backup systems just copy the files of the SQL database, which is wrong, since a "live" database is making modifications in memory. Which results in a badly restored database, inconsistent tables, inconsistent relationships, lost indexes, etc.

    The proper way to backup a database is to use a database-specific method, for example a MySQL snapshot that uses the Binary Log or something similar. Otherwise, you have to shut-down the entire database, take your backup and restart the database, which of course means downtime.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •