Mysql DB ±úÁ³À»¶§ »ì¸®´Â¹ý (myisamchk) (±Û chongnux) | ÀÛ¼ºÀÏ : 2003/10/18 21:48 |
Á¶È¸¼ö : 6751 |
Ãâó : KLDP BBS, http://bbs.kldp.org/viewtopic.php?t=25981 -------------------------------------------------------------- ±Û¾´ÀÌ : chongnux ¿Ã·ÁÁü: 2003³â10¿ù13ÀÏ 14:10 ÁÖÁ¦: Mysql DB °¡ ±úÁ³À»¶§ »ì¸®´Â¹ý (myisamchk) ¾î´À³¯ ¾Æħ ·Î±äÀÌ ¾ÈµÇ°Å³ª ȤÀº °Ô½ÃÆÇ¿¡¼ µ¥ÀÌÅÍ º£À̽º ¿¢¼¼½º¸¦ ÇÒ¼ö ¾ø½À´Ï´Ù.. ÀÌ·± ¸Þ¼¼Áö¸¦ º¼¼ö ÀÖ´Ù. ³°¨Çϱ⠱×Áö ¾ø´Ù... ¾î¶»°Ô ±Øº¹À» ÇÒ°ÍÀΰ¡... ? µ¥ÀÌÅÍ º£À̽º´Â Ç×»ó ±úÁö±â ¸¶·ÃÀÌ´Ù. 1³âÀº ¿î¿µÇÑ´Ù¸é.. Àû¾îµµ 1~2ȸ Á¤µµ´Â ÈÀÏÀ» ¿¼ö ¾ø½À´Ï´Ù. ¿¡·¯ ¸Þ¼¼Áö : ERROR 1016: Can't open file: 'xxxxxx.MYD'. (errno: 145) ¸¸¾à /usr/local/mysql/var/µ¥ÀÌÅÍ º£À̽º¿¡ µé¾î °¡¸é °¢°¢ÀÇ ºÎºÐ¿¡ ´ëÇÏ¿© *.FRM : Å×À̺í Á¤º¸ *.MYI : À妽º Á¤º¸ *.MYD : µ¥ÀÌŸ Á¤º¸ [root@ilinuxbay ]# /usr/local/mysql/bin/myisamchk sessions.* myisamchk: error: 'sessions.MYD' is not a MyISAM-table --------- Checking MyISAM file: sessions.MYI Data records: 6 Deleted blocks: 6 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain myisamchk: warning: Not used space is supposed to be: 896 but is: 624 myisamchk: error: record delete-link-chain corrupted - check index reference - check data record references index: 1 myisamchk: error: Found 4 keys of 6 - check record links myisamchk: error: Record-count is not ok; is 4 Should be: 6 myisamchk: warning: Found 4 deleted blocks Should be: 6 myisamchk: warning: Found 8 parts Should be: 11 parts MyISAM-table 'sessions.MYI' is corrupted Fix it using switch "-r" or "-o" --------- ´©°¡ Áö¿ü³ª.. ȤÀº ÈÀÏÀÌ ¾ø´Â °æ¿ì ´ÙÀ½°ú °°Àº ¸í·É¾î¸¦ ÀÌ¿ë È®ÀÎ º¹±¸¸¦ ÇÒ ¼ö ÀÖ´Ù. ]#myisamchk ¿É¼ÇÀ» º¸¸é # -r -o·Î º¹±¸°¡ ¾ÈµÇ¸é´Ù -f ¿É¼ÇÀ» ÀÌ¿ëÇÑ´Ù. -f, --force Overwrite old temporary files. #º¹±¸ -r, --recover Can fix almost anything except unique keys that aren't unique. #¾ÈÀüÇÏ°Ô º¹±¸ -o, --safe-recover Uses old recovery method; Slower than '-r' but can handle a couple of cases where '-r' reports that it can't fix the data file. #µ¥ÀÌÅÍ Á¤·Ä ¹× ¼Óµµ Áõ°¡ -R1 Àúµµ ÁÖ¸é µÉµí ½Í³×¿ä -R, --sort-records=# Sort records according to an index. This makes your data much more localized and may speed up things ÀϹÝÀûÀ¸·Î -r À» ±âº»À¸·Î »ç¿ëÇÏ¸ç ´ë»ó ÈÀÏÀº * È®ÀåÀÚ¸¦ ÀâÀ¸¸é µÈ´Ù. ±×·³ º¹±¸¸¦ Çغ¸ÀÚ. [root@ilinuxbay ]# /usr/local/mysql/bin/myisamchk -r sessions.* myisamchk: error: 'sessions.MYD' is not a MyISAM-table --------- - recovering (with sort) MyISAM-table 'sessions.MYI' Data records: 6 - Fixing index 1 Data records: 4 --------- Ȥ ±¸¹öÀüÀÎ °æ¿ì isamchk ¸í·É¾î¸¦ ÀÌ¿ë º¹±¸ °¡´ÉÇÕ´Ï´Ù. °¡´ÉÇÑ µ¥ÀÌÅͺ£À̽º¸¦ Á¤ÁöÇÏ°í Çϼ¼¿ä. ±×·³.. ¹«¿îÀ» º÷´Ï´Ù. Àü º¹±¸ Çß¾î¿ä. |
Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ / URL : http://coffeenix.net/board_view.php?bd_code=101 |