Mysql replication - master not writing to binary log

I have a slave set up (and the master/slave seem to talk to each other without a problem), but my current problem seems isolated to the master.

First off, here's what I have in my my.cnf (master)

server-id=1
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_ignore_db=ignore_db1,ignore_db2
binlog_do_db=good_db1,good_db2,etc

Now, if I restart the server using 'sudo /etc/init.d/mysql restart', then 'show master status', I get

File: mysql-bin.000001

Position: 106

However, this never changes regardless of insert/update/delete traffic. I'm using phpMyAdmin to look at things, and the 'Binary Log' tab in PMA shows the same thing: a single line showing what I presume to be the init. of the binary log.

(PS: PMA also appears to show that the master is running fine).

I can get the slave to connect and wait for updates in the bin-log, but since nothing is being updated, nothing gets sent over.

Thanks in advance for any help/suggestions!

1 Reply

Hey, after hours of beating my head in over this, I seem to have figured it out mere minutes after posting the thread. the dodb/ignoredb lines are misconfigured (only one database per line?), so I just took them out entirely, and it seems to be working just fine now.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct