ubuntu8.04.2ÏÂApache+Resin+Mysql°²×°+ÐéÄâÖ÷»úÅäÖÃ
Ò» Apache°²×°
# tar zxvf httpd-2.2.14.tar.gz(½âѹ)
# cd httpd-2.2.14(½øÈë½âѹºóµÄĿ¼)
# ./configure --prefix=/usr/local/apache2 --enable-so --enable-mods-shared=all
(ÃüÁî#./configure --help¿ÉÒԲ鿴configureµÄÅäÖòÎÊý
--prefix=°²×°Â·¾¶
--enable-so //´ò¿ª DSO Ö§³ÖµÄ apache ºËÐÄÄ£¿é
--enable-mods-shared=all //½«È«²¿µÄÄ£°å±àÒë³ÉDSO£¬¶ÔÓÚ²»ÐèÒªÎÒÃÇ¿ÉÒÔÔÚhttpd.confÈ¥µô
)
# make
# make install
configureʱ³öÏÖ±àÒë´íÎóÌáʾΪûC±àÒ빤¾ß£¬½â¾ö·½·¨£º
°²×°GCC
#sudo apt-get install build-essential
³öÏÖ¹ØÓÚzlibµÄ´íÎó£¬ÔÒòÊÇȱÉÙzlib
linuxϱàÒë°²×°zlib
zlib¹Ù·½ÍøÕ¾£º
http://www.zlib.net
ÉÏÏÂÔØÔ´ÂëÀ´°²×°zlibÈí¼þ°ü¡£
Ŀǰ×îа汾zlibÊÇzlib1.2.3£¬°²×°¿ªÊ¼£»
# wget http://www.zlib.net/zlib-1.2.3.tar.gz
# tar -xvzf zlib-1.2.3.tar.gz
# cd zlib-1.2.3.tar.gz
# ./configure
# make
# sudo make install
Æô¶¯Apache(rootÓû§²ÅÄÜ)
# /usr/local/apache2/bin/apachectl start
²é¿´±àÒë½øapacheµÄÄ£¿é
# /usr/local/apache2/bin/httpd -l
¿ª»úÆô¶¯Apache
# cp /usr/local/apache2/bin/apachectl /etc/init.d/apachectl
# sysvconfig(ÊÇͼÐνçÃæ£¬½«apachectlÑ¡ÖÐ)
=======================================================================================================================
¶þ Mysql°²×°
# tar zvxf mysql-5.1.39.tar.gz
# cd mysql-5.1.39
# ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_bin --with-extra-charsets=big5,ascii,gb2312,gbk,utf8,latin1
//ĬÈϵÄ×Ö·û¼¯È±Ê¡Îªlatin1¡£
//ÆäÖУ¬utf8¶ÔÓ¦¿ÉÓõÄcollationֵΪ£ºutf8_bin¡¢utf8_general_ci¡¢utf8_unicode_ci
//extraÖ§³ÖÒ²¿ÉÒÔʹÓà "--with-extra-charsets=all"¡£
//ĬÈÏconfigure²ÎÊýϲ»»á°²×°gbk±àÂë
ÅäÖóɹ¦»áÌáʾ£º
MySQL has a Web site at [URL="http://www.mysql.com/"][COLOR=#000000]http://www.mysql.com/[/COLOR][/URL] whic
Ïà¹ØÎĵµ£º
²»Í¬Êý¾Ý¿âÖ®¼äµÄÓï·¨²îÒì»¹Õæ²»ÉÙ~Òª±ÀÀ£ÁË¡£
1.´´½¨´ø×ÔÔöÁÐÁÙʱ±í£ºcreate TEMPORARY table t(id int AUTO_INCREMENT PRIMARY key, u_name varchar(50));--Ϊʲô±ØÐëÒªÖ÷¼ü£¿£¡
ÏòÕâ¸öÁÙʱ±íÖвåÈëÊý¾Ý£ºinsert into t values(null, 'zdy');--Ϊʲôһ¶¨Òª¼Ónull£¿£¡
2.°ÑÒ»ÕűíµÄ²éѯ½á¹û²åÈëÁÙʱ±í£ºinsert into t ......
ÔÚApache, PHP, MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½ÓÓ°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´óµÄÒ»¸ö²¿·Ö£¬²»µ«ÐèÒªÀí½âһЩMySQLרҵ֪ʶ£¬Í¬Ê±»¹ÐèÒª³¤Ê±¼äµÄ¹Û²ìͳ¼Æ²¢ÇÒ¸ù¾Ý¾Ñé½øÐÐÅжϣ¬È»ºóÉèÖúÏÀíµÄ²ÎÊý¡ ......
1¡¢¿´»úÆ÷ÅäÖã¬Ö¸Èý´ó¼þ£ºcpu¡¢ÄÚ´æ¡¢Ó²ÅÌ
2¡¢¿´mysqlÅäÖòÎÊý
3¡¢²éϵmysqlÐÐ״̬£¬¿ÉÒÔÓÃmysqlreport¹¤¾ßÀ´²é¿´
4¡¢²é¿´mysqlµÄÂý²éѯ
ÒÀ´Î½â¾öÁËÒÔÉÏÎÊÌâÖ®ºó£¬ÔÙÀ´²éÕÒ³ÌÐò·½ÃæµÄÎÊÌâ
my.cnf»º´æÓÅ»¯
ÔÚ my.cnf ÖÐÌí¼Ó/ÐÞ¸ÄÒÔÏÂÑ¡Ïî:
#È¡ÏûÎļþϵͳµÄÍâ²¿Ëø
skip-locking
#²»½øÐÐÓòÃû·´½âÎö,×¢Òâ ......
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
mysqladmin start
/ect/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
mysqladmin shutdown
/ect/init.d/mysql&nbs ......
¸ã¶¨MySQLÊý¾Ý¿âÖÐÎÄÄ£ºý¼ìË÷ÎÊÌâ
×÷Õß: bianceng, ¡¡³ö´¦:ITר¼ÒÍøÂÛ̳,¡¡ÔðÈαà¼: ³Â×Óç÷,¡¡
2009-10-28 07:00
¡¡¡¡ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØÒ»Ð©ÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£
¡¡¡¡ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØÒ»Ð©Óë ......