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

Linux°²×°apache¡¢phpºÍmysql·½·¨

apacheµÄÔ´Âë°²×° 
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \   #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/apache" \  #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-included-apr" \
"--enable-so" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿éÖ§³Ö
"--enable-deflate=shared" \
"--enable-expires=shared" \
"--enable-rewrite=shared" \
"--enable-static-support" \
"--disable-userdir"
make #--------------------±àÒë
make install  #--------------------±àÒë°²×°
phpµÄÔ´Âë°²×°
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \ #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/php" \ #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-apxs2=/usr/local/apache/bin/apxs" \
"--with-config-file-path=/usr/local/php/etc" \
"--with-mysql=/usr/local/mysql" \
"--with-libxml-dir=/usr/local/libxml2" \
"--with-gd=/usr/local/gd2" \
"--with-jpeg-dir" \
"--with-png-dir" \
"--with-bz2" \
"--with-iconv-dir" \
"--with-zlib-dir " \
"--with-mcrypt=/usr/local/libmcrypt" \
"--enable-soap" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿éÖ§³Ö
"--enable-gd-native-ttf" \
"--enable-memory-limit" \
"--enable-ftp" \
"--enable-mbstring" \
"--enable-exif" \
"--disable-ipv6" \
"--disable-cgi" \
"--disable-cli"
mysqlµÄ°²×°
Ê×ÏÈΪmysql½¨Á¢ÏàÓ¦µÄÓû§ºÍ×é
groupadd mysql     
useradd -g mysql -s /sbin/nologin mysql
ÕÒµ½mysql_install_db½Å±¾²¢Ö´ÐÐmysql_install_db --user=mysql£¨ÆäÖпÉÒÔÀàËƵļÓÏàÓ¦µÄ²ÎÊý
Mysql_install_db --defaults-file=/test/Mysql/my.cnf --user=Mysql Èô²»¼Ó²ÎÊý£¬°²×°Ê±Ä¬È϶ÁÈ¡/etc/my.cnf£©
ΪÕû¸ömysqlĿ¼¸³777ȨÏÞ£¬ÇÒÆäÖеÄdataĿ¼Óû§ºÍ×é¾ùΪmysql
chown -R root .
chown -R mysql data 
chgrp -R mysql .
×îºóÆô¶¯Êý¾Ý¿â¼´¿É
bin/mysqld_safe --user=mysql &


Ïà¹ØÎĵµ£º

MYSQL ɾ³ýͬһ±íÖÐÖظ´¼Ç¼

MYSQL ɾ³ýͬһ±íÖÐÖظ´¼Ç¼
CREATE TABLE `user` (
  `db_id` varchar(255) NOT NULL,
  `name` varchar(45) default NULL,
  `age` int(10) unsigned NOT NULL,
  `address` varchar(45) default NULL,
  PRIMARY KEY  (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 &nb ......

mysql µ¼Èë¡¢µ¼³öÊý¾Ý¿â¡¢±í

DOS¡¡´°¿Ú
¿ªÊ¼£­£¾ÔËÐУ­£¾¡¡cmd
µ¼³öΪ£º¡¡mysqldump -u Óû§Ãû -p  --opt  Êý¾Ý¿âÓû§Ãû >
Êý¾Ý¿âÃû.sql
ÊäÈëÄãµÄÊý¾Ý¿âÃÜÂë!phpma.com
µ¼ÈëΪ£ºmysql -u Óû§Ãû -p Êý¾Ý¿âÓû§Ãû < Êý¾Ý¿âÃû.sql
£¨Òª
ÔÚµ±Ç°Ä¿Â¼Ï²Ù×÷£©
ÒªÏ뽫Îı¾Îļþ

pet.txt

×°Ôص½
pet
±íÖУ¬Ê¹Ó ......

¸ü¶àMySQLÃüÁÍü

Ò» . °²×°ÓëÅäÖÃMYSQL 
¡¡¡¡¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî 
¡¡¡¡1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹ 
¡¡¡¡Æô¶¯MYSQL·þÎñ net start mysql 
¡¡¡¡Í£Ö¹MYSQL·þÎñ net stop mysql 
¡¡¡¡2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ 
¡¡¡¡3 . ÔÚÃüÁîÐÐÖеǽ ......

linuxÎļþµÄȨÏÞÐÞ¸ÄchmodÓ÷¨

Ö¸ÁîÃû³Æ : chmod
ʹÓÃȨÏÞ : ËùÓÐʹÓÃÕß
ʹÓ÷½Ê½ : chmod [-cfvR] [--help] [--version] mode file...
˵Ã÷ : Linux/Unix µÄµµ°¸µ÷ÓÃȨÏÞ·ÖΪÈý¼¶ : µµ°¸ÓµÓÐÕß¡¢Èº×é¡¢ÆäËû¡£ÀûÓà chmod ¿ÉÒÔ½åÒÔ¿ØÖƵµ°¸ÈçºÎ±»ËûÈËËùµ÷Óá£
²ÎÊý :
mode : ȨÏÞÉ趨×Ö´®£¬¸ñʽÈçÏ : [ugoa...][[+-=][rwxX]...][,...]£¬ÆäÖÐ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ