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
• Status: Duplicate
• 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

Description:
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