ÄÄÇ»ÅÍ¿Í °ü·ÃÀÖ´Â ¸ðµç ÆÁÀ» °øÀ¯ÇսôÙ.

# mysql -u »ç¿ëÀÚ -p µ¥ÀÌŸº£À̽º

Didn't find any fields in table 'tt_Sessions'

mysql¿¡ Á¢¼ÓÇϸé À§¿Í°°Àº ¿¡·¯¸Þ¼¼Áö°¡ ³ªÅ¸³­´Ù.

mysql> check table tt_Sessions;
+-----------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------+-------+----------+----------------------------------------------------------+
| Rhc.tt_Sessions | check | warning | Table is marked as crashed |
| Rhc.tt_Sessions | check | warning | 6 clients are using or haven't closed the table properly |
| Rhc.tt_Sessions | check | error | Record at pos: 17416 is not remove-marked |
| Rhc.tt_Sessions | check | error | record delete-link-chain corrupted |
| Rhc.tt_Sessions | check | error | Corrupt |
+-----------------+-------+----------+----------------------------------------------------------+
5 rows in set (0.04 sec)

mysql> repair table tt_Sessions;
+-----------------+--------+----------+------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+------------------------------------+
| Rhc.tt_Sessions | repair | warning | Number of rows changed from 8 to 7 |
| Rhc.tt_Sessions | repair | status | OK |
+-----------------+--------+----------+------------------------------------+
2 rows in set (0.09 sec)

mysql> check table tt_Sessions;
+-----------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------+-------+----------+----------+
| Rhc.tt_Sessions | check | status | OK |
+-----------------+-------+----------+----------+
1 row in set (0.00 sec)





TAG : mysql 

tagÁ¦¸ñ³»¿ëÀÛ¼ºÀÚ