Binary logging in MySQL

Question

Here is my.ini

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

I'm trying to binary logging of mysql database.

Please suggest me to enable binary logging in MySQL Version 5.5.16

Bill Karwin · Accepted Answer · 2014-04-16 06:15:10Z

2

Yes, that is the configuration variable for enabling binary logging.

Did you restart the MySQL service? The service won't re-read the my.ini until you restart.

You can check that it's writing binary logs with the MySQL statement SHOW BINARY LOGS.

answered Apr 16, 2014 at 6:15

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Database Admin · Accepted Answer · 2014-04-16 07:28:56Z

0

Yes, Bill is right.. You did the right thing but if you did not restart your MySQL service it will not take effect.

answered Apr 16, 2014 at 7:28

Database Admin

932 silver badges10 bronze badges