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

ͬ²½Æô¶¯Ñ¡Ïî(mysql ͬ²½)

²»¹ÜÊÇmaster»¹ÊÇslave£¬¶¼ÒªÉ趨 server-id Ñ¡ÏîÀ´È·¶¨Ê¹ËüÃǶ¼Óи÷×ÔΨһµÄͬ²½ID¡£±ØÐëÑ¡Ôñ 1 µ½ 2^32-1 Ö®¼äµÄÕýÕûÊý¡£ÀýÈ磺 server-id=3¡£
¹ØÓÚmaster·þÎñÆ÷ÉÏ¿ÉÓÃÓÚ¿ØÖƶþ½øÖÆÈÕÖ¾¼Ç¼µÄÑ¡ÏîÏêϸÃèÊöÇë¿´"5.9.4 The Binary Log"¡£
ϱíÃèÊöÁËslaveͬ²½¿ÉÓõÄÑ¡Ï¿ÉÒÔÔÚÃüÁîÐлòÕßÅäÖÃÎļþÖÐÉ趨ËüÃÇ¡£
һЩslaveͬ²½Ñ¡ÏîÒÔÌØ¶¨µÄ·½Ê½À´´¦Àí£¬ÔÚslaveÆô¶¯Ê±£¬Èç¹û´æÔÚ `master.info` Îļþ²¢ÇÒ°üº¬ÕâЩѡÏÄÇôslave½«ÂÔ¹ýËüÃÇ¡£ÕâЩѡÏîÈçÏ£º
--master-host
--master-user
--master-password
--master-port
--master-connect-retry
´ÓMySQL 4.1.1¿ªÊ¼£¬Ò»ÏÂÑ¡ÏîÒ²°´ÕÕÉÏÊö·½Ê½ÌØÊâ´¦Àí£º
--master-ssl
--master-ssl-ca
--master-ssl-capath
--master-ssl-cert
--master-ssl-cipher
--master-ssl-key
ÔÚMySQL 4.1.1ÖУ¬ `master.info` ÎļþµÄ¸ñʽ¸Ä±äÁËÒÔ°üº¬ÏàÓ¦µÄSSLÑ¡Ïî¡£ÁíÍ⣬MySQL 4.1.1Îļþ¸ñʽ»¹°üÀ¨ÁËÔÚµÚÒ»ÐÐÖеÄÎļþ×ÜÐÐÊý¡£Èç¹û´Ó¾É°æ±¾Éý¼¶µ½4.1.1£¬ÄÇô·þÎñÆ÷Æô¶¯Ê±»á×Ô¶¯Éý¼¶ `master.info` Ϊеĸñʽ¡£²»¹ý£¬Èç¹ûÊÇ´Ó4.1.1½µ¼¶µ½¾É°æ±¾£¬¾ÍÐèÒªÔÚϵͳµÚÒ»´ÎÆô¶¯Ê±ÊÖ¹¤É¾³ýÎļþµÄµÚÒ»ÐС£×¢Ò⣬ÕâÖÖÇé¿öÏ£¬±»½µ¼¶µÄ·þÎñÆ÷¾Í²»ÄÜÔÙʹÓÃSSLÑ¡ÏîÁ¬½Óµ½masterÁË¡£
slaveÆô¶¯Ê±Èç¹û²»´æÔÚ `master.info` Îļþ£¬Ëü¾ÍʹÓÃÔÚÃüÁîÐлòÕßÅäÖÃÎļþÖÐÖ¸¶¨µÄ²ÎÊýÖµÀ´Æô¶¯¡£ÕâÔÚÿ´ÎµÚÒ»´ÎÆô¶¯slave·þÎñÆ÷ʱ¶¼ÊÇÕâÑù£¬»òÕßÖ´ÐÐ RESET SLAVE Óï¾ä¹Ø±ÕÇÒÖØÆôslaveÖ®ºó¡£
slaveÆô¶¯Ê±Èç¹û´æÔÚ `master.info` Îļþ£¬ÄÇôËü¾ÍÂÔ¹ýÕâЩѡÏ¶øÊÇÖ±½Ó¶ÁÈ¡ `master.info` ÎļþÖеÄÖµ¡£
Èç¹ûÖØÆôsalveʱʹÓõÄÑ¡ÏîÖµºÍ `master.info` ÖеIJ»Ò»Ñù£¬ÄÇôÕâ¸öеÄÖµ²»»áÉúЧ£¬ÒòΪslave·þÎñÆ÷»¹ÊÇÕÕÑùÖ»¶ÁÈ¡ `master.info` Îļþ¡£ÏëҪʹÓò»Í¬µÄÑ¡ÏîÖµ£¬¿ÉÒÔÔÚɾ³ý `master.info` ºóÖØÆôslave»òÕßʹÓà CHANGE MASTER TO Óï¾ä(ÍÆ¼ö)ÖØÖÃÑ¡ÏîÖµ¡£
¼Ù¶¨ÔÚ `my.cnf` É趨ÁËÒÔÏÂÑ¡ÏîÖµ£º
[mysqld]
master-host=some_host
µÚÒ»´ÎÆô¶¯slaveµÄʱºò£¬Ëü´Ó `my.cnf` ÖжÁȡѡÏîÖµ£¬È»ºóÔÙ°ÑËüÃDZ£´æÔÚ `master.info` ÖС£Ï´ÎÖØÆôslaveʱ£¬Ëü¾ÍÖ»¶ÁÈ¡ `master.info` µÄÄÚÈݶøÂÔ¹ý `my.cnf` ÖеÄÑ¡ÏîÖµÁË¡£ÆóͼÐÞ¸Ä `my.cnf` À´¸Ä±äͬ²½Ñ¡ÏîÊDz»¿ÉÐе쬲»¹ý¿ÉÒÔͨ¹ýÖ´ÐÐ CHANGE MASTER TO Óï¾äÀ´ÊµÏÖ£º
ÓÉÓÚ·þÎñÆ÷ÈÏΪ `master.info` µÄÓÅÏȼ¶±ÈÅäÖÃÎļþ¸ß£¬Òò´Ë½¨Òé¸ù±¾²»ÒªÔÚÆô¶¯Ê±¸½¼Óͬ²½Ñ¡Ï¶øÖ»Óà CHANGE MASTER TO Óï¾ä¡£Ïê


Ïà¹ØÎĵµ£º

railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ

1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\  Thu Jul 30 22:16:15 +0800 2009
  Status: 500 Internal Server Error
  unknown error
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......

mysql µ¼³öÊý¾Ý¿â

     ½øÈëcmd
     ===================
     1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
     mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......

MySql ÅжϺº×Ö¡¢ÈÕÆÚ¡¢Êý×ֵĺ¯Êý

¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION  fc_is_hanzi(
p_str VARCHAR(1024)
)
    ......

MySQLÊý¾Ý¿â³£Ê¹ÓõÄһЩÃüÁî

Ò»¡¢Êý¾Ý¿âÁ¬½Ó
ÃüÁmysql -uÓû§Ãû -pÃÜÂë
¡¡¡¡¡¡mysql -h·þÎñÆ÷ -uÓû§Ãû -pÃÜÂë
¡¡¡¡¡¡mysql -h·þÎñÆ÷ -P¶Ë¿Ú -uÓû§Ãû -pÃÜÂë -DÊý¾Ý¿âÃû
˵Ã÷£ºÁ¬½Óµ½MySQLÊý¾Ý¿â·þÎñÆ÷£¬Èç¹ûÖ¸¶¨ÁË“-DÊý¾Ý¿â”²ÎÊý£¬»á½«Ö¸¶¨µÄÊý¾Ý¿âÉèΪ»î¶¯Êý¾Ý¿â¡£
Àý×Ó£ºmysql -hlocalhost -P3306 -uroot -p123456 -Dtest ......

ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨

ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
    ÎªÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
    ¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ