MySQL Forums
Forum List  »  MySQL Administrator

Database corruption
Posted by: omkar prabhu
Date: November 02, 2009 12:05PM

We are using mysql 5.0 with master slave setup. When we describe any table it gives following error
Error 'Incorrect information in file: './livedb/tablename.frm
Master database looks ok, only slave is having problem,when we do show slave status, we see below information


Replicate_Wild_Ignore_Table:
Last_Errno: 1033
Last_Error: Error 'Incorrect information in file: './livedb/print.frm'' on query. Default database: 'livedb2'. Query: 'DELETE FROM livedb.print WHERE TIMESTAMPDIFF(dayvalue, date_created, '2009-11-02 01:58:06') >= 9999'
Skip_Counter: 0
Exec_Master_Log_Pos: 653241805
Relay_Log_Space: 3073839
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Can anyone let me know how to trouble shoot this issue ie. reason behind this issue and how to go about fixing it?

Options: ReplyQuote


Subject
Written By
Posted
Database corruption
November 02, 2009 12:05PM
November 02, 2009 03:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.