Joomla! ½¨Õ¾³ÌÐòµÄ°²×°(xampp¡¢apacheºÍMysqlÉèÖÃ)
´Ë´¦ÔËÓÃÁËÒ»¸ö¼¯³ÉµÄxampp¼Ü¹¹¡£²»Óõ¥¶ÀÈ¥°²×°apache·þÎñÆ÷£¬mysqlÊý¾Ý¿â£¬µÈµÈ¡£
£¨Ò»£©XamppµÄ°²×°
ÏÂÔØxampp
1. Ë«»÷xampp£¬µã»÷ÏÂÒ»²½£¬ÏÂÒ»²½£¬ÈçÊÇ£¬¾Í°²×°ÁËxampp¡££¨´Ë´¦°²×°ÔÚÁËc£º\sandboxÏÂÃæÁË£©
2. ½øÐÐxampp°²×°ÊÇ·ñ³É¹¦µÄ²âÊÔ£º
´ò¿ª£ºc:\sandbox\xamppÎļþ¼Ð
ÀïÃæÓм¸¸öÎļþ¼Ð£¬½éÉÜһϣº
apacheÎļþ¼Ð£ºapache·þÎñÆ÷µÄÎļþ¼Ð£¬Ò»Ð©ÉèÖÃÔÚÕâÀïÃæ½øÐС£
HtdocsÎļþ¼Ð£ºÀïÃæ·ÅÖÃjoomla¡£Ö±½ÓÏÂÔØjoomla£¬È»ºó½«Æä½âѹËõ£¬È»ºó½«½âѹµÄÎļþ¼Ð·Åµ½htdocsÏÂÃæ¾Í¿ÉÒÔÁË¡£
MysqlÎļþ¼Ð£º¸ÃÎļþ¼ÐÊÇmysqlÊý¾Ý¿âµÄÎļþ¼Ð£¬»ù±¾²»Óôò¿ª´ËÎļþ¼Ð¡£
PhpÎļþ¼Ð£º¸ÃÎļþ¼Ð·ÅÖÃphpÓïÑÔµÄһЩ¹æÔò¡£ËµÃ÷ÎÒÃÇÔËÐÐjoomlaµÄʱºòÊÇÓõÄphpÓïÑÔ¡£²»ÓøĶ¯´ËÎļþ¼Ð¡£
PhpmyadminÎļþ¼Ð£ºÊÇÒ»¸ö¹ÜÀíÎļþ¼Ð¡£ÓÃÀ´´´½¨Êý¾Ý¿âµÈ¡££¨Êý¾Ý¿âµÄ´´½¨£ºÖ»ÐèÒª´´½¨¸ö¿â¾Í¿ÉÒÔÁË£¬Ò²¾ÍÊÇÖ»ÐèÒªÊäÈë¿âµÄÎļþÃû×Ö£¬ÆäËûµÄ¶¼ÊÇ×Ô¶¯Éú³ÉµÄ£©
ÉÏÃæÊÇÎļþ¼ÐµÄ½éÉÜ¡£ÏÂÃæ½éÉܼ¸¸öÎļþ£º
Apache_start.exe£ºË«»÷£¬¿ÉÒÔÔËÐÐapache·þÎñÆ÷¡£³öÏÖÒ»¸ö»Ãæ¡£
˵Ã÷ÔËÐгɹ¦£¬·ñÔò»áÌáʾ³öÏÖ´íÎóµÄ¡£
ÔÚÕâÀ¿ÉÄÜÓÐÁ½¸ö´íÎó£º
£¨1£©80»ò8080¶Ë¿Ú²»ÕýÈ·¡£Ò»°ãÊÇ80ºÍ8080ÕâÁ½¸ö·ÖÅäµÄÎÊÌâ¡£Èç¹ûÄãûÓа²×°IIS¡£ÄÇôÕâ¸öÎÊÌâÒ»°ã²»»á³öÏÖ¡£µ«Èç¹ûÄã°²×°ÁËIISÄÇô£¬ºÜÈÝÒ׺ÍIISµÄ¶Ë¿Ú·¢Éú³åÍ»¡£
½â¾ö°ì·¨:½«IISµÄ¶Ë¿ÚÉèÖÃΪ8080£¬½«apacheµÄ¶Ë¿ÚÉèÖÃΪ80 ¡£
½«IISµÄ¶Ë¿ÚÉèÖÃΪ8080µÄ·½·¨£º
µã»÷È·¶¨¾Í¿ÉÒÔÁË¡£
ÏÂÃ潫apacheµÄÉèÖÃΪ80£ºÓüÇʱ¾³ÌÐò ´ò¿ªc:\sandbox\xampp\apache\conf\httpd.conf£¬²éÕÒÆäÖеÄ8080£¬½«ÆäÈ«²¿¸ÄΪ80£¬±£´æ¼´¿É¡£
£¨µ±È»£¬Ò²¿ÉÒÔ½«IISµÄ¶Ë¿Ú¸ÄΪ80£¬½«apacheµÄ¸ÄΪ8080£¬µ«ÔÚ²âÊÔµÄʱºò£¬¾ÍÐèÒªÊäÈëhttp://127.0.0.1£º8080»òhttp://localhost£º8080²Å¿ÉÒÔ½øÐвâÊÔ¡£²»ÍƼöʹÓÃÕâÕý°ì·¨¡£ÒòΪÏà±ÈÇ°ÖÖ°ì·¨±È½ÏÂ鷳Щ¡££©
£¨2£©SSL¶Ë¿Ú²»ÕýÈ·¡£ºÍÉÏÃæÒ»Ñù¡£Èç¹û²»°²×°IIS£¬Õâ¸öÎÊÌ⣬һ°ã²»»á³öÏÖ¡£Èç¹û´æÔÚssl¶Ë¿ÚÎÊÌâ¡£½â¾ö°ì·¨ÈçÏ£ºÓüÇʱ¾´ò¿ªC:\sandbox\xampp\apache\conf\extra\httpd-ssl.conf ¡£²éÕÒÆäÖеÄÈ«²¿443£¬²¢½«Æä¸ÄΪ453¼´¿É£¨µ±È»¸Ä³É463£¬473¿ÉÄÜÒ²¿ÉÒÔ£©¡£
ÐÞ¸ÄÁËÕâÁ½¸öµØ·½Ö®ºó£¬ÏÈË«»÷c:\sandbox\xampp\ Apache_start.exe, ¿´ÊÇ·ñ³É¹¦¡£Èç¹û³É¹¦¡£È»ºóË«»÷×ÀÃæµÄxamp£¬´ò¿ªIEä¯ÀÀÆ÷½øÐв鿴£¬ÈçÏ£º
ÊäÈë£
Ïà¹ØÎĵµ£º
¡¡Ò»Ö±À§ÈÅÎÒ¿ì°ëÄêµÄÎÊÌâÖÕÓڵõ½½â¾ö, ·þÎñÆ÷µÄmysqlÀÏÊÇÔËÐÐÒ»¶Îʱ¼ä,×Ô¶¯Í£Ö¹ÁË,±ØÐëÊÖ¶¯Æô¶¯. !
¡¡¡¡ÎÒÕÒÆ«ÍøÉÏËùÓеķ½·¨,µ«Ã»ÓÐÒ»¸öÄܽâ¾ö,ʲôÐÞ¸ÄÅäÖÃÎļþ°¡.¶¨Ê±Æô¶¯.¶¼Ã»Ð§¹û. ¸ù¾Ýר¼Ò¹Û²ì£¬ÕâÑùµÄÀíÂÛºÍÏÖÏó¶¼ÊÇÖµµÃ¸÷λվ³¤Éî˼µÄ£¬ËùÒÔÏ£Íû´ó¼Ò¶à×öÑо¿Ñ§Ï°£¬ÕùÈ¡×ܽá³ö¸ü¶à¸üºÃµÄ¾Ñé!
¡¡¡¡Õâ¸ö·½·¨ÊÇÎÒ ......
ת:http://home.mysql.cn/space-51084-do-blog-id-43.html
±¾ÎÄÌÖÂÛ MySQL
µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM ºÍ Innodb£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ä¿Ç° MySQL
Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACKUP TABLE »òÕß SELECT
......
mysql×Ö·û¼¯ÉèÖúͲéѯÎÊÌ⣨ת£©
2010-04-14 11:33
MySQLµÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺
×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£
¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î:
·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó(connection) ......
MySQL EVENT
À´Ô´£ºhttp://samyu.blog.51cto.com/344284/146011
event_scheduler:
The MySQL event scheduler is a thread that runs in the background looking for events to execute. It spends a lot of time sleeping -- and won't do anything unless the new global variable "event_scheduler" is set t ......
MySQL»ù±¾ÊýÖµÀàÐÍ´óÖ¿ÉÒԷֳɣº
ÕûÊýÀàÐÍ£ºTINYINT¡¢SAMLLINT¡¢MEDIUMINT¡¢INT¡¢BIGINT--1×Ö½Ú¡¢2¡¢3.¡¢4¡¢8
¸¡µãÊýÀàÐÍ£ºFLOAT(m,d)¡¢DOUBLE(m,d)==REAL-4×Ö½Ú¡¢8
¶¨µãÊýÀàÐÍ£ºDECIMAL(m,d)¡¢NUMERIC-m+2×Ö½Ú¡¢8
λÀàÐÍ£ºBIT(m)-1-8×Ö½Ú
¸÷¸öÀàÐ͵ÄÏêϸ·¶Î§¿ÉÒԲο¼mysqlÎĵµ
Êý¾ÝÀàÐÍСÀý£º
1 ......