Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Oct 24, 2010 4:57 pm 
Offline
Senior Newbie

Joined: Mon Feb 22, 2010 11:38 pm
Posts: 6
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)
Code:
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!


Top
   
 Post subject:
PostPosted: Sun Oct 24, 2010 5:22 pm 
Offline
Senior Newbie

Joined: Mon Feb 22, 2010 11:38 pm
Posts: 6
Hey, after hours of beating my head in over this, I seem to have figured it out mere minutes after posting the thread. the do_db/ignore_db lines are misconfigured (only one database per line?), so I just took them out entirely, and it seems to be working just fine now.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group