Bug #39993 set binlog-do-db parameter by command line
Submitted: 13 Oct 2008 6:16 Modified: 30 Oct 2009 8:28
Reporter: le chi nhan Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:4.1, 5.0, 5,1, 6.0 bzr OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[13 Oct 2008 6:16] le chi nhan
I installed mysql server, version 5.1.23. The server is runing, and the data is always insert into it after a few seconds. I want to implement a replication system for this server, but I do not want to stop it because if I do that I will lost alot of data will be insert after a few seconds. I think I can set it by command line. The parameters for the master like server_id, log_bin, binlog-do-db. But it seems that there is no man did this before. I must set these parameters in my.ini or my.cnf and then restart the mysql server on master. But this approach is not my expecting. I think this is a bug in mysql. So anybody can help me?

How to repeat:
set binlog_do_db=test;

Suggested fix:
can we set binlog-do-db, and log_bin by command line, like system variables??? so that we will not have to restart the system.
[13 Oct 2008 7:09] Sveta Smirnova
Thank you for the reasonable feature request.
[13 Oct 2008 7:27] le chi nhan
So this feature does not exist in the current version of mysql?
[30 Oct 2009 7:39] Zhenxing He
See also bug#48079
[30 Oct 2009 8:28] Zhenxing He
This is a dup of bug#18073