MYSQL my.cnfÅäÖÃÖÐÎÄÏê½â
MYSQL--my.cnfÅäÖÃÖÐÎÄÏê½â ZZ2007Äê08ÔÂ16ÈÕ ÐÇÆÚËÄ 15:53mysqld³ÌÐò--Ŀ¼ºÍÎļþ
ÒýÓÃ
basedir = path ʹÓøø¶¨Ä¿Â¼×÷Ϊ¸ùĿ¼(°²×°Ä¿Â¼)¡£
character-sets-dir = path ¸ø³ö´æ·Å×Å×Ö·û¼¯µÄĿ¼¡£
datadir = path ´Ó¸ø¶¨Ä¿Â¼¶ÁÈ¡Êý¾Ý¿âÎļþ¡£
pid-file = filename Ϊmysqld³ÌÐòÖ¸¶¨Ò»¸ö´æ·Å½ø³ÌIDµÄÎļþ(½öÊÊÓÃÓÚUNIX/Linuxϵͳ); Init-V½Å±¾ÐèҪʹÓÃÕâ¸öÎļþÀïµÄ½ø³ÌID½áÊømysqld½ø³Ì¡£
socket = filename ΪMySQL¿Í»§³ÌÐòÓë·þÎñÆ÷Ö®¼äµÄ±¾µØͨÐÅÖ¸¶¨Ò»¸öÌ×½Ó×ÖÎļþ(½öÊÊÓÃÓÚUNIX/Linuxϵͳ; ĬÈÏÉèÖÃÒ»°ãÊÇ/var/lib/mysql/mysql.sockÎļþ)¡£ÔÚWindows»·¾³Ï£¬Èç¹ûMySQL¿Í»§Óë·þÎñÆ÷ÊÇͨ¹ýÃüÃû¹ÜµÀ½øÐÐͨÐÅ µÄ£¬--sockÑ¡Ïî¸ø³öµÄ½«ÊǸÃÃüÃû¹ÜµÀµÄÃû×Ö(ĬÈÏÉèÖÃÊÇMySQL)¡£
lower_case_table_name = 1/0 ÐÂĿ¼ºÍÊý¾Ý±íµÄÃû×ÖÊÇ·ñÖ»ÔÊÐíʹÓÃСд×Öĸ; Õâ¸öÑ¡ÏîÔÚWindows»·¾³ÏµÄĬÈÏÉèÖÃÊÇ1(Ö»ÔÊÐíʹÓÃСд×Öĸ)¡£
mysqld³ÌÐò--ÓïÑÔÉèÖÃ
ÒýÓÃ
character-sets-server = name ÐÂÊý¾Ý¿â»òÊý¾Ý±íµÄĬÈÏ×Ö·û¼¯¡£ÎªÁËÓëMySQLµÄÔçÆÚ°æ±¾±£³Ö¼æÈÝ£¬Õâ¸ö×Ö·û¼¯Ò²¿ÉÒÔÓÃ--default-character-setÑ¡Ïî¸ø³ö; µ«Õâ¸öÑ¡ÏîÒѾÏÔµÃÓеã¹ýʱÁË¡£
collation-server = name ÐÂÊý¾Ý¿â»òÊý¾Ý±íµÄĬÈÏÅÅÐò·½Ê½¡£
lanuage = name ÓÃÖ¸¶¨µÄÓïÑÔÏÔʾ³ö´íÐÅÏ¢¡£
mysqld³ÌÐò--ͨÐÅ¡¢ÍøÂç¡¢ÐÅÏ¢°²È«
ÒýÓÃ
enable-named-pipes ÔÊÐíWindows 2000/XP»·¾³ÏµĿͻ§ºÍ·þÎñÆ÷ʹÓÃÃüÃû¹ÜµÀ(named pipe)½øÐÐͨÐÅ¡£Õâ¸öÃüÃû¹ÜµÀµÄĬÈÏÃû×ÖÊÇMySQL£¬µ«¿ÉÒÔÓÃ--socketÑ¡ÏîÀ´¸Ä±ä¡£
local-infile [=0] ÔÊÐí/½ûֹʹÓÃLOAD DATA LOCALÓï¾äÀ´´¦Àí±¾µØÎļþ¡£
myisam-recover [=opt1, opt2, ...] ÔÚÆô¶¯Ê±×Ô¶¯ÐÞ¸´ËùÓÐÊÜËðµÄMyISAMÊý¾Ý±í¡£Õâ¸öÑ¡ÏîµÄ¿ÉÈ¡ÖµÓÐ4ÖÖ:DEFAULT¡¢BACKUP¡¢QUICKºÍFORCE; ËüÃÇÓëmyisamchk³ÌÐòµÄͬÃûÑ¡Ïî×÷ÓÃÏàͬ¡£
old-passwords ʹÓÃMySQL 3.23ºÍ4.0°æ±¾ÖеÄÀÏËã·¨À´¼ÓÃÜmysqlÊý¾Ý¿âÀïµÄÃÜÂë(ĬÈÏʹÓÃMySQL 4.1°æ±¾¿ªÊ¼ÒýÈëµÄмÓÃÜËã·¨)¡£
port = n ΪMySQL³ÌÐòÖ¸¶¨Ò»¸öTCP/IPͨÐŶ˿Ú(ͨ³£ÊÇ3306¶Ë¿Ú)¡£
safe-user-create Ö»ÓÐÔÚmysql.userÊý¾Ý¿â±íÉÏÓµÓÐINSERTȨÏÞµÄÓû§²ÅÄÜʹÓÃGRANTÃüÁî; ÕâÊÇÒ»ÖÖË«±£ÏÕ»úÖÆ(´ËÓû§»¹±ØÐë¾ß±¸GRANTȨÏÞ²ÅÄÜÖ´ÐÐGRANTÃüÁî
Ïà¹ØÎĵµ£º
MySQL ±¸·ÝºÍ»Ö¸´
ÖÜÁù, 2006/09/30 - 14:21 — yejr
MySQL ±¸·ÝºÍ»Ö¸´
×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email:
£©£¬À´Ô´£ºhttp://imysql.cn
£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
ÈÕÆÚ£º2006/10/01
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖ ......
²»¹ÜÊÇmaster»¹ÊÇslave£¬¶¼ÒªÉ趨 server-id Ñ¡ÏîÀ´È·¶¨Ê¹ËüÃǶ¼Óи÷×ÔΨһµÄͬ²½ID¡£±ØÐëÑ¡Ôñ 1 µ½ 2^32-1 Ö®¼äµÄÕýÕûÊý¡£ÀýÈ磺 server-id=3¡£
¹ØÓÚmaster·þÎñÆ÷ÉÏ¿ÉÓÃÓÚ¿ØÖƶþ½øÖÆÈÕÖ¾¼Ç¼µÄÑ¡ÏîÏêϸÃèÊöÇë¿´"5.9.4 The Binary Log"¡£
ϱíÃèÊöÁËslaveͬ²½¿ÉÓõÄÑ¡Ï¿ÉÒÔÔÚÃüÁîÐлòÕßÅäÖÃÎļþÖÐÉ趨ËüÃÇ¡£
һЩslav ......
Õ⼸Ì죬ÏîÄ¿ÖÐÓиöÐèÇ󣬵½Êý¾Ý¿âÕâ²½µÄ½á¹û¾ÍÊÇÐèÒªÅúÁ¿updateµÄÊý¾Ý£¬×ܲ»ÄÜÑ»·Ê¹ÓÃupdate....set...°É£¬ÕâÑùÏÔʾЧÂÊÊǺܵͣ¬ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬´ó¼ÒÒ²ÊÇÏëÁ˺ܶàµÄ°ì·¨¡£
ÏÈ˵Õ⼸¸ö½â¾ö·½°¸£º
1£ºÑ»·update²Ù×÷£ºÊ²Ã´¶¼²»ËµÁË£¬ÏÔÈ»ÌÔÌÁË£»
2£º ......
ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......