070-8260-2526

ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù

352-0331-1626-83

¿¹±ÝÁÖ:°­¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ


ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®

Á¶È¸¼ö 8211
Áú¹® MYSQL ¿¡·¯ Table '...' is marked as crashed and should be repaired
µ¥ÀÌÅͺ£À̽º  Äõ¸® ±¸¹® ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ¼ÒÇÁÆ®¿þ¾îÀÇ ¹ö±×°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ¸¶Áö¸·À¸·Î ¿äûÇÑ µ¥ÀÌÅͺ£À̽º Äõ¸®´Â "SearchMySQL4::update" ÇÔ¼ö¿¡¼­ ¾²ÀÎ
    (SQL query hidden)
ÀÔ´Ï´Ù. MySQLÀº "145: Table './wikidb/eedoc_searchindex' is marked as crashed and should be repaired (localhost)" ¿À·ù¸¦ ³Â½À´Ï´Ù.
¾î¼³ë <(-_-)>

http://blueb.net/blog/346
´ÙÇàÈ÷ ´©°¡ ÀÌ¹Ì °Þ¾ú´Ù.
ÀÏ´Ü ÀÚ·á ¹é¾÷À» Çسõ°í µé¾î°¡½Ã¿À. DBÀÇ ¹ÙÀ̳ʸ®ÆÄÀÏ ¾îµò°¡ º¹»ç.
 
DB¿¡¼­
mysql> repair table product; //"product"´Â ¿À·ù°¡ »ý±ä Å×À̺í ÀÔ´Ï´Ù.
ÇϽñâ Àü¿¡
mysql>analyze table product;¸¦ ½ÇÇàÇϸé Å×ÀÌºí¿¡ ´ëÇÑ º¸°í¼­°¡ ÀÛ¼ºµË´Ï´Ù.
±×¸®°í ³ª¼­
mysql>repair table product;¸¦ ½ÇÇàÇÏ¸é º¹¿øÀÌ µË´Ï´Ù.
¶ó°í ÇÑ´Ù.
±×·¡µµ ¾È ÅëÇÏ´Â °æ¿ì°¡ ÀÖ´Ù.
ÇÊÀÚ´Â ÅëÇÏ´Â °æ¿ì, ¾È ÅëÇÏ´Â °æ¿ì µÑ ´Ù °Þ¾îºÃ´Ù ¤Ð¤Ð;;

¿ª½Ã  ¹Ýµå½Ã ¹é¾÷À» Çصΰí...
http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2
 
 $ myisamchk -r Å×À̺íÆÄÀÏ
À» ¼öÇà½ÃŲ´Ù
ÇÊÀÚ´Â ¿©±â¼­ »ì¸± ¼ö ÀÖ¾ú´Ù

Å©¸®¿¡ÀÌƼºê Ä¿¸ÕÁî ¶óÀ̼±½º
Creative Commons License