binary log not recording 4.0.9

How-To-Repeat:

I am using replication with 4.0.9.

Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when presented by an application.

But will if I setup a test table in the DB mysql
and use the mysql monitor to populate the DB.

sam


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13648@lists.mysql.com
To unsubscribe, e-mail

Re: binary log not recording 4.0.9

Sam,

On Friday 31 January 2003 20:48, sam wrote:
> How-To-Repeat:
>
> I am using replication with 4.0.9.
>
> Changes to the datbase are not being recorded in
> the bin file on the master for a DB called Medic
> when presented by an application.

Do you use any of these options
binlog-do-db, binlog-ignore-db on your master ?

You can know this by doing SHOW MASTER STATUS on your master.

By the way, the How-To-Repeat section is supposed to give me enough info to
repeat your bug...
For example, how your apps connects to Medic (PHP, ODBC, JDBC, other ???),
the commands your apps issues to connect to the server, to the database if
any, to send the query, and the query itself.
I also need to know the MySQL version you use, on which OS.
If you are using some Unix, you can take a look at a script called mysqlbug
in the MySQL distribution. If you are using Windows, you can take a look at a
file called mysqlbug.txt in the MySQL distribution. These are guidelines for
making a complete bug report that saves everybody's time.

How do you see that the changes are not recorded on the binlog file : do you
use mysqlbinlog, SHOW BINLOG EVENTS, ... ?

Regards,
Guilhem

--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mgbi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Guilhem Bichot
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Software Developer
/_/ /_/\_, /___/\___\_\___/ Bordeaux, France
<___/ www.mysql.com +33 5 56 88 34 39

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13652@lists.mysql.com
To unsubscribe, e-mail

Re: binary log not recording 4.0.9

sam writes:
> How-To-Repeat:
>
> I am using replication with 4.0.9.
>
> Changes to the datbase are not being recorded in
> the bin file on the master for a DB called Medic
> when presented by an application.
>
> But will if I setup a test table in the DB mysql
> and use the mysql monitor to populate the DB.
>
> sam

Hi!

This list is dedicated to the fully repeatable bug reports.

Your report should contain all data, tables, setup info on versions
etc, that would enable us to repeat a problem.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13653@lists.mysql.com
To unsubscribe, e-mail