How exactly can I enable binary logging on MySQL server. Conf.file? Server Startup Parameter? If possible give me an example.

1 Answer 1


You can start the server with the --log-bin option.

The MySQL documentation will cover the details if you need more information.

  • I examine the documentation and I try different combinations of --log-bin with mysqld but I am not sure I proceed. So could someone please give an example
    – onurozcelik
    Apr 15, 2010 at 11:31
  • Executing mysqld with the --log-bin option should be enough. Is that not working? Apr 15, 2010 at 11:35
  • Here is what I did. I stop the service with net stop mysql Then on command line I type mysqld --log-bin Then nothing happened. Just cursor goes to new line and waits for something. Then I try to start to service from MySQL Administrator but it gave me error. "Pluging FEDERATED is disabled' and service did not start. As a summary I think it is not working.
    – onurozcelik
    Apr 15, 2010 at 12:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .