XREA¤Ç´°àúXOOPS ¤½¤Î£·
ÉûÂê | ¡¡´°Á´Ìµ¿Í¤ÇÁ´¼«Æ°¤Ë¤è¤ë¡¡ ¡¡£Í£ù£Ó£Ñ£Ì¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¤È¡¡ ¡¡£Ø£Ï£Ï£Ð£Ó¤Î¥ß¥é¡¼¥ê¥ó¥°¤ò¡¡ ¡¡¥µ¡¼¥Ð¡¼µ¡¤ò±Û¤¨¤Æ¹Ô¤¤¤Þ¤·¤ç¤¦¤«¡¡ |
¡¡±Ñ¸ì²½¡¡ | ËÜ¥Ú¡¼¥¸¤Îû½ÌURL: http://fs4y.com/?e=7 |
¡¡ËÜ¥Ú¡¼¥¸ËÜʸºÇ½ª¹¹¿·Æü»þ¡§ | ´ØÏ¢¥ê¥ó¥¯ | |||
¡¡2007/10/15 02:56am JST¡¡ | ¡¡¡ÖXOOPS¤ÎÏÃÂê¡×¤ØÌ᤹¡¡ | ¡¡Ê£¿ô¥µ¡¼¥Ð¡¼¤Ç½èÍý®ÅÙ¤ò¸þ¾å¡¡ | ||
½çÏ©¤ËÌá¤ë ¡ä¡ä¡ÖXREA¤Ç´°àúXOOPS ¤½¤Î£±¡× |
·Ù¡¡¹ð¡¡¤È¡¡ÌÈ¡¡ÀÕ |
¡¡¤³¤Î¥Ú¡¼¥¸¤Ç¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤òµºÜ¤·¤Æ¤¤¤Þ¤¹¤¬¡¢¤¢¤Ê¤¿¤¬¼Â»Ü¤µ¤ì¤ë¾ì¹ç¤Ë¤Ï½½Ê¬¤Ê¥¹¥¥ë¤¬¤¢¤ë¤³¤È¤ò´üÂÔ¤·¤Þ¤¹¡£¥¹¥¥ë¤Î̵¤¤Êý¤¬½½Ê¬¤Ê¥Ç¥Ð¥Ã¥°¤ò¹Ô¤ï¤Ê¤¤¡¢¤Þ¤¿¤Ï¹½Ê¸¥ß¥¹¤òÈȤ·¤ÆÍøÍѤ·¡¢½ÅÂç¤Ê»öÂ֡ʽÅÍפÊÁ´¤Æ¤Î¥Õ¥¡¥¤¥ë¤Ê¤É¤¬ÉÔËܰդ˾üº¤¹¤ë¤Ê¤É¡Ë¤¬À¸¤¸¤Þ¤·¤Æ¤â¡¢Â¾¤¢¤é¤æ¤ë¥È¥é¥Ö¥ë¤ò¾·¤¤¤Æ¤â¡¢É®¼Ô¤ÏÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£ËÜÅÀ¤òÍý²ò¤Ç¤¤Ê¤¤Êý¤Ï¡¢ËÜ¥Ú¡¼¥¸¤òÆɤ߿ʤޤʤ¤¤è¤¦¤Ë´ê¤¤¤Þ¤¹¡£ ¢¨ À§È󡢿ȶá¤ÎLinux¤Ê¤êUNIX¤ò½ÏÃΤ·¤¿Êý¤Î±ç½õ¤òÆÀ¤ë¤è¤¦¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡ª |
¡ÚÌܼ¡¡Û
- ssh ¸ø³«¸°¤ÎºîÀ®
- Ìë´Ö¿¼Ìë¡¢ÁáÄ«¤ËMySQL¤Î¥Ç¡¼¥¿¡¼¤òÁ´¼«Æ°¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë¡£¡Ú¥µ¡¼¥Ð¡¼£Á¡Û
- ¥µ¡¼¥Ð¡¼£Ã¤Îcrontab¤Ë¥È¥ê¥¬¡¼¤òËä¤á¹þ¤ß¤Þ¤¹¡£
- £ò£ó£ù£î£ã¤ò¥µ¡¼¥Ð¡¼£Ã·Ðͳ¤Ç¡¢¥ß¥é¡¼¥ê¥ó¥°¤ò¹Ô¤¦¡£
- £¹£°Æü¤è¤ê¤â¸Å¤¤¥Ð¥Ã¥¯¥¢¥Ã¥×¤Ï¼«Æ°¾ÃÌǤµ¤»¤Þ¤¹¤«
- ɬ¤ºMySQL¤Î¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤Î¥¤¥ó¥Ý¡¼¥È¸¡¾Ú¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡ª ɬ¤º¡ª¡ª
- ·ëÏÀ
- XREA»ÅÍͤ賦
- ËÜÅö¤ÏMySQL¥ì¥×¥ê¥±¡¼¥·¥ç¥óµ¡Ç½¤òÍøÍѤ·¤¿¤¤¤È¤³¤í¤Ç¤¹¤¬
- £Ñ¡õ£Á
- ¿Æµµ¤³¤±¤¿¤é¡¢¤ß¤Ê¤³¤±¤¿
- ¢¨ ½ç¡¡Ï©
ssh ¸ø³«¸°¤ÎºîÀ®
¢¨ XREA+¤Î·ÀÌó¤Ë¤è¤ëcrontabÍøÍѤβÄÈݤ˴ط¸Ìµ¤¯¡¢Á´¤¯Â¾¤Î¥µ¡¼¥Ð¡¼¤Ë¥Ç¡¼¥¿¡¼¤òÊݴɤ¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£¡ä¡¡£±¡¥¥µ¡¼¥Ð¡¼£Ã¤Ç£Ó£Ó£È¸ø³«¸°¤òÀ¸À®¤µ¤»¤Þ¤¹¡£¥³¥á¥ó¥È¤Ë¤ÏºîÀ®ÆüÉդȤ¢¤Ê¤¿¤Î¥¤¥Ë¥·¥ã¥ë¤Ç¤âÆþ¤ì¤Æ¤ª¤¤Þ¤¹¤«¡£»²¹ÍURL¡Ö SSH2 ¤È OpenSSH ¡×
¤³¤³¤Ç¤ÏÎã¤È¤·¤Æ¡¢XOOPS¤¬£²¤Ä¤Î¥µ¡¼¥Ð¡¼¤Ç²ÔÆ°Ãæ¤Ç¤¢¤Ã¤Æ¡¢Ì¾¾Î¡Ö¥µ¡¼¥Ð¡¼£Á¡×¤¬º£¸½ºßÍøÍÑÃæ¤Î£Ø£Ï£Ï£Ð£Ó¥Þ¥¹¥¿¡¼¥µ¡¼¥Ð¡¼¤È²¾Äꤷ¤Þ¤·¤ç¤¦¡£
¤½¤·¤Æ¡¢Á´¤¯Æ±¤¸£Ø£Ï£Ï£Ð£Ó¤¬Ì¾¾Î¡Ö¥µ¡¼¥Ð¡¼£Â¡×¤Ë¤â¸ºß¤·¡¢¤¤¤Ä¤Ç¤âÍøÍѳ«»Ï¤Ç¤¤ë¥ß¥é¡¼£Ø£Ï£Ï£Ð£Ó¥·¥¹¥Æ¥à¤È¤·¤Æ£Ø£Ï£Ï£Ð£Ó¥¹¥ì¡¼¥Ö¥µ¡¼¥Ð¡¼¤¬Â¸ºß¤¹¤ë¤â¤Î¤È²¾Äꤷ¤Þ¤¹¡£
¸å¤Ï,¡Ö¥µ¡¼¥Ð¡¼£Á¡×¤Ë¤â¡Ö¥µ¡¼¥Ð¡¼£Â¡×¤Ë¤â£Ó£Ó£ÈÀܳ¤¬²Äǽ¤Ç¤¢¤Ã¤Æ¡¢CRONTAB¤òÍøÍѤǤ¤ë¡Ö¥µ¡¼¥Ð¡¼£Ã¡×¤òÍÑ°Õ¤·¤Þ¤¹¡£²ñ¼Ò(¼«Âð)¥µ¡¼¥Ð¡¼¤Ê¤ê¤òÁÛÄꤷ¤Þ¤¹¤«¡£(Èù¾Ð)
½èÍý¤ÎÆâÍƤȤϡ¢¿¼Ìë(ÆüËÜ»þ´Ö¤Ç¤¹¤¬¡¦¡¦¡¦ ^^;)¡¢¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î¥È¥ê¥¬¡¼¤Ç¡¢¥µ¡¼¥Ð¡¼£Á¤ÎMySQL¥Ç¡¼¥¿¡¼¤ò¥À¥ó¥×¤·¤Þ¤¹¡£¤½¤·¤Æ¡¢¥µ¡¼¥Ð¡¼£Ã¤«¤é¤Î»Ø¼¨¤Ç¡¢¥µ¡¼¥Ð¡¼£Á¤ÎMySQL¥Ç¡¼¥¿¡¼¤Î¥À¥ó¥×¥Ç¡¼¥¿¡¼¤ò¡¢¥µ¡¼¥Ð¡¼£Â¤ËžÁ÷¤·¤Æ¤ª¤¤Þ¤¹¡£
¥µ¡¼¥Ð¡¼£Ã¤¬¥¸¥ç¥Ö¥³¥ó¥È¥í¡¼¥ë¥»¥ó¥¿¡¼¤È¤·¤Æ¡¢¥È¥ê¥¬¡¼¤Îȯ¹Ô¤ò¹Ô¤¤¤Þ¤¹¡£¥µ¡¼¥Ð¡¼£Ã¤Ë¤Ï¡¢XOOPS¤â¡¢MySQL¤â̵ÍѤǤ¹¡£crontab¡ÜSSH¡Ü¥¤¥ó¥¿¡¼¥Í¥Ã¥ÈÀܳ¤À¤±¤¬¤Ç¤¤ì¤Ð½½Ê¬¤Ç¤¹¡£³ØÆâ¡¢²ñ¼ÒÆâ¤Î£Ì£Á£Î¤ÎÊÒ¶ù¤ÎLinux(UNIX)¥Þ¥·¡¼¥ó¤Ç½½Ê¬¤Ç¤¹¡£(Èù¾Ð)
¡¡¥µ¡¼¥Ð¡¼£Ãµ¡¤Ï¡¢¤¢¤Ê¤¿¤Î¼é¸îÎî¤È¤Ê¤ë¤Ç¤·¤ç¤¦¡£Å·»È¤«¤âÃΤì¤Þ¤»¤ó¤è¡£¤½¤ì¤Ï¥µ¡¼¥Ð¡¼£Áµ¡¤¬µ¡Ç½ÉÔÁ´¤òµ¯¤³¤·¤¿»þ¤ËȽ¤ë¤³¤È¤Ç¤¹¡£¾Ü¤·¤¯¤Ï¡¢ËÜ¥Ú¡¼¥¸¤Î½ªÃåÅÀ¡Ö·ëÏÀ¡×¤ò¤ªÆɤߤ¯¤À¤µ¤ì¤Ð¡¢¥µ¡¼¥Ð¡¼£Ãµ¡¤Î½ÅÍ×À¤Ëµ¤ÉÕ¤¤¤Æ¤¯¤À¤µ¤ë¤Ç¤·¤ç¤¦¤«¡£¥µ¡¼¥Ð¡¼£Ãµ¡¤Ë¤â̵ÄäÅÅÅŸ»ÁõÃÖ¤Ïɬ¿Ü¤Ç¤¹¤è¤Í¡£Å·»È¤¬»à¤ó¤Ç¤Ï¤¤¤±¤Þ¤»¤ó¤«¤é¤Í(Èù¾Ð)
$¡¡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¤ÎÏÃÂê¡×¤ØÌ᤹¡¡ | ¡¡Ê£¿ô¥µ¡¼¥Ð¡¼¤Ç½èÍý®ÅÙ¤ò¸þ¾å¡¡ |
¥³¥á¥ó¥È(0) ¡Ã
¥«¥Æ¥´¥ê¡§¥¤¥ó¥¿¡¼¥Í¥Ã¥È > 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
Uploaded by mmj_aos 2007ǯ05·î18Æü(¶â) 13:15:10