-
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.
-
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.
-
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.
-
You can try mysql_fix_privilege_tables
although I don't believe that works for InnoDB tables.
-
Make sure your /tmp directory is writeable :
chmod 1777 /tmp
-
in answer to your question : restart MySQL
-
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,
-
Have you restarted MySQL server yet?
-
Where did this table come from? Did you move it from another server? Have you recently upgraded to MySQL 5?
-
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.
-
-
Have you tried :
REPAIR TABLE <table name>
-
Originally Posted by aschk
Restart MySQL...
i had restarted so many time.. but still this error comes.
Thanks
S.Ashokkumar
-
Originally Posted by aschk
Have you tried :
REPAIR TABLE <table name>
yes... i tried with repair table. but i cant access the tables.
-
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
-
Forum Rules
|
|