MySQL Forums
Forum List  »  Replication

MySQL replication-Table doesn not exist
Posted by: Prashanth Santhanam
Date: November 03, 2014 08:12AM

Hello guys,

Coming from an Oracle background,am a Newbie to mysql replication.One of our slave server jus died and I had to rebuild it from the master(Prod).Rsync'd the data directory to the slave and started the mysql server.Figured out the master log file name and the log position using 'show master status' command and started replication from the slave using 'change master to..;.Below is the output from the 'show slave status' command.But when i try to describe a table it comes up with an error saying table does not exist.Can someone tell me what is happeing here.?
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: *******
Master_User: ***
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.007236
Read_Master_Log_Pos: 875398029
Relay_Log_File: slave-db2-relay-bin.000457
Relay_Log_Pos: 25177559
Relay_Master_Log_File: mysql-bin.007236
Slave_IO_Running: Yes
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: 50442935
Exec_Master_Log_Pos: 875398029
Relay_Log_Space: 130037319
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)

Thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL replication-Table doesn not exist
1861
November 03, 2014 08:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.