Mysql replication slave – Could not initialize master info structure

При change master на mysql slave  излиза следната грешка съпроводена с решение 🙂 :

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CHANGE MASTER TO MASTER_HOST=’192.193.123.4′, MASTER_USER=’slaveuser’, MASTER_PASSWORD=’pass’, MASTER_LOG_FILE=’mysql-bin.000020′, MASTER_LOG_POS=49869;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_HOST=’192.193.123.4′, MASTER_USER=’slaveuser’, MASTER_PASSWORD=’pass’, MASTER_LOG_FILE=’mysql-bin.000020′, MASTER_LOG_POS=49869;
Query OK, 0 rows affected (0.02 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

Категория:

Logged in as {{omniform_current_user_display_name}}. Edit your profile. Log out? Required fields are marked *

Your email address will not be published. Required fields are marked *

Comments are closed.

You must be logged in to post a comment.