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

MYSQLͬ²½ÎÊÌ⣬¿¨ËÀÔÚÕâÀïÁË[93È«·ÖËͳö]

ÎÒµÄÄ¿±êÊÇʵÏÖÁ½Ì¨»òÕß¶ą̀MYSQLÏ໥ͬ²½£¬ÏÖÔÚÓÃÁ½¸öµçÄÔ×ö²âÊÔ£¬Áíһ̨ÊÇÐÂ×°µÄPC£¨windows server 2003£¬³ÉΪAÖ÷»ú£¬IP=192.168.1.150£©£¬Ò»Ì¨ÊDZʼDZ¾£¨XPϵͳ£¬³ÆÎªBÖ÷»ú£¬IP=192.168.1.10£©£¬¾­¹ýÒ»ÌìµÄÕÛÌÚ£¬ÏÖÔÚµÄÇé¿öÓ¦¸ÃºÍËùÓÐ×ÊÁÏÉÏÌṩµÄ×îÖճɹ¦×´Ì¬ÊDz鲻¶¼ÁË£¬µ«ÊÇ£¬»¹ÊDz»Äܳɹ¦Í¬²½£¬ÇëÀÏÊÖÖ¸µãһϣ»

ÏÈ˵ÅäÖãº
AÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º

#ͬ²½²ÎÊýÉèÖÃ

server-id=1
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.10
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all

BÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º

#ͬ²½²ÎÊýÉèÖÃ

server-id=2
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.150
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all

A»ú²éѯµÄ״̬£º
mysql> show master status;

mysql> show slave status;



B»ú²éѯµÄ״̬£º
mysql> show master status;

mysql> show slave status;


´ÓÉϵÄÐÅÏ¢À´¿´£¬»ù±¾Ö»ÓÐÒ»µãµãµØ²îÒ죬²»ÖªµÀÕâÊÇ·ñΪÎÊÌâÔ­ÒòÖ®ËùÔÚ¡£

ÆäËûÐÅÏ¢£º
Á½Ì¨Ö÷»úµÄ·À»ðǽȫ²¿¹Ø±Õ£¬ÓÃtelnet 192.168.1.150 3306,telnet 192.168.1.150


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ