Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

mysql ÃüÁî

1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖظ´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âÇ°£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......

¡¾×ª¡¿MySQLÓÅ»¯¼òÃ÷Ö¸ÄÏ

Ò»¡¢ÔÚ±àÒëʱÓÅ»¯MySQL 
Èç¹ûÄã´ÓÔ´´úÂë·Ö·¢°²×°MySQL£¬Òª×¢Ò⣬±àÒë¹ý³Ì¶ÔÒÔºóµÄÄ¿±ê³ÌÐòÐÔÄÜÓÐÖØÒªµÄÓ°Ï죬²»Í¬µÄ±àÒ뷽ʽ¿ÉÄܵõ½ÀàËƵÄÄ¿±êÎļþ£¬µ«ÐÔÄÜ¿ÉÄÜÏà²îºÜ´ó£¬Òò´Ë£¬ÔÚ±àÒë°²×°MySQLÊÊÓ¦×Ðϸ¸ù¾ÝÄãµÄÓ¦ÓÃÀàÐÍÑ¡Ôñ×î¿ÉÄܺõıàÒëÑ¡Ïî¡£ÕâÖÖ¶¨ÖƵÄMySQL¿ÉÒÔΪÄãµÄÓ¦ÓÃÌṩ×î¼ÑÐÔÄÜ¡£
¼¼ÇÉ£ºÑ¡ÓýϺõıà ......

MySQL È«ÎļìË÷ ʵÏÖÖÐÎļìË÷

ͨ¹ýMySQLÄÚÖÃÈ«ÎļìË÷ʵÏÖÖÐÎĵÄÏà¹Ø¼ìË÷
¹Ø¼ü×Ö£ºMySQL È«ÎļìË÷ È«ÎÄË÷Òý ÖÐÎÄ·Ö´Ê ¶þÔª·Ö´Ê ÇøλÂë ÏàËƶÈ
×¢£º±¾ÎÄʹÓõÄMySQL°æ±¾Îª£ºMySQL 4.0.x
ÔÚMySQL4ÖУ¬ÊÇÒѾ­¿ªÊ¼Ö§³ÖÈ«ÎļìË÷£¨Ë÷Òý£©µÄÁË¡£µ«ÊÇÖ»ÊǶÔÓ¢ÎÄÖ§³ÖÈ«ÎļìË÷¡£
ÓÉÓÚÓ¢ÎÄÔÚÊéдÉϵÄÌØÊâÐÔ£¬Ê¹µÃ·Ö´ÊËã·¨Ïà¶ÔÖÐÎÄÀ´Ëµ£¬¼òµ¥µÃ¶à¡£Ò»°ãÀ´Ëµ£¬ÎÒÃÇ ......

CentOSÏÂÎÞ·¨Õý³£»ñÈ¡MySQLÊý¾Ý¿â±íÊý¾ÝµÄÎÊÌâ

 
֮ǰ£¬ÓÉÓÚ¿Í»§ÒªÇóÔÚcentOSÏ°²×°ÏµÍ³Ó¦Óã¬Òò´ËÓлú»á½Ó´¥ÁËÒ»ÏÂCentOS£¬Ë³±ãÒ²Á˽âÁËÏÂCentOSµÄ³£¹æ²Ù×÷£¬»¹ÓÐÔÚCentOSϵÄMySQLÏà¹Ø²Ù×÷¡£
Ä¿Ç°¼¼Êõ¿ò¼ÜʹÓÃJSF£¨richfaces¡¢facelets£©+Spring+JPA£¨OpenJPA£©£¬²»Ê¹ÓÃÊý¾Ý¿âÒÀÀµµÄ´¥·¢Æ÷»ò´æ´¢¹ý³Ì£¬ËùÓÐÒµÎñÂß¼­ÔÚweb·þÎñÆ÷ÉÏÖ´ÐУ¬Òò´ËÊý¾Ý¿â»ù±¾²»Óÿ¼ÂÇÒÆ ......

linux±¸·ÝmysqlÊý¾Ý¿â

¡¡MYSQL¶¨ÆÚ±¸·ÝÊÇÒ»ÏîÖØÒªµÄ¹¤×÷£¬µ«È˹¤²Ù×÷Ì«·±Ëö£¬Ò²ÄѱÜÃâÓÐËùÊè©£¬Ê¹ÓÃÏÂ
ÃæµÄ·½·¨¼´¿ÉÈÃϵͳ¶¨ÆÚ±¸·ÝÊý¾Ý¡£
¡¡¡¡1¡¢´´½¨±¸·ÝÎļþ¼Ð
¡¡¡¡#cd /www
¡¡¡¡#makedir backup
¡¡¡¡2¡¢±àдÔËÐнű¾
¡¡¡¡#vi autobackup
¡¡¡¡Ð´ÈëÒÔÏÂÄÚÈÝ£º
¡¡¡¡filename=`date +%Y%m%d`
¡¡¡¡mysql_bin_dir/mysqldump –opt da ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ