環(huán)境:

兩個(gè)mysql 5.1.16
一個(gè)在win xp主機(jī)(192.168.0.158)上,一個(gè)在虛擬機(jī)的win xp上

1.主服務(wù)器的my.ini配置如下(把my-medium.ini復(fù)制為my.ini):
在[mysqld]里增加

2.進(jìn)入主mysql增加復(fù)制用戶(hù):

3.查看master狀態(tài)下重啟下mysql:

結(jié)果為:
+------------------+----------+----------------+--------------------+
| File????????????????????? ?| Position?? | Binlog_Do_DB | Binlog_Ignore_DB? |
+------------------+----------+----------------+--------------------+
| mysql-bin.000003 |?????????102 | test????????????? ??? ?| mysql???????????????? ??? |
+------------------+----------+----------------+--------------------+
1 row in set (0.02 sec)


4.主服務(wù)器建表:

并加一些數(shù)據(jù):

5.從服務(wù)器的my.ini配置如下(同樣把my-medium.ini復(fù)制為my.ini):

說(shuō)明:默認(rèn)server-id=1要改為2-2^32-1的值,注釋有說(shuō)明
log-bin=mysql-bin要保留

6.啟動(dòng)從服務(wù)器,并查看狀態(tài):

結(jié)果:
*************************** 1. row ***************************
???????????? Slave_IO_State: Waiting for master to send event
??????????????? Master_Host: 192.168.0.38
??????????????? Master_User: backup
??????????????? Master_Port: 3306
????????????? Connect_Retry: 60
??????????? Master_Log_File: mysql-bin.000003
??????? Read_Master_Log_Pos: 533
???????????? Relay_Log_File: CLB_0-relay-bin.000006
????????????? Relay_Log_Pos: 243
????? Relay_Master_Log_File: mysql-bin.000003
?????????? Slave_IO_Running: Yes
????????? Slave_SQL_Running: Yes
??????????? Replicate_Do_DB: test
??????? Replicate_Ignore_DB:
???????? Replicate_Do_Table:
???? Replicate_Ignore_Table:
??? Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
???????????????? Last_Errno: 0
???????????????? Last_Error:
?????????????? Skip_Counter: 0
??????? Exec_Master_Log_Pos: 533
??????????? Relay_Log_Space: 1087
??????????? Until_Condition: None
???????????? Until_Log_File:
????????????? Until_Log_Pos: 0
???????? Master_SSL_Allowed: No
???????? Master_SSL_CA_File:
???????? Master_SSL_CA_Path:
??????????? Master_SSL_Cert:
????????? Master_SSL_Cipher:
???????????? Master_SSL_Key:
????? Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified


Slave_IO_Running: Yes
Slave_SQL_Running: Yes
說(shuō)明成功:

再看是否已經(jīng)復(fù)制test.repliction表
mysql> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t_repliction?? |
+----------------+
1 row in set (0.00 sec)

再看是否有數(shù)據(jù)
mysql> select * from t_repliction;
+----+--------+
| id | name?? |
+----+--------+
|? 1 | chenlb |
|? 2 | Tenny? |
+----+--------+
2 rows in set (0.01 sec)

:) 有喔

現(xiàn)在在主服務(wù)器里加了一條記錄看看有什么結(jié)果:

再在從服務(wù)器看看結(jié)果:
mysql> select * from t_repliction;
+----+--------+
| id | name?? |
+----+--------+
|? 1 | chenlb |
|? 2 | Tenny? |
|? 3 | ok???? |
+----+--------+
3 rows in set (0.00 sec)

恭喜您成功了 :)


參考: http://zhhaju.blog.hexun.com/2524561_d.html