Enabling MySQL Log-Bin for replication?

mteigers

Member
Jul 10, 2011
7
0
51
I'm trying enable log-bin on our server so we can get one of the larger databases replicated. I've found topics here: http://forums.cpanel.net/f189/mysql-bin-logging-162817.html and here: http://forums.cpanel.net/f189/mysql-logs-160110.html#post671013 on how to set up the server for replication and I've followed the steps by adding:

Code:
log-bin = /var/lib/mysql/binlog
expire_log_days = 2
to /etc/my.cnf.

However after I add that and do a /etc/init.d/mysql restart I get the following output:

Code:
Shutting down MySQL...... SUCCESS!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
then if I try just a normal /etc/init.d/mysql start after I've already shut it down. I get this error:

Code:
ERROR! MySQL manager or server PID file could not be found!
does anybody have any idea why that's happening or especially how to fix it?

Thanks in advance.