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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.