The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Enabling MySQL Log-Bin for replication?

Discussion in 'Workarounds and Optimization' started by mteigers, Apr 14, 2012.

  1. mteigers

    mteigers Member

    Joined:
    Jul 10, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  2. mteigers

    mteigers Member

    Joined:
    Jul 10, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    24 hour bump. Please, anybody?
     
Loading...

Share This Page