Slide

  • LINUX

    LINUX:In 1969 AT&T made a decision to withdraw Multics and go with GECOS (General Electric Comprehensive Operating Supervisor / System), with AT & T in Bells Lab when Multics was withdrawn some of the programmers named Ken Thompson and Dennis Ritchie decided to rewrite operating system in order to support low cost computer..To Know More

    CLICK HERE

  • MICROSOFT

    MICROSOFT:Microsoft was established to develop and sell BASIC interpreters for the Altair 8800. It rose to dominate the home computer operating system market with MS-DOS in the mid-1980s,followed by the Microsoft Windows line of operating systems. To Know More

    CLICK HERE

  • CISCO

    CISCO:During the early 1980s, there was a married couple namely Len and Sandy Bosack who used to work in two different departments of computer located in Stanford University. This couple was facing problem in making their computers communicate with each other To Know More

    CLICK HERE

showinfo=1

Repairing a Corrupted Table In Mysql


Repairing a Corrupted Table In Mysql


A Table name aggregator_item.MYI  got corrupted in database name rnmbase. we will now repair the Table so that replication work fine.



ERROR: - reports error in replication: Error 'Incorrect key file for table './rnmbase/aggregator_item.MYI'; try to repair it' on query. Default database: 'rnmbase'.

Solution:-

Stop mysql instance where the replication error came


# service mysqld  stop


To check the error

# myisamchk  /var/lib/mysql/rnmbase/aggregator_item.MYI

To fix the error

# myisamchk  -r /var/lib/mysql/rnmbase/aggregator_item.MYI

To check the error

# myisamchk  /var/lib/mysql/rnmbase/aggregator_item.MYI

Start mysql

# service mysqld start

Go to mysql prompt check the slave is running or not if not running start the slave

# mysql

Mysql>  show slave status\G

Mysql> start slave;

Mysql>  show slave status\G

Mysql> quite;


Note:- rep_mon should be installed......
# rep_mon     -------> to check replication status

3 comments:

Note:- Comment as: Option available to post without login select "Anonymous" from the drop down...........

For Latest Updates: Subscribe Now | | Test Your Knowledge, Take a Quiz now Click Here | | Site Best Viewed In Firefox

X