From: Brad Settlemyer
Date: March 22 2000 4:56pm
Subject: Create tables not neccesarily written to update log
List-Archive: http://lists.mysql.com/bugs/56
Message-Id: <7DBC96804E87D311A3A300062950CB1619B0BE@thetick.interadnet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"



> Table creations are written to the update log on a lazy basis, this is a
> problem when I stop the database after creating the database, but before I
> have popultaed it with a table.
> 
> Ex:
> 
> Start mysql with update logs;
> echo "create database bradtest;" | mysql
> Stop database;
> Start mysql with update logs;
> echo "use bradtest; create table test ( id char(1) );" | mysql
> Stop database;
> 
> 
> Now examine update logs, the line "create database bradtest" does not
> exist.
> 
> Tested on:
> Linux (RH 6.1) mysql 3.22.32
> Solaris(2.7) mysql 3.22.32
> 
> This isn't a biggie, but it makes replication an even bigger kluge than it
> already is.
> 
> Thanks
> Brad