¼òµ¥ÅäÖÃapache + mysql + discuz +php
°²×°apache + mysql + discuz +php
apache http://www.apache.org/
mysql http://dev.mysql.com/downloads/
MySQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html
php http://www.php.net/
discuz http://www.comsenz.com/index.php
1.°²×°apache,ÐÞ¸Äconf\httpd.conf
LoadModule php5_module "D:/Work/php/php5apache2_2.dll" //PHPµÄphp5apache2_2.dll·¾¶
PHPiniDir "D:/Work/php" //PHP·¾¶
DirectoryIndex index.
php
index.html
2.°²×°PHP,ÐÞ¸Äphp.ini-distΪphp.ini
ÆôÓÃ extension=php_mysql.dll
extension_dir = “./” ¸ÄΪ extension_dir = “X:/php
/ext/
” //extµÄÎļþλÖÃ
3.°²×°MySQL
Ŀ¼ÖÐн¨Ò»¸ömy.iniÎļþ(²Î¿¼Ä¿Â¼ÖеÄÅäÖÃ)
4.°²×°MySQL GUI Tools
ÅäÖÃMySQLµÄ·þÎñ
6.°ÑDiscuz°²×°µ½apache\htdocsµÄÍøҳĿ¼ÖÐ
7.ä¯ÀÀÆ÷ÖÐÖ±½Ó°²×°Discuz localhost/dz/install.php
Ïà¹ØÎĵµ£º
Vs2005Á¬½ÓmysqlÊý¾Ý¿â
Ò»¡¢ÏÂÔØÖ§³ÖmysqlµÄ΢ÈíµÄͨÓÃÀàmysql-connector-net-1.0.7-noinstall.zip
¶þ¡¢ÏÂÔصØÖ·http://www.cnblogs.com/eugenewu0808/archive/2006/10/11/mysqldata.html
Èý¡¢½âѹÎļþ
ËÄ¡¢Ìí¼ÓÒýÓÃÕÒµ½binÎļþ¼ÐÕÒµ½net-2.0 vs2005µÄ£¨ºÍvsÏàÓ¦°æ±¾µÄ£©ÕÒµ½MySql.Data.dll
Îå¡¢ÔÚÀàÖÐÒýÓÃusing MySq ......
1.½ñÌìµÄ³ÌÐò·¢²¼µ½·þÎñÆ÷£¬¹ýÁËÒ»Ííºó·¢ÏÖ³ÌÐò²»ÄÜ·ÃÎÊÁË£¬ºÃÏñÊÇÁ¬½Ó³ØÎÊÌâ¡£´íÎóÈçÏ£º [log4j:] 2009-10-30 17:32:10,353 - com.school.dao.OperaDAO -65984388 [http-8080-12] ERROR com.school.dao.OperaDAO - find all failed
org.hibernate.exception.JDBCConnectionException: could not execute query ......
MySql »ù±¾²Ù×÷
Ò»¡¢»ù´¡
1£º µÇ½£ºmysql –u username –p <»Ø³µ¡· È»ºóÊäÈëÃÜÂë
2£º²é¿´Êý¾Ý¿â£ºshow databases£»
3£ºÊ¹ÓÃÊý¾Ý¿âuse databasename;
4: ³£¿´Êý¾Ý¿â±í show tables£» µ«ÊÇÇ°ÌáÊÇÄãÒѾʹÓÃÁËuse ÃüÁÈç¹ûûÓÐ µÄ»°¿ÉÒÔʹÓà show tables from databasename £»
5£º ²é¿´Êý ......
1.show status
Threads_connected µ±Ç°µÄÁ¬½ÓÊý
Connections ÊÔͼÁ¬½Óµ½(²»¹ÜÊÇ·ñ³É¹¦)MySQL·þÎñÆ÷µÄÁ¬½ÓÊý¡£
Max_used_connections ·þÎñÆ÷Æô¶¯ºóÒѾͬʱʹÓõÄÁ¬½ÓµÄ×î´óÊýÁ¿¡£
2.set GLOBAL max_connections=Á¬½ÓÊý;
flush privilege ......
±à¼my.cnfÎļþ£¬¼ÓÈ룺
log-slow-queries[=file] #ĬÈÏΪdataĿ¼ÏµÄhostname-slow.logÎļþ
long_query_time=10 (seconds) #Âý²éѯµÄthreshold
log-queries-not-using-indexes #¼Ç¼²»Ê¹ÓÃË÷ÒýµÄ²éѯ
mysqldumpslowÃüÁî»ñµÃÈÕÖ¾ÖÐÏÔʾµÄ²éѯժҪÀ´´¦ÀíÂý²éÑ¯È ......