늘맑음

mysql 자동 최적화 / 복구 스크립트

· 2006-08-20 (일) 17:38:33 · 3727
chmod 700 /etc/cron.daily/mysql_optimizer.sh
=========================================
퍼미션은 다른 사용자가 접근하지 못하게 해주어야 보안에 문제가 생기지 않겠죠?


vi /etc/cron.daily/mysql_optimizer.sh
#!/bin/sh
##################################
#
# 2004-12-14
# Made By http://hubgo.com 이진명
#
##################################
# RPM버전의 경우
#/usr/bin/mysqlcheck -Aao --auto-repair -u root --password=패쓰워드;

# 소스설치의 경우(/usr/local/mysql)
#/usr/local/mysql/bin/mysqlcheck -Aao --auto-repair -u root --password=패쓰워드;<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
10-09-25 조회 2,741
10-09-19 조회 2,777
10-09-15 조회 2,781
10-09-15 조회 4,185
10-09-15 조회 3,421
10-09-15 조회 2,520
10-09-07 조회 3,634
10-08-27 조회 4,089
10-06-11 조회 4,271
10-05-31 조회 2,513
10-02-27 조회 5,028
10-02-09 조회 3,775
09-10-10 조회 7,367
09-03-19 조회 3,228
09-02-09 조회 3,496
09-02-09 조회 4,548
08-11-01 조회 2,932
08-09-29 조회 4,585
08-09-26 조회 3,528
08-09-26 조회 3,602
08-09-26 조회 2,737
08-09-26 조회 3,780
08-09-26 조회 3,507
08-09-26 조회 4,273
08-09-18 조회 3,606
08-09-09 조회 3,249
08-08-28 조회 2,792
08-07-06 조회 3,560
08-05-21 조회 4,726
08-05-13 조회 4,567
08-04-17 조회 4,939
08-02-19 조회 3,554
08-01-18 조회 3,867
08-01-10 조회 3,837
07-10-22 조회 3,670
07-10-09 조회 4,336
07-10-03 조회 3,533
07-07-06 조회 4,229
07-07-06 조회 4,443
07-07-06 조회 4,058
07-06-28 조회 3,597
07-06-05 조회 3,598
07-06-05 조회 4,140
07-05-30 조회 3,311
07-05-02 조회 3,696
07-04-15 조회 5,176
07-04-11 조회 3,653
07-04-05 조회 3,957
07-03-31 조회 3,171
07-03-31 조회 4,146
07-03-30 조회 3,758
07-03-24 조회 4,018
07-03-22 조회 3,679
07-03-12 조회 4,428
07-02-16 조회 3,301
07-02-14 조회 5,187
07-02-10 조회 4,021
07-02-09 조회 4,410
07-01-19 조회 4,071
07-01-16 조회 4,999
06-12-16 조회 5,865
06-11-30 조회 3,624
06-11-25 조회 3,734
06-10-15 조회 5,089
06-09-26 조회 5,333
06-09-26 조회 5,442
06-09-22 조회 4,299
06-09-21 조회 3,561
06-09-21 조회 3,658
06-09-02 조회 3,505
06-08-08 조회 5,135
06-07-20 조회 3,755
06-07-17 조회 3,379
06-07-13 조회 4,206
06-07-11 조회 3,497
06-07-11 조회 3,501
06-07-11 조회 3,867
06-06-29 조회 6,090
06-06-19 조회 6,480
06-06-02 조회 3,530
06-05-24 조회 5,015
06-05-14 조회 7,806
06-05-08 조회 3,922
06-02-02 조회 5,476
05-12-16 조회 4,537
05-12-05 조회 5,180
05-06-28 조회 4,138
05-04-11 조회 4,090
05-04-11 조회 4,270
05-04-11 조회 3,340
05-03-13 조회 3,244
05-03-12 조회 4,313
04-12-08 조회 7,798
04-12-01 조회 5,213
04-11-28 조회 3,384
04-11-28 조회 3,229
04-08-05 조회 5,646
04-08-05 조회 4,990
04-08-05 조회 5,601