SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Mincer's Avatar
    Join Date
    Mar 2001
    Location
    London | UK
    Posts
    1,140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Single table in DB gone pear shaped - help.

    Why does this always happen when it's my week off?

    Anyway, it appears that one table in a database called 'user' has become foobar'd in some way, when trying to access it via cmd line or phpmyadmin, I get the error:

    Code:
    Can't open file: 'user.MYI'. (errno: 145)
    I can access all other tables in the database just fine.

    Does this mean that there is some problem other than just one table becoming corrupted?

    I have a full mysqldump of the entire database.

    If I can just rebuild the user table, what is the best way to restore it from the full database backup I have?

    Many thanks,

    Matt.

  2. #2
    SitePoint Wizard Mincer's Avatar
    Join Date
    Mar 2001
    Location
    London | UK
    Posts
    1,140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ah, it's ok. I've been able to repair the table.


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
  •