MySQL Forums
Forum List  »  Replication

changing replicate do table on master - error on restart
Posted by: Daryl Young
Date: March 29, 2017 10:27AM

Master was running with the following:

server-id=1
log-bin = /opt/bitnami/mysql/data/mysql_bin.log
replicate-wild-do-table=my_database

I thought I could just simply change to:

log-bin = /opt/bitnami/mysql/data/mysql_bin2.log
replicate-wild-do-table=my_database2
And just restart mysql, but instead got an error:

[ERROR] Could not add do table rule 'my_database2'

I tried changing back to the old settings, but that failed to start as well. What did I do wrong and what should I have done? How do I fix this now?

Thanks for any help.

Options: ReplyQuote


Subject
Views
Written By
Posted
changing replicate do table on master - error on restart
785
March 29, 2017 10:27AM


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.