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

Printable View

03-26-2007, 04:12 AM
ashokkumar

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.
03-26-2007, 04:40 AM
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.
03-26-2007, 04:46 AM
ashokkumar

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.
03-26-2007, 04:47 AM
aschk

You can try mysql_fix_privilege_tables
although I don't believe that works for InnoDB tables.
03-26-2007, 04:48 AM
aschk

Make sure your /tmp directory is writeable :
chmod 1777 /tmp
03-26-2007, 04:49 AM
aschk

in answer to your question : restart MySQL
03-26-2007, 04:59 AM
ashokkumar

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,
03-26-2007, 05:02 AM
aschk

Have you restarted MySQL server yet?
03-26-2007, 05:02 AM
aschk

Where did this table come from? Did you move it from another server? Have you recently upgraded to MySQL 5?
03-26-2007, 05:09 AM
ashokkumar

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.
03-26-2007, 05:17 AM
aschk

Restart MySQL...
03-26-2007, 05:19 AM
aschk

Have you tried :
REPAIR TABLE <table name>
03-26-2007, 05:20 AM
ashokkumar

Quote:

Originally Posted by aschk

Restart MySQL...

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

Thanks
S.Ashokkumar
03-26-2007, 05:22 AM
ashokkumar

Quote:

Originally Posted by aschk

Have you tried :
REPAIR TABLE <table name>

yes... i tried with repair table. but i cant access the tables.
03-26-2007, 05:35 AM
aschk

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.