|
|
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;# x" [7 u( ]; y2 M! M
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log& V. F8 r! n" {# y
" T# }- c! R; k5 G7 }, P; g; V4 w* p
很好的解决办法(如下)：; ?- n2 g, j. I7 O* q- d
mysql> slave stop;
3 w* O7 {# G3 q7 Y5 C/ l; [Query OK, 0 rows affected, 1 warning (0.00 sec)7 v$ y" N7 X3 K5 V
, |6 R" n# h! a7 ^5 ~' Y0 V9 ~mysql> reset slave;( P+ s/ y7 q& Y1 m' f$ Y( ]
8 ^/ l. U0 I5 U' `% v
Query OK, 0 rows affected,(0.00 sec)% C3 w# Z: W; }. p1 c: ] r, b
: K! S& I9 J: L% @+ z0 z
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;
* O3 c; }; o. L# E( A1 {2 hQuery OK, 0 rows affected (0.05 sec)2 r: h& P$ G0 z, F! Z: L
mysql> slave start;
* K0 r3 `3 P, Z F( ]Query OK, 0 rows affected (0.00 sec)/ w+ N: I$ ~2 U2 ]
' ] f- v+ H4 i4 S5 C2 M9 x
|
|
发表于 2018-7-5 15:09:31