Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
µ¥ÀÌÅͺ£À̽º(database)
>
MySQL
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
MySQL ±âµ¿½Ã ÀÚµ¿ ÆÄÀÏ º¹±¸ ±â´É (±Û ±èÁÖÇö)
ÀÛ¼ºÀÏ : 2003/10/22 23:31
±Û¾´ÀÌ : ÁÁÀºÁøÈ£ (
http://coffeenix.net/
)
Á¶È¸¼ö : 7458
[
ÀÌÀüȸé
/
¼öÁ¤
] ºñ¹Ð¹øÈ£ :
Ãâó : ¸®´ª½º »ç¶û³Ý
http://linux-sarang.net/board/?p=read&table=tip&no=6619
-----------------------------------------------------------------------
2003¹ø: MySQL ±âµ¿½Ã ÀÚµ¿ ÆÄÀÏ º¹±¸ ±â´É
±Û¾´ÀÌ: ±èÁÖÇö ¡¡¡¡¡¡±Û¾´³¯: 2002-06-17 13:47:19 ¡¡¡¡¡¡ÀÐÀº¼ö: 662
°©ÀÛ½º·± Á¤ÀüÀ̳ª Çϵå¿þ¾îÀÇ ¿À·ù ±âŸ ¾î¶°ÇÑ ÀÌÀ¯·Î table fileÀÌ
¼Õ»óµÉ ¼ö ÀÖ½À´Ï´Ù.
ÀÌ °æ¿ì Myisamchk ³ª check table¸í·É¾î¸¦ »ç¿ëÇÏ¿© ¼öµ¿À¸·Î º¹±¸ÇÏ¿©¾ß
Çϴµ¥ ÀÚµ¿À¸·Î º¹±¸ÇÏ´Â ¹æ¹ýµµ ÀÖ¾î¼ ¼Ò°³Çص帳´Ï´Ù.
ÀÌ ±â´ÉÀº MySQL±âµ¿½Ã table ÀÌ crash markingÀÌ µÇ¾î ÀÖ´ÂÁö ȤÀº ÀûÀýÈ÷ close µÇÁö ¾Ê¾Ò´ÂÁö üũÇÏ´Â ±â´ÉÀ¸·Î mysqld ÀÇ ÆĶó¸ÞÅÍ·Î ÁöÁ¤ÇØÁÖµµ·Ï µÇ¾î ÀÖ½À´Ï´Ù.
--myisam-recover = {default | backup | force | quick }
DEFAULT : ÀÌ ¿É¼ÇÀº ¾Æ¹« ¿É¼Çµµ ÁÖÁö ¾ÊÀº °Í°ú µ¿ÀÏÇÑ Àǹ̷ΠÀÚµ¿ º¹±¸¸¦ »ç¿ëÇÏÁö ¾Ê´Â´Ù´Â ÀǹÌÀÔ´Ï´Ù.
BACKUP : ÃßõÇÏ´Â ¿É¼ÇÀ¸·Î º¹±¸Áß º¯°æµÇ´Â Å×À̺íÀº BAKÈ®ÀåÀÚ¸¦ ºÙ¿©¼
¹é¾÷À» Çسõ°í º¹±¸¿¡ µé¾î°£´Ù´Â ¿É¼ÇÀÔ´Ï´Ù.
À̸¦Å׸é table_name.MYD ÀÇ table_name-datetime.BAK ¹é¾÷ ÆÄÀÏÀÌ
¸¸µé¾îÁö°í ÀÚµ¿ º¹±¸¿¡ µé¾î°©´Ï´Ù.
FORCE : º¹±¸½Ã Å×ÀÌŸ ¼Õ½ÇÀÌ ÀϾ°Å³ª ¸»°Å³ª °Á¦·Î º¹±¸ÇÏ´Â ¿É¼ÇÀÔ´Ï´Ù.
QUICK: ¸¸¾à Å×ÀÌºí¿¡ ¾î¶°ÇÑ »èÁ¦µÈ ºí¶ôµµ ¾ø´Ù¸é table¿¡ row¸¦ Á¡°ËÇÏÁö
¾Ê½À´Ï´Ù. ¼Óµµ´Â ºü¸£Áö¸¸ ¿Ïº®ÇÑ º¹±¸´Â º¸ÀåÇÒ ¼ö ¾ø½À´Ï´Ù.
/etc/rc.d/init.d/mysql °°Àº startup script¿¡ ¾Æ·¡ ºÎºÐÀ» ¼öÁ¤ÇØÁֽðí MySQLÀ» Àç½ÃÀÛÇÏ½Ã¸é µË´Ï´Ù.
.
.
.
case "$mode" in
'start')
# Start daemon
if test -x $bindir/safe_mysqld
then
$bindir/safe_mysqld --myisam-recover=backup (¼öÁ¤ÇÒ ºÎºÐ)
~~~~~~~~~~~~~~~~~~~~~~~
.
.
.
service mysql stop (MySQLÁß´Ü)
service mysql start (MySQLÀç½ÃÀÛ)
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[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ÀÏ~