Mysql replication error

Question

I am receiving an error in mysql while checking the status

mysql>SHOW MYSQL STATUS\G;

Last_SQL_Error: Error 'Incorrect key file for table './aaa_bbb/abcd_xxyyzz.MYI';
try to repair it' on query. Default database: 'aaa_bbb'.
Query: 'UPDATE abcd_xxyyzz SET abcd_xxyyzz = 12345678912, abcd_xxyyzz = 'posting.php?mode=reply&f=23&t=156&confirm_key=4DGHJNBFTH', abcd_xxyyzz_id = 11 WHERE abcd_xxyyzz_id='2dfggrehtrhfdfvsdasdsas2fsd1fdf45'

Could anybody helps to resolve the issue?

http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table — Déjà vu, Mar 17 '13 at 02:15
Well, have you tried to [repair it](http://dev.mysql.com/doc/refman/5.1/en/repair-table.html)? — adamdunson, Mar 17 '13 at 02:42
Resolved the Issue by reparing the table :) mysql> use aaa_bbb mysql> repair table abcd_xxyyzz; mysql> slave stop; mysql> slave start; — Arun Kurian, Mar 19 '13 at 16:14

score 0 · Accepted Answer · edited Dec 07 '13 at 20:14

0

We can resolve this Issue by repairing the table. In the mysql command prompt:

mysql -u username -p password
mysql> use aaa_bbb;
mysql> repair table abcd_xxyyzz;
mysql> slave stop;
mysql> slave start;

edited Dec 07 '13 at 20:14

Braiam

1
11
47
78

answered Mar 19 '13 at 22:05

Arun Kurian

33
8

Mysql replication error

1 Answers1