Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Apr 16 '10 at 1:16

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer
    
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 '10 at 11:31
    
Executing mysqld with the --log-bin option should be enough. Is that not working? –  Jarod Elliott Apr 15 '10 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 '10 at 12:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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