Enable binary logging MySQL

Question

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

Jarod Elliott · Answer 1 · 2010-04-15 11:25:51Z

up vote 1 down vote

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

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

answered Apr 15 '10 at 11:25

	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
	It sounds like you have other issues with the setup. It might be best to ask more about this on serverfault.com – Jarod Elliott Apr 15 '10 at 21:21

feedback

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