Results 1 to 15 of 15

Thread: Need help.. DB Crashed.. How to recover the tables..?

  1. #1
    Join Date
    Jul 2006
    Posts
    19

    Need help.. DB Crashed.. How to recover the tables..?

    hi...

    i am using the Mysql 5 in the linux operating system.
    i have nearly 50 tables. all the tables engine type is InnoDB.
    when try to acess the table, the following error comes...

    Error No : 1033 Incorrect information in file: './db_test/users.frm'

    What is this error?
    What is the solution for this error?

    i think, my DB is crashed, so how can i recover all the tables from the crashed database with all the tables data.

    Can you any one help me for this problem?

    Thanks & Regards,
    S.Ashokkumar.

  2. #2
    Join Date
    Mar 2007
    Posts
    16
    If you restart the database you will find that InnoDB tables have auto disaster recovery mechanism. If this does not overcome your problem then perhaps you have a corrupted file system or hardware fault.

  3. #3
    Join Date
    Jul 2006
    Posts
    19
    Quote Originally Posted by aschk
    If you restart the database you will find that InnoDB tables have auto disaster recovery mechanism. If this does not overcome your problem then perhaps you have a corrupted file system or hardware fault.

    hi..

    Can you explain me more clearly...? i cant get your reply.
    If you explain me clearly means, that will more useful for me.

    Whenever i access the tables, i got this error. so i need the solution for this problem.

    Thanks & Regards,
    S.Ashokkumar.

  4. #4
    Join Date
    Mar 2007
    Posts
    16
    You can try mysql_fix_privilege_tables
    although I don't believe that works for InnoDB tables.

  5. #5
    Join Date
    Mar 2007
    Posts
    16
    Make sure your /tmp directory is writeable :
    chmod 1777 /tmp

  6. #6
    Join Date
    Mar 2007
    Posts
    16
    in answer to your question : restart MySQL

  7. #7
    Join Date
    Jul 2006
    Posts
    19
    Quote Originally Posted by aschk
    in answer to your question : restart MySQL

    hi..

    tmp directory have full permission.

    For the past 1 week,i had tried to solve this. I tried in so many ways. but still i cant.

    All the tables in this database are InnoDB. but DB is crashed, so i want to recover the tables with data.
    So, Can u tell me the possible ways to solve this problem.


    Thanks & Regards,

  8. #8
    Join Date
    Mar 2007
    Posts
    16
    Have you restarted MySQL server yet?

  9. #9
    Join Date
    Mar 2007
    Posts
    16
    Where did this table come from? Did you move it from another server? Have you recently upgraded to MySQL 5?

  10. #10
    Join Date
    Jul 2006
    Posts
    19
    Quote Originally Posted by aschk
    Where did this table come from? Did you move it from another server? Have you recently upgraded to MySQL 5?
    hi...

    First of all thanks for your reply...

    From the begining itself, i am using Mysql 5. No, the table are not copied from other server. It was working fine in last 6 months, but suddenly one day, this error comes. Whenever i access the tables, the error msg comes.

    Error No : 1033 Incorrect information in file: './db_test/users.frm'

    Data's are very important, i dont have the backup also. So i am confused to recover the DB.

    Can u help me....?

    Thanks,
    S.Ashokkumar.

  11. #11
    Join Date
    Mar 2007
    Posts
    16
    Restart MySQL...

  12. #12
    Join Date
    Mar 2007
    Posts
    16
    Have you tried :
    REPAIR TABLE <table name>

  13. #13
    Join Date
    Jul 2006
    Posts
    19
    Quote Originally Posted by aschk
    Restart MySQL...

    i had restarted so many time.. but still this error comes.

    Thanks
    S.Ashokkumar

  14. #14
    Join Date
    Jul 2006
    Posts
    19
    Quote Originally Posted by aschk
    Have you tried :
    REPAIR TABLE <table name>

    yes... i tried with repair table. but i cant access the tables.

  15. #15
    Join Date
    Mar 2007
    Posts
    16
    Sounds like it's corrupted for good. If you don't have a backup then i don't believe there is any other way you can retrieve the messed up tables. Sorry...

    n.b. check your hardware, you may find you have a hard drive that will fail soon.

Posting Permissions

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