Bug #30119 Default database not set causing DDL statements not replicating
Submitted: 29 Jul 2007 11:19 Modified: 17 Oct 2008 14:51
Reporter: Christoffer Ahlbin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S4 (Feature request)
Version:1.1.5 OS:Windows
Assigned to: CPU Architecture:Any
Tags: replication create alter

[29 Jul 2007 11:19] Christoffer Ahlbin 
Description:
When DDL statements are exectuted by the MySQL Administrator, a default database does not seem to be set, because the statements are not written to the binary log when having binlog-do=db_name in the masters my.cnf.

How to repeat:
I'f instead of modifying the database via the MySQL Administrator, executing the query through MySQL Query Browser or from the command line, and having a default database selected, the statement is written to the binlog.

Suggested fix:
Having the MySQL Administrator using a  "USE database_name" statement before executing DDL queries.
[17 Sep 2008 14:51] Susanne Ebrecht 
Many thanks for writing a feature request.

Please try newest version of MySQL Administrator (1.2.12) and MySQL Server (5.0.67)
[17 Oct 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".