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×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......