숀패밀리

mysql 데이터 파일 체크하기

아래와 같이 쉘스크립트 생성후 실행합니다 경로는 환경에 맞게 수정하세요

#!/bin/sh

if [ -z $1 ]; then
echo "usage: $0 DB_NAME"
exit 1
fi

FILES=`ls /usr/local/mysql/data/$1/*{ISM,MYI} 2> /dev/null`

for target_file in $FILES; do
if [ "X${target_file##*.}" = "XISM" ]; then
chktool="isamchk"
else
chktool="myisamchk"
fi
/usr/local/mysql/bin/$chktool --recover $target_file
echo "$target_file ok"
done

exit 0

이상입니다<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:32:05 Linux에서 이동 됨]</div>

댓글 1개

댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
11-09-19 조회 2,597
11-09-19 조회 2,520
11-09-19 조회 5,538
11-09-19 조회 6,175
11-09-16 조회 2,887
11-09-16 조회 3,155
11-09-16 조회 6,351
11-09-15 조회 3,117
11-09-15 조회 2,880
11-09-15 조회 2,549
11-09-15 조회 2,544
11-09-15 조회 2,748
11-09-15 조회 2,705
11-09-15 조회 2,823
11-09-14 조회 2,735
11-09-14 조회 3,291
11-09-14 조회 2,403
11-09-14 조회 2,328
11-09-14 조회 2,316
11-09-13 조회 2,498
11-09-10 조회 2,968
11-09-10 조회 2,585
11-09-09 조회 3,170
11-09-09 조회 3,036
11-09-09 조회 3,131
11-09-09 조회 3,164
11-09-08 조회 3,849
11-09-08 조회 5,044
11-09-08 조회 3,440
11-09-08 조회 4,370
11-09-08 조회 3,874
11-09-08 조회 3,679
11-09-08 조회 2,773
11-09-08 조회 2,345
11-09-08 조회 2,750
11-09-08 조회 2,872
11-09-07 조회 3,534
11-09-07 조회 3,593
11-09-07 조회 3,014
11-09-07 조회 2,716
11-09-07 조회 2,809
11-09-07 조회 2,835
11-09-07 조회 3,069
11-09-07 조회 2,337
11-09-07 조회 2,434
11-09-07 조회 2,597
11-09-07 조회 3,537
11-09-07 조회 2,808
11-09-06 조회 2,633
11-09-06 조회 2,923
11-09-06 조회 2,484
11-09-05 조회 2,698
11-09-05 조회 2,645
11-09-05 조회 2,926
11-09-05 조회 2,441
11-09-04 조회 2,411
11-09-04 조회 2,374
11-09-03 조회 2,549
11-09-03 조회 2,708
11-09-02 조회 3,428
11-09-02 조회 2,805
11-09-02 조회 2,673
11-09-02 조회 3,582
11-09-02 조회 2,612
11-09-02 조회 2,500
11-09-02 조회 2,499
11-09-01 조회 2,700
11-09-01 조회 2,847
11-09-01 조회 2,722
11-09-01 조회 2,729
11-09-01 조회 2,874
11-09-01 조회 2,735
11-09-01 조회 4,173
11-09-01 조회 3,776
11-09-01 조회 4,443
11-08-31 조회 2,328
11-08-31 조회 2,631
11-08-31 조회 2,915
11-08-31 조회 2,633
11-08-31 조회 2,490
11-08-31 조회 3,300
11-08-30 조회 3,037
11-08-30 조회 4,267
11-08-29 조회 3,027
11-08-29 조회 2,610
11-08-29 조회 5,245
11-08-29 조회 3,373
11-08-29 조회 2,765
11-08-29 조회 3,117
11-08-28 조회 2,511
11-08-28 조회 3,662
11-08-28 조회 2,624
11-08-28 조회 2,988
11-08-26 조회 2,520
11-08-26 조회 3,026
11-08-26 조회 3,263
11-08-26 조회 2,760
11-08-25 조회 2,596
11-08-25 조회 2,908
11-08-25 조회 2,630