Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
µ¥ÀÌÅͺ£À̽º(database)
>
MySQL
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
Mysql DB ±úÁ³À»¶§ »ì¸®´Â¹ý (myisamchk) (±Û chongnux)
ÀÛ¼ºÀÏ : 2003/10/18 21:48
±Û¾´ÀÌ : ÁÁÀºÁøÈ£ (
http://coffeenix.net/
)
Á¶È¸¼ö : 6750
[
ÀÌÀüȸé
/
¼öÁ¤
] ºñ¹Ð¹øÈ£ :
Ãâó : 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 ¸í·É¾î¸¦ ÀÌ¿ë º¹±¸ °¡´ÉÇÕ´Ï´Ù. °¡´ÉÇÑ µ¥ÀÌÅͺ£À̽º¸¦ Á¤ÁöÇÏ°í Çϼ¼¿ä.
±×·³.. ¹«¿îÀ» º÷´Ï´Ù. Àü º¹±¸ Çß¾î¿ä.
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[04/25]
±¹°¡
[04/24]
º¸Çè
[04/22]
Re: OpenSSL Ãë¾àÁ¡ Á¤¸®, Logjam(·Î±×Àë)¿¡¼ Heartbleed±îÁö
[04/21]
LET¡¯S START WITH ON
[04/21]
º¸Çè
[04/20]
Á¦ÁÖ
[04/20]
±¹³»
[04/19]
Á¦ÁÖ
[04/18]
??? ?????
[04/17]
???? onion ?????? -
[04/11]
±¹°¡
[04/10]
Stride Into Dream:
[03/20]
Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
[10/20]
Cross Compiler ±ò
[07/14]
SSL ¬¡¬°
N
e
w
! ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
QCad for Windows --- GNU GPL (Free Software)
The Hello World Collection
IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼¹ö°ü¸®
DNS ¼³Á¤ °Ë»ç
nagiosgraph ¼³Ä¡ ¹æ¹ý
Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
clusterssh
[ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]
¿î¿µÁø :
ÁÁÀºÁøÈ£(truefeel)
, ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
2003³â 8¿ù 4ÀÏ~