|
|
mysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
7 w" B/ E% s8 a: S ^ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
3 z: @1 P2 {5 b v
j8 p9 M, ~$ l+ Q0 J/ n3 D很好的解决办法(如下):
% S0 K( \9 m) Z: }3 m; b- Y D. Cmysql> slave stop;
8 N. I1 q* ~2 L7 z+ ?$ lQuery OK, 0 rows affected, 1 warning (0.00 sec)
) \' b+ D- \9 v2 h7 V" o
4 Q" I# w% C1 ?0 h& tmysql> reset slave;2 [" `* Y, G$ E6 r x
& T% l3 @2 {) Q0 AQuery OK, 0 rows affected,(0.00 sec)
6 F3 m/ } O0 C0 V; [
1 f1 n& G( {0 x' P# f \$ R% zmysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
4 y- ?! t" S6 o* b1 _Query OK, 0 rows affected (0.05 sec)% y: a% c, ], |
mysql> slave start;
( S. p5 R% @6 ?( y2 Z9 j i2 i+ `7 q2 qQuery OK, 0 rows affected (0.00 sec)
# S. D3 P: z, _2 W7 C* T) c
) X1 ?( _4 ~5 Z6 }) R |
|