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:
to /etc/my.cnf.
However after I add that and do a /etc/init.d/mysql restart I get the following output:
then if I try just a normal /etc/init.d/mysql start after I've already shut it down. I get this error:
does anybody have any idea why that's happening or especially how to fix it?
Thanks in advance.
Code:
log-bin = /var/lib/mysql/binlog
expire_log_days = 2
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.
Code:
ERROR! MySQL manager or server PID file could not be found!
Thanks in advance.