¥Ñ¥é¥á¥È¥ê¥Ã¥¯JS¥¢¥ë¥Ð¥à
  • ¥«¥é¡¼²èÁü
¹¹¿·¥Ú¡¼¥¸
2008-09-09
2008-09-03
2008-08-01
2008-07-29
2008-04-20
2008-03-08
2008-02-21
2007-12-29
2007-12-27
2007-12-11
2007-12-09
¥«¥Æ¥´¥ê¡¼
¥Ñ¥é¥á¥È¥ê¥Ã¥¯affiliate¥¨¥ê¥¢
¼ÂºÝ¤Ë¤Ï¡¢Åö¥Ú¡¼¥¸¤Î¥Ø¥Ã¥À¡¼Éôʬ¤Ëɽ¼¨¤µ¤»¤Æ¤¤¤Þ¤¹¡£
Lightbox JS v2.0
¼ÂÁõ¼ê½ç¤Ï¤³¤³¤ò¥¯¥ê¥Ã¥¯¤·¤Æ¤¯¤À¤µ¤¤¡£¤Þ¤¿¡¢prototype.js´Ø¿ô¤òÍøÍѤ·¤Æ¤¤¤Þ¤¹¡£
¥Ñ¥é¥á¥È¥ê¥Ã¥¯FLASH
¤ò¿·Àߤ·¤Þ¤·¤¿¡£Ìá¤Ã¤Æ¡¢²¡¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
¡ß¤ò¥¯¥ê¥Ã¥¯¤¹¤ì¤ÐÄä»ß¤Ç¤­¤Þ¤¹¡£


XREA¤Ç´°àúXOOPS ¤½¤Î£·

ÉûÂê¡¡´°Á´Ìµ¿Í¤ÇÁ´¼«Æ°¤Ë¤è¤ë¡¡
¡¡£Í£ù£Ó£Ñ£Ì¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¤È¡¡
¡¡£Ø£Ï£Ï£Ð£Ó¤Î¥ß¥é¡¼¥ê¥ó¥°¤ò¡¡
¡¡¥µ¡¼¥Ð¡¼µ¡¤ò±Û¤¨¤Æ¹Ô¤¤¤Þ¤·¤ç¤¦¤«¡¡

¡¡±Ñ¸ì²½¡¡ËÜ¥Ú¡¼¥¸¤Îû½ÌURL:

http://fs4y.com/?e=7

¡¡ËÜ¥Ú¡¼¥¸ËÜʸºÇ½ª¹¹¿·Æü»þ¡§´ØÏ¢¥ê¥ó¥¯
¡¡2007/10/15 02:56am JST¡¡¡¡¡ÖXOOPS¤ÎÏÃÂê¡×¤ØÌ᤹¡¡¡¡Ê£¿ô¥µ¡¼¥Ð¡¼¤Ç½èÍý®ÅÙ¤ò¸þ¾å¡¡
½çÏ©¤ËÌá¤ë ¡ä¡ä¡ÖXREA¤Ç´°àúXOOPS ¤½¤Î£±¡×

·Ù¡¡¹ð¡¡¤È¡¡ÌÈ¡¡ÀÕ
¡¡¤³¤Î¥Ú¡¼¥¸¤Ç¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤òµ­ºÜ¤·¤Æ¤¤¤Þ¤¹¤¬¡¢¤¢¤Ê¤¿¤¬¼Â»Ü¤µ¤ì¤ë¾ì¹ç¤Ë¤Ï½½Ê¬¤Ê¥¹¥­¥ë¤¬¤¢¤ë¤³¤È¤ò´üÂÔ¤·¤Þ¤¹¡£¥¹¥­¥ë¤Î̵¤¤Êý¤¬½½Ê¬¤Ê¥Ç¥Ð¥Ã¥°¤ò¹Ô¤ï¤Ê¤¤¡¢¤Þ¤¿¤Ï¹½Ê¸¥ß¥¹¤òÈȤ·¤ÆÍøÍѤ·¡¢½ÅÂç¤Ê»öÂ֡ʽÅÍפÊÁ´¤Æ¤Î¥Õ¥¡¥¤¥ë¤Ê¤É¤¬ÉÔËܰդ˾üº¤¹¤ë¤Ê¤É¡Ë¤¬À¸¤¸¤Þ¤·¤Æ¤â¡¢Â¾¤¢¤é¤æ¤ë¥È¥é¥Ö¥ë¤ò¾·¤¤¤Æ¤â¡¢É®¼Ô¤ÏÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£ËÜÅÀ¤òÍý²ò¤Ç¤­¤Ê¤¤Êý¤Ï¡¢ËÜ¥Ú¡¼¥¸¤òÆɤ߿ʤޤʤ¤¤è¤¦¤Ë´ê¤¤¤Þ¤¹¡£

¢¨ À§È󡢿ȶá¤ÎLinux¤Ê¤êUNIX¤ò½ÏÃΤ·¤¿Êý¤Î±ç½õ¤òÆÀ¤ë¤è¤¦¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡ª


¡ÚÌܼ¡¡Û



ssh ¸ø³«¸°¤ÎºîÀ®

¢¨ XREA+¤Î·ÀÌó¤Ë¤è¤ëcrontabÍøÍѤβÄÈݤ˴ط¸Ìµ¤¯¡¢Á´¤¯Â¾¤Î¥µ¡¼¥Ð¡¼¤Ë¥Ç¡¼¥¿¡¼¤òÊݴɤ¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
¤³¤³¤Ç¤ÏÎã¤È¤·¤Æ¡¢XOOPS¤¬£²¤Ä¤Î¥µ¡¼¥Ð¡¼¤Ç²ÔÆ°Ãæ¤Ç¤¢¤Ã¤Æ¡¢Ì¾¾Î¡Ö¥µ¡¼¥Ð¡¼£Á¡×¤¬º£¸½ºßÍøÍÑÃæ¤Î£Ø£Ï£Ï£Ð£Ó¥Þ¥¹¥¿¡¼¥µ¡¼¥Ð¡¼¤È²¾Äꤷ¤Þ¤·¤ç¤¦¡£
¤½¤·¤Æ¡¢Á´¤¯Æ±¤¸£Ø£Ï£Ï£Ð£Ó¤¬Ì¾¾Î¡Ö¥µ¡¼¥Ð¡¼£Â¡×¤Ë¤â¸ºß¤·¡¢¤¤¤Ä¤Ç¤âÍøÍѳ«»Ï¤Ç¤­¤ë¥ß¥é¡¼£Ø£Ï£Ï£Ð£Ó¥·¥¹¥Æ¥à¤È¤·¤Æ£Ø£Ï£Ï£Ð£Ó¥¹¥ì¡¼¥Ö¥µ¡¼¥Ð¡¼¤¬Â¸ºß¤¹¤ë¤â¤Î¤È²¾Äꤷ¤Þ¤¹¡£
¸å¤Ï,¡Ö¥µ¡¼¥Ð¡¼£Á¡×¤Ë¤â¡Ö¥µ¡¼¥Ð¡¼£Â¡×¤Ë¤â£Ó£Ó£ÈÀܳ¤¬²Äǽ¤Ç¤¢¤Ã¤Æ¡¢CRONTAB¤òÍøÍѤǤ­¤ë¡Ö¥µ¡¼¥Ð¡¼£Ã¡×¤òÍÑ°Õ¤·¤Þ¤¹¡£²ñ¼Ò(¼«Âð)¥µ¡¼¥Ð¡¼¤Ê¤ê¤òÁÛÄꤷ¤Þ¤¹¤«¡£(Èù¾Ð)

½èÍý¤ÎÆâÍƤȤϡ¢¿¼Ìë(ÆüËÜ»þ´Ö¤Ç¤¹¤¬¡¦¡¦¡¦ ^^;)¡¢¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î¥È¥ê¥¬¡¼¤Ç¡¢¥µ¡¼¥Ð¡¼£Á¤ÎMySQL¥Ç¡¼¥¿¡¼¤ò¥À¥ó¥×¤·¤Þ¤¹¡£¤½¤·¤Æ¡¢¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î»Ø¼¨¤Ç¡¢¥µ¡¼¥Ð¡¼£Á¤ÎMySQL¥Ç¡¼¥¿¡¼¤Î¥À¥ó¥×¥Ç¡¼¥¿¡¼¤ò¡¢¥µ¡¼¥Ð¡¼£Â¤ËžÁ÷¤·¤Æ¤ª¤­¤Þ¤¹¡£
¥µ¡¼¥Ð¡¼£Ã¤¬¥¸¥ç¥Ö¥³¥ó¥È¥í¡¼¥ë¥»¥ó¥¿¡¼¤È¤·¤Æ¡¢¥È¥ê¥¬¡¼¤Îȯ¹Ô¤ò¹Ô¤¤¤Þ¤¹¡£¥µ¡¼¥Ð¡¼£Ã¤Ë¤Ï¡¢XOOPS¤â¡¢MySQL¤â̵ÍѤǤ¹¡£crontab¡ÜSSH¡Ü¥¤¥ó¥¿¡¼¥Í¥Ã¥ÈÀܳ¤À¤±¤¬¤Ç¤­¤ì¤Ð½½Ê¬¤Ç¤¹¡£³ØÆâ¡¢²ñ¼ÒÆâ¤Î£Ì£Á£Î¤ÎÊÒ¶ù¤ÎLinux(UNIX)¥Þ¥·¡¼¥ó¤Ç½½Ê¬¤Ç¤¹¡£(Èù¾Ð)
¡¡¥µ¡¼¥Ð¡¼£Ãµ¡¤Ï¡¢¤¢¤Ê¤¿¤Î¼é¸îÎî¤È¤Ê¤ë¤Ç¤·¤ç¤¦¡£Å·»È¤«¤âÃΤì¤Þ¤»¤ó¤è¡£¤½¤ì¤Ï¥µ¡¼¥Ð¡¼£Áµ¡¤¬µ¡Ç½ÉÔÁ´¤òµ¯¤³¤·¤¿»þ¤ËȽ¤ë¤³¤È¤Ç¤¹¡£¾Ü¤·¤¯¤Ï¡¢ËÜ¥Ú¡¼¥¸¤Î½ªÃåÅÀ¡Ö·ëÏÀ¡×¤ò¤ªÆɤߤ¯¤À¤µ¤ì¤Ð¡¢¥µ¡¼¥Ð¡¼£Ãµ¡¤Î½ÅÍ×À­¤Ëµ¤ÉÕ¤¤¤Æ¤¯¤À¤µ¤ë¤Ç¤·¤ç¤¦¤«¡£¥µ¡¼¥Ð¡¼£Ãµ¡¤Ë¤â̵ÄäÅÅÅŸ»ÁõÃÖ¤Ïɬ¿Ü¤Ç¤¹¤è¤Í¡£Å·»È¤¬»à¤ó¤Ç¤Ï¤¤¤±¤Þ¤»¤ó¤«¤é¤Í(Èù¾Ð)
¡ä¡¡£±¡¥¥µ¡¼¥Ð¡¼£Ã¤Ç£Ó£Ó£È¸ø³«¸°¤òÀ¸À®¤µ¤»¤Þ¤¹¡£¥³¥á¥ó¥È¤Ë¤ÏºîÀ®ÆüÉդȤ¢¤Ê¤¿¤Î¥¤¥Ë¥·¥ã¥ë¤Ç¤âÆþ¤ì¤Æ¤ª¤­¤Þ¤¹¤«¡£»²¹ÍURL¡Ö SSH2 ¤È OpenSSH ¡×
$¡¡ssh-keygen -t dsa -C ¥³¥á¥ó¥È
ºîÀ®»þ¤Ë¤Ï¡¢¥Ñ¥¹¥Õ¥ì¡¼¥º¤Ï»ØÄꤷ¤Þ¤»¤ó¡£ ¥µ¡¼¥Ð¡¼£Ã¤Ë´°À®¤·¤¿¡¢¡Ö id_dsa.pub ¡×¤ò¡¢¥µ¡¼¥Ð¡¼£Á¤È¥µ¡¼¥Ð¡¼£Â¤Î¡¢authorized_keys ¥Õ¥¡¥¤¥ë¤ËÄɲä·¤Þ¤¹¡£¤³¤ì¤Ç¡¢¥µ¡¼¥Ð¡¼£Ã¤«¤é¥µ¡¼¥Ð¡¼£Á¤È¥µ¡¼¥Ð¡¼£Â¤È¤Ï¡¢¥Ñ¥¹¥Õ¥ì¡¼¥ºÌµ¤·¤ÇSSH¥í¥°¥¤¥ó½ÐÍè¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£¤Ä¤Þ¤ê¥µ¡¼¥Ð¡¼£Ã¤Ï狼¤é¤âÍøÍѤǤ­¤Ê¤¤¥Þ¥·¡¼¥ó¤Ç¤¢¤ë¤³¤È¤¬Ë¾¤Þ¤ì¤Þ¤¹¡£

Ìë´Ö¿¼Ìë¡¢ÁáÄ«¤ËMySQL¤Î¥Ç¡¼¥¿¡¼¤òÁ´¼«Æ°¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë¡£¡Ú¥µ¡¼¥Ð¡¼£Á¡Û

¢¨XOOPS²ÔÆ°Ãæ¤Ç¤¢¤Ã¤Æ¥æ¡¼¥¶¡¼¤¬ÍøÍÑÃæ¤Î¥Þ¥¹¥¿¡¼µ¡¤Ç¤¹¤Í¡£
£±¡¥UTF-8ʸ»ú¥³¡¼¥É¤È¤·¤Æ¥À¥ó¥×¡£
£²¡¥BZIP2¤Ç°µ½Ì
¤½¤ì¤À¤±¤ò¹Ô¤¦¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤Ç¤¹¡£
¡ÚÊÑ¿ô¤Î°ÕÌ£¡Û¡§
¡¡DBNAMES¡á
DB̾¾Î¤òȾ³Ñ¥¹¥Ú¡¼¥¹¤Ç¶èÀڤäÆÄêµÁ¤·¤Þ¤¹¡£
¡¡PASSWORD¡á
DB̾¤´¤È¤Ë¥Ñ¥¹¥ï¡¼¥É¤òcaseʸ¤ÎÃæ¤ÇÄêµÁ¤·¤Þ¤¹¡£
¡Ú»öÁ°¤Î½àÈ÷¡Û¡§
¡¡¥Ç¥£¥ì¥¯¥È¥ê¡¼¤òºîÀ®¤·¤Þ¤¹¡£
DB̾¾Î¡¢¤Þ¤¿¤ÏDB̾¾Î¤Î¡Ö¡²¡×(¥¢¥ó¥À¡¼¥¹¥³¥¢Ê¸»ú)°Ê¹ß¤Î̾¾Î¤ÎÂçʸ»ú¤Ç¤¹¡£½ñ¤­¹þ¤ß¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤Ëµ¤¤ò¤Ä¤±¤Þ¤·¤ç¤¦¡£ É®¼Ô¤Ï¥Ç¥£¥ì¥¯¥È¥ê¡¼¤ò¡Ö£·£°£°¡×¤ËÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£
¡¡¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹Ì¾¤ÎÎ㡧¡¡abcdef¡¡¤È¡¡
¡¡abcdef_test123¡¡¤À¤È¤·¤Þ¤¹¡£
¡¡¤½¤ì¤¾¤ì¤ÎDB¥Ñ¥¹¥ï¡¼¥É¤ÎÎ㡧¡¡abcdef : chomechome¡¡
¡¡abcdef_test123 : chome123¡¡¤À¤È¤·¤Þ¤¹¡£
¡¡¥Ç¥£¥ì¥¯¥È¥ê¡¼¤Ï»öÁ°¤ËºîÀ®¤·¤Þ¤·¤ç¤¦¡£¡¡¤³¤ÎÎã¤Ç¤Ï¡¢
¡Ö ABCDEF ¡×¥Ç¥£¥ì¥¯¥È¥ê¡¼¤È¡¢
¡Ö TEST123 ¡×¥Ç¥£¥ì¥¯¥È¥ê¡¼¤ò¥ë¡¼¥È¤ËºîÀ®¤·¤Þ¤¹¡£
#!/bin/sh
#DEBUG="ON"

DBNAMES='abcdef abcdef_test123'
SCP2HOSTNAME='xxxxx@s139.xrea.com'

function WHERE(){
 if [ ! -x "$1" ]; then
	echo
	PROCESS=`basename $0`
	echo "  ERROR! CHECK A FILE ---> $1" >&2
	echo
	echo " Please modify this script `which $PROCESS` for `basename $1`"
	echo
  exit
 fi
}

SED='/usr/bin/sed'      ; WHERE $SED
DATE='/usr/bin/date'    ; WHERE $DATE
DATE=`$DATE "+%y%m%d"`
BZIP2='/usr/bin/bzip2'  ; WHERE $BZIP2
BZIP2="$BZIP2 -9"
MYSQLDUMP='/usr/local/mysql/bin/mysqldump'
	WHERE $MYSQLDUMP
#MYSQLHOTCOPY='/usr/local/mysql/bin/mysqlhotcopy'
#       WHERE $MYSQLHOTCOPY
SQLDUMPOPTION='--hex-blob --extended-insert --add-locks --add-drop-table --all --lock-tables --disable-keys --quote-names --default-character-set=utf8'
#       --default-character-set=binary

#SCP='/usr/local/bin/scp'; WHERE $SCP

cd

for DBNAME in $DBNAMES
do
	case $DBNAME in
	abcdef)			PASSWORD='chomechome' ;;
	abcdef_test123)		PASSWORD='chome123' ;;
	esac

	DIRNAME=`echo $DBNAME | $SED 's/^.*_//' \
		| $SED 'y/abcdefghijklmnopqrstuvwxyz/ABCDEFGHIJKLMNOPQRSTUVWXYZ/'`

	if [ ! -d $DIRNAME ]; then
		echo "ERROR! : NOT FOUND A DIRECTORY $DIRNAME ."
		continue
	fi

	DUMPNAME=`echo $DBNAME | $SED 's/^.*_/mysql_/'`
	DUMPNAME=${DIRNAME}/${DUMPNAME}_${DATE}.dump

if [ "$DEBUG" ]; then echo "\$DUMPNAME : $DUMPNAME" ; fi

	$MYSQLDUMP \
		-u $DBNAME \
		--password=$PASSWORD \
		$SQLDUMPOPTION \
		$DBNAME > $DUMPNAME

	if [ "$MYSQLHOTCOPY" -a -x "$MYSQLHOTCOPY" ]; then
		$MYSQLHOTCOPY \
			-u $DBNAME \
			--password=$PASSWORD \
			$DBNAME > ${DUMPNAME}2
	fi

	if [ -f $DUMPNAME -a -s $DUMPNAME ]
	then    if [ -f ${DUMPNAME}.bz2 ];then  rm -f ${DUMPNAME}.bz2
		fi
		if [ -f ${DUMPNAME}2.bz2 ];then rm -f ${DUMPNAME}2.bz2
		fi
		$BZIP2 $DUMPNAME
		chmod 600 ${DUMPNAME}.bz2
		if [ -f ${DUMPNAME}2 -a -s ${DUMPNAME}2 ]; then
			$BZIP2 ${DUMPNAME}2
			chmod 600 ${DUMPNAME}2.bz2
		fi
		if [ "$SCP" -a -x "$SCP" ]; then
			$SCP -p ${DUMPNAME}.bz2 \
				${SCP2HOSTNAME}:~/${DIRNAME}/
		fi
	fi
done
¢¨ °Ê¾å¤Î¥¹¥¯¥ê¥×¥È¤¬´°À®¤·¤Þ¤·¤¿¤é¡¢¼ÂºÝ¤Ë¼êÆ°¤Çµ¯Æ°¤·¤Æ¤ß¤Þ¤·¤ç¤¦¡£
¡¡É®¼Ô¤Ï¼Â¹Ô¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¡Ö£ø¡×¤ÏÁ´¤ÆÉÕÍ¿¤·¤Þ¤»¤ó¡£½ñ¤­¹þ¤ß¡Ö£÷¡×¤âÁ´¤ÆÉÕÍ¿¤·¤Þ¤»¤ó¡£Æɤ߹þ¤ß¡Ö£ò¡×¤Ï¡¢ºÇ¾®¸Â¤Ë¤·¤Þ¤¹¡£¤Ä¤Þ¤ê¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î£Ó£Ó£ÈÄÌ¿®¤Çµ¯Æ°¤µ¤ì¤ë¥×¥í¥»¥¹¤À¤±¤¬¡Ö£ò¡×¸¢Íø¤ò»ý¤Æ¤Ð½½Ê¬¤Ç¤¹¡ª É®¼Ô¤ÏËÜ¥·¥§¥ë¥¹¥¯¥ê¥×¥È¥Õ¥¡¥¤¥ë¤ËÉÕ¤¤¤Æ¤Ï¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¡Ö£´£°£°¡×¤ËÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£ £Ð£Ä£Æ¥Õ¥¡¥¤¥ë
¡ð ¤Ä¤Þ¤ê¥µ¡¼¥Ð¡¼£Áµ¡¤Ç¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï
$ /bin/sh mysqldump.sh
¡ô ¥µ¡¼¥Ð¡¼£Ã¤«¤é¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï
# ssh ¥µ¡¼¥Ð¡¼£Á /bin/sh ~/mysqldump.sh

¢¨¡¡mysqldump¤Ë¤è¤Ã¤ÆºîÀ®¤µ¤ì¤¿¥Ç¡¼¥¿¡¼¤Ïʸ»ú²½¤±¤·¤Æ¤¤¤Þ¤»¤ó¤«¡©¡ª ʸ»ú²½¤±¤·¤Æ¤¤¤ë¤Î¤Ê¤é¡¢²¿Ç¯¡¢¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò³¤±¤Æ¤â̵°ÕÌ£¤È¸À¤ï¤ì¤Þ¤»¤ó¤«¡£

¢¨ ÆäËËÜ¥Ú¡¼¥¸¤«¤é½é¤á¤ÆÆɤޤ줿Êý¤Ï¡¢Ê¸»ú²½¤±Âкö¤Ë¤Ä¤¤¤Æ¼êË¡¤¬¸«¤¨¤Ê¤¤¤«¤âÃΤì¤Þ¤»¤ó¡£À§Èó¡Ö XREA¤Ç´°àúXOOPS ¤½¤Î£± ¡×¤«¤éÆɤ߿ʤá¤Æ¤¯¤À¤µ¤¤¤Þ¤»¡£ ʸ»ú²½¤±¤·¤Ê¤¤ mysqldump ¤Î°Ù¤Î½ÅÍפÊXOOPS¥¤¥ó¥¹¥È¡¼¥ë¼êË¡¤Ë¤Ä¤¤¤Æ½çÏ©·ú¤Æ¤Æ²òÀ⤷¤Æ¤­¤Þ¤·¤¿¡£ É®¼Ô¤Ï¡¢¡Ö XREA¤Ç´°àúXOOPS ¤½¤Î£± ¡×¡Á¡Ö XREA¤Ç´°àúXOOPS ¤½¤Î£¶ ¡×¤ò½çÏ©¤À¤Æ¤ÆÆɤޤ줿Êý¤Ø¡¢ËÜ¥Ú¡¼¥¸¤ò¤´ÍÑ°Õ¤·¤¿¤³¤È¤ò¤´Íý²ò´ê¤¤¤Þ¤¹¡£


¥µ¡¼¥Ð¡¼£Ã¤Îcrontab¤Ë¥È¥ê¥¬¡¼¤òËä¤á¹þ¤ß¤Þ¤¹¡£

¢¨ °ìÆü£±²ó¤ÇÎɤ¤¤Ç¤·¤ç¤¦¡£À¤³¦µ¬ÌϤǥ¢¥¯¥»¥¹¤µ¤ì¤Æ¤¤¤ë¤Î¤Ê¤é̵°ÕÌ£¤ÊÇÛθ¤Ç¤¹¤¬¡¢XOOPS¤Î¿¤¯¤ÏEUC-JP¤À¤±¤ÇÍøÍѤµ¤ì¤Æ¤ª¤ê¡¢ÆüËܿ͸þ¤±¤Ç¤¹¤è¤Í¡£³¤³°ºß½»¤ÎÆüËܿͤˤϿ½¤·Ìõ¤Ê¤¤¤³¤È¤Ç¤¹¤¬¡¦¡¦¡¦¡¦¥µ¡¼¥Ð¡¼µ¡¤ÎÀßÃÖ¾ì½ê¤Î¥í¡¼¥«¥ë¥¿¥¤¥à¤Ê¿¼Ìë¡¢ÁáÄ«¤ÎŬÅö¤Ê»þ´Ö¤Ëµ¯Æ°¤·¤Þ¤·¤ç¤¦¡£ XREA¥µ¡¼¥Ð¡¼¤Ê¤éÆüËܹñ¤ÎÁáÄ«¤¬Îɤ¤¤Ç¤·¤ç¤¦¤«¡£
¥µ¡¼¥Ð¡¼£Áµ¡¡¢¥µ¡¼¥Ð¡¼£Âµ¡¤ÎÀßÃÖ¾ì½ê¤Î¥í¡¼¥«¥ë¤Ê»þ¹ï¤Ë¤ª¤±¤ë¥µ¡¼¥Ð¡¼¥á¥ó¥Æ¥Ê¥ó¥¹¤Î»þ¹ï¤ËÃí°Õ¤·¤Þ¤¹¡£°Æ³°¡¢(¥Û¥Ã¥È)¥ê¥Ö¡¼¥È¤·¤Æ¤¤¤ë¥µ¡¼¥Ð¡¼¤¬¤¢¤ë¤â¤Î¤Ç¤¹¡£¤½¤ó¤Ê»þ¹ï¤ÏÈò¤±¤Þ¤·¤ç¤¦¡£¥á¥ó¥Æ¥Ê¥ó¥¹»þ¹ï¤Ï¤ªÇ¤¤»¤·¤Þ¤¹¤¬¡¢µ¯Æ°¡Öʬ¡×¤Ï·è¤·¤Æ¡Ö£°¡×¤È¤«¡Ö£³£°¡×¤È¤«¤È¡¢¤ß¤ó¤Ê¤¬»ØÄꤹ¤ë¤è¤¦¤Ê»þ¹ï¤ÏÈò¤±¤Þ¤·¤ç¤¦¡£Á´¤¯»×¤¤¤â¤è¤é¤Ê¤¤¡Ö»þ¡§Ê¬¡×¤ò»ØÄꤷ¤Þ¤·¤ç¤¦¡£
¡¡¤¢¤¯¤Þ¤Ç¤â¼Â¹Ô¤¹¤ë»þ¹ï¤È¤Ï¡¢¥µ¡¼¥Ð¡¼£Áµ¡¡¢¥µ¡¼¥Ð¡¼£Âµ¡¤ÎÀßÃÖ¾ì½ê¤Î¥í¡¼¥«¥ë¤Ê»þ¹ï¤«¤é´¹»»¤·¤¿¡¢¥µ¡¼¥Ð¡¼£Ãµ¡¤Î¥í¡¼¥«¥ë»þ¹ï¤È¤Ê¤ë¤È¸À¤¦¤³¤È¤Ç¤¹¡£
# ssh ¥µ¡¼¥Ð¡¼£Á /bin/sh mysqldump.sh
¤È»ØÄꤷ¤Þ¤¹¡£´Êñ¤Ç¤¹¤Í¡£¤³¤ì¤ÇËèÆü¡¢¥µ¡¼¥Ð¡¼£Á¤Î£Ä£Â̾¤´¤È¤Ë¡¢Á´¥À¥ó¥×¥Ç¡¼¥¿¡¼¤ò£Õ£Ô£Æ¡Ý£¸¤Ç¡¢£â£ú£é£ð£²°µ½Ì²½¤·¡¢Êݸ¤·¤Þ¤¹¤«¡£


£ò£ó£ù£î£ã¤ò¥µ¡¼¥Ð¡¼£Ã·Ðͳ¤Ç¡¢¥ß¥é¡¼¥ê¥ó¥°¤ò¹Ô¤¦¡£

ËèÆü¥ß¥é¡¼¥ê¥ó¥°¤¹¤ë¤Ù¤­¥Ç¥£¥ì¥¯¥È¥ê¡¼
¡¡£ø£ï£ï£ð£ó¡¡
¡¡¥Ç¥£¥ì¥¯¥È¥ê¡¼¡¡
¡¡uploads¡¡
¡¡£Í£ù£Ó£Ñ£Ì¡¡
¡¡¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼¡¡
¡¡Âçʸ»úDB̾¡¡
¢¨ °Ê²¼¤Î¥¹¥¯¥ê¥×¥È¤ò¥µ¡¼¥Ð¡¼£Ã¤Ç¼Â¹Ô¤·¤Þ¤¹¡£¥µ¡¼¥Ð¡¼£Ã·Ðͳ¤Ç¤Î¥ß¥é¡¼¥ê¥ó¥°¤ò¼Â¹Ô¤·¤Þ¤¹¡£XOOPS¥Ç¥£¥ì¥¯¥È¥ê¡¼¤È¤Ï¡¢uploads ¥Ç¥£¥ì¥¯¥È¥ê¡¼¤ò»Ø¤·¤Þ¤¹¡£¤Þ¤¢¡¢Äê´üŪ¤ËXOOPSÁ´¥Õ¥¡¥¤¥ë¤Î¥ß¥é¡¼¥ê¥ó¥°¤ò¹Ô¤Ã¤Æ¤â°­¤¯¤Ï̵¤¤¤Ç¤¹¤è¤Í¡£ rsync ¤Î¥ª¥×¥·¥ç¥ó¤Ï¡¢¤è¡¼¤¯¹Í¤¨¤Æ¤¯¤À¤µ¤¤¡£ É®¼Ô¤Ï¡¢rsync ¤Î¥í¥°¤òľÀܥѥ¤¥×»ØÄꤷ¤Æ¡¢qmail¤ËÁ÷¤êÉÕ¤±¤Æ¥á¡¼¥ë¤ÇÈô¤Ð¤·¤Æ¤¤¤Þ¤¹¡£
# rsync -auvv -e ssh --delete ¥µ¡¼¥Ð¡¼£Á:£Ø£Ï£Ï£Ð£Ó¥Ç¥£¥ì¥¯¥È¥ê¡¼/ £Ø£Ï£Ï£Ð£Ó¥Ç¥£¥ì¥¯¥È¥ê¡¼/
# chown -R xxxx:yyyy £Ø£Ï£Ï£Ð£Ó¥Ç¥£¥ì¥¯¥È¥ê¡¼
# rsync -auvv -e ssh --delete £Ø£Ï£Ï£Ð£Ó¥Ç¥£¥ì¥¯¥È¥ê¡¼/ ¥µ¡¼¥Ð¡¼£Â¡§£Ø£Ï£Ï£Ð£Ó¥Ç¥£¥ì¥¯¥È¥ê¡¼/
¤½¤·¤Æ¡¢»þ¹ï¤ò¤º¤é¤·¤Æ(XREA¤Î¾ì¹ç¤Ï£±»þ´Ö°Ê¾å¤Î¥¢¥¤¥É¥ê¥ó¥°¤¬µá¤á¤é¤ì¤Þ¤¹)
# rsync -auvv -e ssh --delete ¥µ¡¼¥Ð¡¼£Á:£Í£ù£Ó£Ñ£Ì¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼/ £Í£ù£Ó£Ñ£Ì¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼/
# chown -R xxxx:yyyy £Í£ù£Ó£Ñ£Ì¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼
# rsync -auvv -e ssh --delete £Í£ù£Ó£Ñ£Ì¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼/ ¥µ¡¼¥Ð¡¼£Â¡§£Í£ù£Ó£Ñ£Ì¥À¥ó¥×¥Ç¥£¥ì¥¯¥È¥ê¡¼/
chown ¥³¥Þ¥ó¥É¤Ç¡¢¥µ¡¼¥Ð¡¼£ÂÍѤΥ桼¥¶¡¼ID¤È¥°¥ë¡¼¥×ID¤Ë½ñ¤­´¹¤¨¤Æ¤ª¤­¤Þ¤¹¤«¡£
°Ê¾å¤Î¥×¥í¥»¥¹¤òËèÆü¼Â¹Ô¤µ¤»¤Þ¤¹¤«¡£¤½¤¦¤¹¤ì¤Ð¡¢¥µ¡¼¥Ð¡¼£Á¢á¥µ¡¼¥Ð¡¼£Ã¢á¥µ¡¼¥Ð¡¼£Â¤È¤Ê¤Ã¤Æ¡¢¥µ¡¼¥Ð¡¼£Á¤¬»´»ö¾ã³²¤Ë´Ù¤Ã¤Æ¤â¡¢DNS¤òÄ´À°¤¹¤ë¤À¤±¤Ç¡¢¥µ¡¼¥Ð¡¼£Â¤¬¤¤¤Ä¤Ç¤âÂåÂؤ¨XOOPS¥Þ¥¹¥¿¡¼µ¡¤È¤Ê¤Ã¤Æ±¿±Ä¤ò³¹Ô¤Ç¤­¤Þ¤¹¤Í¡£¥µ¡¼¥Ð¡¼£Ã¤Ï̵Â̤ǤϤʤ¤¤È¸¤¸¤Þ¤¹¡£¥µ¡¼¥Ð¡¼£Ã¤ò·Ðͳ¤¹¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢£Ó£Ó£ÈÄÌ¿®¥È¥é¥Ö¥ë»þ¤ËÄ´ºº¤·°×¤¯¤Ê¤ê¤Þ¤¹¤«¤Í¡£¤Þ¤¿¹Í¤¨¤¿¤¯¤â¤Ê¤¤»´»ö¤Ç¤·¤ç¤¦¤¬¡¢Âç¿ÌºÒ¤È¸À¤Ã¤¿Å·ºÒ¡¢²ÐºÒ¤È¤¤¤Ã¤¿¿ÍºÒ¤Ë¤è¤Ã¤Æ¡¢XREA¤µ¤ó¤Î¥µ¡¼¥Ð¡¼¤¬Á´ÌǤ·¤¿¾ì¹ç¤Ë¤³¤½½õ¤«¤ê¤Þ¤¹¤è¤Í¡£
¡¡¼Â¸³Ãʳ¬¤Ç¤Ï¡¢rsync ¤Î¥ª¥×¥·¥ç¥ó¡Ö --delete ¡×¤ÏÉÕ¤±¤Ê¤¤Êý¤¬°ÂÁ´¤Ç¤·¤ç¤¦¡£²¿¸Î¤Ê¤é¡¢¹½Ê¸¤Ë¥ß¥¹¤¬¤¢¤ê¤Þ¤¹¤È¡¢¤É¤ó¤É¤óºï½ü¤µ¤ì¤Æ¤·¤Þ¤¦¤«¤é¤Ç¤¹¡£ £±Ê¸»ú¤â¹½Ê¸¤Ë´Ö°ã¤¤¤¬Ìµ¤¯´°àú¤Ê¤é¡¢¡Ö --delete ¡×¤òÉղ䷤ơ¢´°àú¤Ê¥ß¥é¡¼¥ê¥ó¥°¤ò¹Ô¤¤¤Þ¤·¤ç¤¦¡£

¡¡chown¤ò¼Â¹Ô¤¹¤ë¤Ë¤Ï¡¢¤­¤Ã¤È¥¹¡¼¥Ñ¡¼¥æ¡¼¥¶¡¼¤Ç¤Ê¤¤¤È̵Íý¤«¤âÃΤì¤Þ¤»¤ó¤Í¡£¥µ¡¼¥Ð¡¼£Ã¤Ç¤ÎÀßÄê¤Ï¡¢¥¹¡¼¥Ñ¡¼¥æ¡¼¥¶¡¼¤Ç¤¢¤ëɬÍפϤ¢¤ê¤½¤¦¤Ç¤¹¤«¡£


£¹£°Æü¤è¤ê¤â¸Å¤¤¥Ð¥Ã¥¯¥¢¥Ã¥×¤Ï¼«Æ°¾ÃÌǤµ¤»¤Þ¤¹¤«

¢¨ ¤³¤Î¤Þ¤Þ¤Ç¤Ï¡¢£Í£ù£Ó£Ñ£Ì¥Ð¥Ã¥¯¥¢¥Ã¥×ÍѤΥÀ¥ó¥×¥Õ¥¡¥¤¥ë¤¬Áý¤¨¤Æ¤¤¤­¤Þ¤¹¡£¸Å²á¤®¤ë¥Ç¡¼¥¿¡¼¤Ï¼«Æ°Åª¤Ëºï½ü¤µ¤»¤Þ¤·¤ç¤¦¡£¡ÊÊ̤Ë90Æü¤Ë¤³¤À¤ï¤ê¤Þ¤»¤ó¡£¤¢¤Ê¤¿¤ÎȽÃǤÇŬÅö¤ÊÆü¿ô¤Ë¤·¤Þ¤·¤ç¤¦¡£¥·¥§¥ëÊÑ¿ô DELETEOLDERDAYS ¤ÇÄ´À°¤Ç¤­¤Þ¤¹¤Í ^^¡Ë¥µ¡¼¥Ð¡¼£Á¤Çºï½ü¤¹¤ì¤Ð¡¢ÅÁÀ÷ɤÎÍͤˡ¢¥µ¡¼¥Ð¡¼£Ã¡¢¤½¤·¤Æ¥µ¡¼¥Ð¡¼£Â¤«¤é¤âºï½ü¤·¤¿¥Ç¡¼¥¿¡¼¤Ï̵¤¯¤Ê¤ê¤Þ¤¹¡£
#!/bin/sh
#DEBUG="echo"

DELETEOLDERDAYS='90'		# »ØÄꤷ¤¿ÆüÉÕ¤è¤ê¤â¸Å¤¤¥Õ¥¡¥¤¥ë¤ò¾Ã¤·¤Þ¤¹¡£
DBNAMES='abcdef abcdef_test123'	# XREA¤ÎDB̾¤ò»ØÄꤷ¤Þ¤¹¡£Ê£¿ô²Äǽ¡£

function WHERE(){
 if [ ! -x "$1" ]; then
	echo
	PROCESS=`basename $0`
	echo "  ERROR! CHECK A FILE ---> $1" >&2
	echo
	echo " Please modify this script `which $PROCESS` for `basename $1`"
	echo
	exit
 fi
}

BASENAME='/usr/bin/basename'	; WHERE $BASENAME
FIND='/usr/bin/find'		; WHERE $FIND
SED='/usr/bin/sed'		; WHERE $SED
RM='/usr/bin/rm'		; WHERE $RM

for DBNAME in $DBNAMES
do
	cd

	DIRNAME=`echo $DBNAME | $SED 's/^.*_//' \
		| $SED 'y/abcdefghijklmnopqrstuvwxyz/ABCDEFGHIJKLMNOPQRSTUVWXYZ/'`

	if [ ! -d $DIRNAME ]; then
		echo "ERROR! #1: NOT FOUND A DIRECTORY $DIRNAME ."
		continue
	fi

	cd $DIRNAME
	PWD=`pwd`
	if [ "$DIRNAME" != "`$BASENAME $PWD`" ]; then
		echo "ERROR! #2: NOT FOUND A DIRECTORY $DIRNAME ."
		continue
	fi

	if [ "$DELETEOLDERDAYS" -gt 3 ]; then
		$DEBUG $FIND . -type f -atime +$DELETEOLDERDAYS -exec $RM -f "{}" \;
	fi

done
¢¨ ËÜ¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤³¤½¡¢¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ÎÀßÄê¤Ëµ¤¤òÇÛ¤ê¤Þ¤·¤ç¤¦¡£ É®¼Ô¤Ï¡Ö£´£°£°¡×¤ËÀßÄꤷ¤Þ¤¹¡ª
¡ð ¤Ä¤Þ¤ê¥µ¡¼¥Ð¡¼£Áµ¡¤Ç¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï
$ /bin/sh ¥·¥§¥ë¥¹¥¯¥ê¥×¥È
¡ô ¥µ¡¼¥Ð¡¼£Ã¤«¤é¼Â¹Ô¤¹¤ë¾ì¹ç¤Ï
# ssh ¥µ¡¼¥Ð¡¼£Á /bin/sh ~/¥·¥§¥ë¥¹¥¯¥ê¥×¥È


¡¡mysqldump.sh¡¡¡¡¥À¥¦¥ó¥í¡¼¥É¡¡


ɬ¤ºMySQL¤Î¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤Î¥¤¥ó¥Ý¡¼¥È¸¡¾Ú¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡ª ɬ¤º¡ª¡ª

¢¨ À޳ѤÎMySQL¤Î¥À¥ó¥×¥Ç¡¼¥¿¡¼¤òÁ´¼«Æ°¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¤Ç¤­¤Æ¤¤¤Æ¤â¡¢¥¤¥ó¥Ý¡¼¥È½ÐÍè¤Ê¤«¤Ã¤¿¤Ê¤éÁ´¤¯¤â¤Ã¤Æ̵°ÕÌ£¤Ê¤³¤È¤Ç¤¹¡£MySQL¤Î¥À¥ó¥×¥Ç¡¼¥¿¡¼¤«¤é¡¢É¬¤ºÉüµì¤Ç¤­¤ë¤³¤È¤ò³Îǧ¤·¤Æ¤¯¤À¤µ¤¤¡ª
Èæ³ÓŪÄãÍÆÎ̤ʥÀ¥ó¥×¥Ç¡¼¥¿¡¼¤Ê¤éphpMyAdmin ¤Î¥¤¥ó¥Ý¡¼¥Èµ¡Ç½¤Ç²Äǽ¤Ç¤·¤ç¤¦¡£¤È¤³¤í¤¬¡¢XOOPS±¿ÍѤËÎò»Ë¤¬·Ð²á¤·¤Þ¤¹¤È¡¢ÂçÍÆÎ̤ʥÀ¥ó¥×¥Ç¡¼¥¿¡¼¤Ë¤Ê¤ë¤Î¤«¤âÃΤì¤Þ¤»¤ó¡£¤½¤¦¤·¤Þ¤¹¤È¡¢¥¿¥¤¥à¥¢¥¦¥È¤¬Â¸ºß¤¹¤ë phpMyAdmin ¤Ë¤è¤ëÉüµì¤ÏÉÔ²Äǽ¤È¤Ê¤ê¤Þ¤¹¡ª
¢¨ ¤Ç¤¹¤«¤é¡¢¤â¤¦¤¢¤Ê¤¿¤Ï¡Ö ssh ¡×¤Ç¥í¥°¥¤¥ó¤Ç¤­¤ë¤ï¤±¤Ç¤¹¤«¤é¡¢ssh ¥³¥ó¥½¡¼¥ë²èÌ̤è¤ê¡¢mysql ¤ËÂФ·¤ÆľÀÜ¡¢¥À¥ó¥×¥Ç¡¼¥¿¡¼¤òÆɤ߹þ¤Þ¤»¤ë¤³¤È¤¬É¬Íפˤʤê¤Þ¤¹¡£¤Ç¤¹¤«¤é¡¢º£¤«¤é¡¢¤½¤Î»´»öÉüµì¤Î¥È¥é¥Ö¥ë¤Î½àÈ÷¤ò¤·¤Þ¤·¤ç¤¦¡ª¡ª
¢¨ ¤Ä¤Þ¤ê¡¢¥µ¡¼¥Ð¡¼£Â¤Ë¥ß¥é¡¼¥ê¥ó¥°Å¾Á÷¤µ¤ì¤¿ºÇ¿·¤ÎMySQL¥À¥ó¥×¥Õ¥¡¥¤¥ë¤«¤é¡¢MySQL¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤ÎÉüµì¤Î¸¡¾Ú¤ò¡¢º£¤¹¤°¤Ë¼Â»Ü¤·¤Æ¤¯¤À¤µ¤¤¡£MySQL¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ì¤Ð¡¢MySQL¤ÎµóÆ°¤ÏÊѤï¤ë¤â¤Î¤«¤âÃΤì¤Þ¤»¤ó¤Í¡£ mysqldump ¤ÎµóÆ°¤â°Û¤Ê¤ê¤Þ¤¹¤è¤Í¡£ º£¸½ºß¤ÎMySQL¤Î¥Ð¡¼¥¸¥ç¥ó¤ÇÉüµì¤Ç¤­¤ë¥À¥ó¥×¥Õ¥¡¥¤¥ë¤Î½ñ¼°¤Ïµá¤á¤é¤ì¤Þ¤¹¡ª É®¼Ô¤Î¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤Î¥·¥§¥ëÊÑ¿ô¡Ö SQLDUMPOPTION ¡×¤òÊѹ¹¤·¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤³¤È¤Ï¤ª¤ª¤¤¤Ë¤¢¤ê¤¨¤ë¤³¤È¤Ê¤Î¤Ç¤¹¡£


·ëÏÀ

¢¨ ËÜ¥Ú¡¼¥¸¤Ç¼Â¸½¤¹¤ë¼êË¡¤Ç¤¹¤È¡¢¥µ¡¼¥Ð¡¼£Á¤ÎXOOPS¥Þ¥¹¥¿¡¼µ¡¤â¡¢¥µ¡¼¥Ð¡¼£Â¤ÎXOOPS¥¹¥ì¡¼¥Öµ¡¤â¡¢crontab¤òÍøÍѤ·¤Æ¤¤¤Þ¤»¤ó¡£
XOOPS¤âMySQL¤âƳÆþ¤·¤Æ¤¤¤Ê¤¤¥µ¡¼¥Ð¡¼£Ã¤Îcrontab¤ÈsshÄÌ¿®¤À¤±¤Ç¡¢ÌÜŪ¤òãÀ®¤·¤Æ¤¤¤Þ¤¹¡£
XREA¥µ¡¼¥Ð¡¼¤Î¾ì¹ç¤Ï¡¢SSHÄÌ¿®¤Îǧ¾Ú¤Ë¥°¥í¡¼¥Ð¥ëIP¥¢¥É¥ì¥¹¤À¤±¤òºÎÍѤ·¤Æ¤¤¤Þ¤¹¡£¥µ¡¼¥Ð¡¼£Ã¤ÈƱ¤¸¥²¡¼¥È¥¦¥§¥¤¤òÍøÍѤ·¤Æ¤¤¤ëWindows£Ð£Ã¤Çǧ¾Ú¤ò¥¯¥ê¥¢¡¼¤¹¤ì¤ÐÎɤ¤¤Ç¤·¤ç¤¦¡£¤³¤Î¥²¡¼¥È¥¦¥§¥¤µ¡¤Ë¥×¥í¥­¥·¡¼¥µ¡¼¥Ð¡¼µ¡Ç½¤òÉղ乤ë¤è¤¦¤Ë¤·¤Æ¤ª¤±¤Ð¡¢ºÇ½ªÅª¤Ë¡¢¤³¤Î(¥²¡¼¥È¥¦¥§¥¤¡Ü)¥×¥í¥­¥·¡¼·Ðͳ¤ÇXREA¥³¥ó¥Ñ¥Í¤òÍøÍѤ·¤ÆSSHǧ¾Ú¥Ü¥¿¥ó¤ò²¡¤¹¤Î¤Ê¤é¡¢¼«Âð¤ä½ÐÄ¥Àè¤Ê¤É¡¢¤É¤³¤«¤é¤Ç¤âSSH¥í¥°¥¤¥ó¸¡¾Ú¤Ï²Äǽ¤Ç¤¹¤Í¡£
¡Öº£¡¢½ÐÄ¥Àè¤Ç¤¹¤Î¤Ç¡¢Ìá¤Ã¤Æ¤«¤éÂбþ¤·¤Þ¤¹¡×¤Ê¤É¤È¸À¤¦¿Í¤Ë°ì·â¤Ç¤¹¤«¤Í¡£(^^)¡¨

¢¨ ¥µ¡¼¥Ð¡¼£Â¤ÎMySQL¤Î¥Ð¡¼¥¸¥ç¥ó¤Ë¤ÏÃí°Õ¤¬É¬ÍפǤ¹¡ª ¥µ¡¼¥Ð¡¼£Á¤«¤é½ÐÎϤµ¤ì¤¿MySQL¤Î¥À¥ó¥×¥Õ¥¡¥¤¥ë¤¬Àµ¤·¤¯²ò¼á¤Ç¤­¤Ê¤¤¥µ¡¼¥Ð¡¼£Â¤ÎMySQL¤Ç¤Ï̵°ÕÌ£¤Ç¤¹¡£É¬¤º¡¢Äê´üŪ¤Ë¡¢¥µ¡¼¥Ð¡¼£Â¤ÎMySQL¤ÇDB¤ÎÉüµì¤ò¹Ô¤¤¤Þ¤·¤ç¤¦¡£ ¤½¤ì¤Ê¤é¡¢¡Ö¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î»Ø¼¨¤Ç¡¢Ëè²ó¡¢MySQL¤Î¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤âÉüµì¤¹¤ì¤ÐÎɤ¤¤¸¤ã¤Ê¤¤¤«¡ª¡×¤È¹Í¤¨¤ËµÚ¤ó¤ÀÊý¤Ï¡¢ÁïÌÀ¤Ç¤¹¡£¤½¤¦¤¹¤ì¤Ð¡¢¥Ð¥«¥ó¥¹Ãæ¤Î³¤³°¤«¤é¤Ç¤â¡¢¤¤¤Ä¤Ç¤â¡¢DNS¤ÎÀßÄê¤ÎÊѹ¹¤À¤±¤Ç¡¢»´»öÉüµì¤ËÂбþ¤Ç¤­¤Þ¤¹¤Í¡£(Èù¾Ð) ¡Ö¤è¡Á¤·¡¢¥Ð¥«¥ó¥¹¤¬½ªÎ»¤·¤ÆÌá¤Ã¤¿¤é¡¢¥µ¡¼¥Ð¡¼£Á¤ÎXOOPS¥Þ¥¹¥¿¡¼µ¡¤ÎÉüµì¤À¤Ê¡ª ¥Þ¥¤¥Ï¥Ë¡Á¥Á¥å¡¼¤Ã¤È¡× ¡¡¤ª¤¤¤ª¤¤¡ª¡ª ¤ª¡¼¤¤¤Ã¡ª ¤³¤é¤¢¡Á¡ª ¥Ü¥³¥Ü¥³
¡¡½ÅÍפʤ³¤È¤¬»Ä¤Ã¤Æ¤¤¤Þ¤¹¤è¡ª¡ª ¿ô»þ´Ö¤Îͱͽ¤·¤«Ìµ¤¤¤Ç¤¹¤è¡ª¡¡(¿ôʬ¤«¤â T_T)¡¡ Á᤯¡¢¥µ¡¼¥Ð¡¼£Ã¤Î crontab ¤òÄä»ß¤·¤Ê¤¤¤ÈÂçÊѤʤ³¤È¤¬µ¯¤­¤Þ¤¹¤è¡ª¡ª¡ª ¤¢¤Ê¤¿¤¬ÉԺߤʤ顢¥µ¡¼¥Ð¡¼£Ã¤ÎLAN¥±¡¼¥Ö¥ë¤òÈ´¤­¤Þ¤·¤ç¤¦¡ª¡ª ¡ÖLAN¥±¡¼¥Ö¥ë¤Ã¤Æ¡©È´¤±¤Ê¤¤¤ó¤Ç¤¹¤±¤É¡Á¡¦¡¦¡¦¡×(¤¦¤ë¤¦¤ë) ¤¨¤¨¤¨¡¼¤¤¡¢¡ÖÀڤ졪ÀÚ¤ì¤Ã¡ª¥Ï¥µ¥ß¤Ê¤ê¥«¥Ã¥¿¡¼¥Ê¥¤¥Õ¤ÇÀڤäÆÎÉ¡Á¤·¡ª Á᤯ÀڤäƤ¯¤Ç¤¨¡¼¡ª¡ª¡ª¡×
¡¡¼¡¤Î¥¹¥Æ¥Ã¥×¤È¤Ï¡¢¥µ¡¼¥Ð¡¼£Áµ¡¤ò¤È¤Ã¤È¤È´þ¤Æ¤ë¤³¤È¤Ç¤¹¤·¡¢¥µ¡¼¥Ð¡¼£Ã¤Î crontab ¤Î½¤Àµ¤Ç¤¹¤è¤Í¡£ ¥µ¡¼¥Ð¡¼£Â¤ÎXOOPS¥¹¥ì¡¼¥Öµ¡¤¬¥Þ¥¹¥¿¡¼µ¡¤Ë¾º³Ê¤Ç¤¹¡£²¼¹î¾å¤Ç¤¹¤Í¡£ XOOPS¥¹¥ì¡¼¥Öµ¡¤Ï¿·¤¿¤Ë¼êÇÛ¤·¤Þ¤·¤ç¤¦¤«¡£ DNSÄ´À°¤È½½Ê¬¤ÊDNS¸ú²Ì¤¬·Ð²á¤·¤¿¸å¤Ç¡¢¥µ¡¼¥Ð¡¼£Á¤ÎDB¤â¥Õ¥¡¥¤¥ë¤âÁ´ºï½ü¤·¤Æ¡ÖXREA¤ÎÊĺ¿¡×¿½ÀÁ¤ò¤·¤Æ¡¢ÇË´þ¤·¤Þ¤·¤ç¤¦¡£¥µ¡¼¥Ð¡¼£Á¤µ¤ó¡¢¤ªÈè¤ìÍͤǤ·¤¿¡£ ¤³¤ì¤³¤½¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¤òÁªÂò¤¹¤ëÂé¸ïÌ£¤Ç¤¹¤è¤Í¡£(¾Ð)


XREA»ÅÍͤ賦

¢¨ rsync¤Ê¤É¡¢ssh¥ê¥â¡¼¥È¤Ë¤è¤ë¥×¥í¥»¥¹¤ËÂФ¹¤ëXREA¦¤Î¥¿¥¤¥à¥¢¥¦¥ÈÀßÄê¤òĶ¤¨¤ëÄø¤Î½èÍý¤ËȯŸ¤·¤¿¾ì¹ç¤Ï¡¢¡Ö£±»þ´Ö¤ò·Ð²á¤¹¤ë¥¢¥¤¥É¥ê¥ó¥°¥¿¥¤¥à¡×¤ò¹Íθ¤ËÆþ¤ì¤¿¡Ö¥Ð¥Ã¥Á½èÍý¤ÎʬÃǡ׽èÃÖ¤ÎɬÍפ¬µ¯¤³¤ê¤Þ¤¹¡£¤Þ¤¢¡¢¿¼Ìë¤ÏŤ¤¤Ç¤¹¤«¤é¡¢£±»þ´Ö£µÊ¬´Ö³Ö¤Ç¡¢£´¡Á£µ¥×¥í¥»¥¹¤òµ¯Æ°¤Ç¤­¤Þ¤¹¤è¤Í¡£¼êÆ°¤Ê¤éÂçÊѤǤ¹¤±¤É¡¢crontab¤ËËä¤á¹þ¤à¼ê´Ö¤À¤±¤Ç¤¹¤è¤Í¡£(¾Ð)


ËÜÅö¤ÏMySQL¥ì¥×¥ê¥±¡¼¥·¥ç¥óµ¡Ç½¤òÍøÍѤ·¤¿¤¤¤È¤³¤í¤Ç¤¹¤¬

¡Ö XOOPS¤ÎÏÃÂê ¡×¤Ç¿¨¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢ËÜÅö¤Ï¡¢MySQLËÜÂÎÆ⡤Υì¥×¥ê¥±¡¼¥·¥ç¥óµ¡Ç½¤òÍøÍѤ·¤Æ£Ä£Â¤Î¥ß¥é¡¼¥ê¥ó¥°¤ò¤·¤¿¤¤¤È¤³¤í¤Ç¤¹¡£ÌµÂ̤¬Ìµ¤¯¤Ê¤ê¤Þ¤¹¤è¤Í¡£XREA¤µ¤ó¤Ç¤Ïº£¤Î¤È¤³¤íÂбþ¤ÎÃû¤·¤Ï¤¢¤ê¤Þ¤»¤ó¤Í¡£XREA¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ
¢¨ ¤ß¤ó¤Ê¤ÇÍ×˾¤·¤Þ¤»¤ó¤«¡© Âбþ¤Ã¤Æ¸À¤Ã¤Æ¤â¡¢MySQL¥·¥¹¥Æ¥àÊÑ¿ô¤Î¥Õ¥é¥Ã¥°¤òΩ¤Æ¤ë¤À¤±¤Î¤³¤È¤Ê¤Î¤Ç¤¹¤±¤É¤Í¡£MySQLËÜÂÎɸ½àÆ⡵¡Ç½¤Î£±¤Ä¤Ê¤ó¤Ç¤¹¤è¤Í¡£


£Ñ¡õ£Á

£æ£ô£ð¤Ç¹Ô¤¨¤Ð½½Ê¬¤¸¤ã¤Ê¤¤¤ó¤Ç¤¹¤«¡©

¢¨ É®¼Ô¤â¡¢ncftp ¤òÍøÍѤ·¤Æ¼«Æ°Ìµ¿Í¤Ç¥Õ¥¡¥¤¥ë¤Î¥¢¥Ã¥×¥í¡¼¥É¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¤è¡£¤Ç¤â¤Í¡¢¥·¥ó¥Ü¥ê¥Ã¥¯¥ê¥ó¥¯¥Õ¥¡¥¤¥ë¤ä¡¢¥ê¥¢¥ë¥ê¥ó¥¯¥Õ¥¡¥¤¥ë¤òÀµ³Î¤Ë°·¤¦¤¿¤á¤Ë¤Ï¡¢£æ£ô£ð¤Ç¤Ï̵Íý¤Ê¤ó¤Ç¤¹¤è¡££ò£ó£ù£î£ã¤Ç¤Ê¤¤¤È̵Íý¤Ê¤ó¤Ç¤¹¤è¤Í¡£
¢¨ ¤À¤«¤é¡Ö net2ftp ¡×¤Ç¤Ï°Û¤Ê¤ë¥µ¡¼¥Ð¡¼¤Ø¤Î¥ß¥é¡¼¥ê¥ó¥°¤Ë¤Ï¸Â³¦¤¬¤¢¤ë¤Î¤Ç¤¹¡£¤Þ¤¢¡¢XREA¤µ¤ó¤Înet2ftp´Ä¶­¤Ï¥¿¥¤¥à¥¢¥¦¥È»þ´Ö¤¬Ã»¤¹¤®¤Þ¤¹¤«¤é¡¢¥ß¥é¡¼¥ê¥ó¥°¤Ë¤ÏÉÔ¸þ¤­¤Ç¤¹¤è¤Í¡£(Èù¾Ð)


¿Æµµ¤³¤±¤¿¤é¡¢¤ß¤Ê¤³¤±¤¿

¡ÖXREA¤Ç´°àúXOOPS¡×¤Ç¤¹¤«¤é¡¢¡Ö¥µ¡¼¥Ð¡¼£Á¡×¤â¡¢¤½¤·¤Æ¡Ö¥µ¡¼¥Ð¡¼£Â¡×¤â£Ø£Ò£Å£Á¥µ¡¼¥Ð¡¼µ¡¤òÁªÂò¤·¤Þ¤¹¤«¡£XREA¥µ¡¼¥Ð¡¼¤µ¤ó¤Î¡Ö¥µ¡¼¥Ð¡¼µ¡¤ÎÀßÃÖµòÅÀ¤¬¿ô£±£°£°£ë£íÎ¥¤ì¤Æ¤¤¤ë¡×¤È¤Ï¹Í¤¨Æñ¤¤¤Î¤Ç¤¹¡£¥á¥ó¥Æ¥Ê¥ó¥¹¡¦¥³¥¹¥È¤ò²¼¤²¤ë¤¿¤á¤Ë¤Ï¡¢µòÅÀ´ÉÍý¤ò¹Ô¤¦¤Ï¤º¤Ç¤¹¤è¤Í¡£Ì䤤¹ç¤ï¤»¤Ï¤·¤Æ¤¤¤Ê¤¤¤Î¤Ç´Ö°ã¤¤¤¬¤¢¤ì¤Ð¤´»ØŦ¤¯¤À¤µ¤¤¤Þ¤»¡£m(__)m
¡¡ºÆÅÙ¡¢ÂçÃϿ̤¬µ¯¤³¤Ã¤Æ¡¢XREA¥µ¡¼¥Ð¡¼¤µ¤ó¤¬Èï³²¤ò¼õ¤±¤¿¤Ê¤é¡¦¡¦¡¦¡¦¥ß¥é¡¼¥ê¥ó¥°¤¬Ìµ°ÕÌ£¤Ë¤Ê¤ë²ÄǽÀ­¤Þ¤Ç¤ò¹Í¤¨¤Þ¤¹¤«¡£(´À);
¡¡¤½¤Î¤¿¤á¤Î¥µ¡¼¥Ð¡¼£Ãµ¡¤È¤â¸À¤¨¤Þ¤¹¤è¤Í¡£²¾¤ËÂ絬ÌϤÊÅ·ºÒ¤Ë¤è¤ëXREA¤µ¤ó¤Î¥µ¡¼¥Ð¡¼µ¡·²¤òÄä»ß¤µ¤»¤ë¤è¤¦¤Ê»´»ö¤òÈï¤Ã¤Æ¤â¡¢¥µ¡¼¥Ð¡¼£Ãµ¡¤¬»Ä¤ë¤ï¤±¤Ç¤¹¤è¤Í¡£
ÆüËÜÎóÅç¥ì¥Ù¥ë¤Ç³èÃÇÁؤò±ó¤¯Î¥¤ì¤¿¡¢±ó³ÖÃϤòÍøÍѤ·¤¿¥ß¥é¡¼¥ê¥ó¥°¤¬Îɤ¤¤Ç¤¹¤Í¡£Âè»Í¤Î Free Web Hosting ¤òÊƹñ¤Ê¤É¤Ç¼êÇÛ¤·¡¢OpenSSL°Å¹æ²½¤·¤¿¥¢¡¼¥«¥¤¥Ö¤ò¡¢ncftp¤Ê¤êscp¤ÇžÁ÷¤·¤Æ¤ª¤­¤Þ¤¹¤«¡£


¢¨ ½ç¡¡Ï©

XREA¤Ç´°àúXOOPS ¤½¤Î£¸
¡¡¤¢¤ÎÊØÍø¤Ê Lightbox Plus ¤ò myAlbum-P 2.9 ¤Ë¼ÂÁõ¤·¤è¤¦¤«¡¡


¡¡ºÇ¾åÉô¤Ë°ÜÆ°¤¹¤ë¡¡¡¡¡ÖXOOPS¤ÎÏÃÂê¡×¤ØÌ᤹¡¡¡¡Ê£¿ô¥µ¡¼¥Ð¡¼¤Ç½èÍý®ÅÙ¤ò¸þ¾å¡¡
2007ǯ10·î15Æü(·î) 02:56:51 Modified by mmj_aos

źÉÕ¥Õ¥¡¥¤¥ë°ìÍ÷(Á´1·ï)
5532899c931d8596.pdf (13.94KB)
Uploaded by mmj_aos 2007ǯ05·î18Æü(¶â) 13:15:10



¥¹¥Þ¡¼¥È¥Õ¥©¥óÈǤǸ«¤ë