Created
November 16, 2012 03:45
-
-
Save RoelVdP/4083846 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> start slave; | |
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO | |
mysql> show slave status \G | |
*************************** 1. row *************************** | |
Slave_IO_State: | |
Master_Host: 127.0.0.1 | |
Master_User: root | |
Master_Port: 11990 | |
Connect_Retry: 1000 | |
Master_Log_File: master-bin.000001 | |
Read_Master_Log_Pos: 119875 | |
Relay_Log_File: slave-relay-bin.000013 | |
Relay_Log_Pos: 254 | |
Relay_Master_Log_File: master-bin.000001 | |
Slave_IO_Running: No | |
Slave_SQL_Running: Yes | |
Replicate_Do_DB: | |
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: 119875 | |
Relay_Log_Space: 3374 | |
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: NULL | |
Master_SSL_Verify_Server_Cert: No | |
Last_IO_Errno: 1236 | |
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' | |
Last_SQL_Errno: 0 | |
Last_SQL_Error: | |
Replicate_Ignore_Server_Ids: | |
Master_Server_Id: 0 | |
1 row in set (0.01 sec) | |
mysql> start slave; | |
Query OK, 0 rows affected (0.11 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment