List:Bugs« Previous MessageNext Message »
From:Brad Settlemyer Date:March 22 2000 4:56pm
Subject:Create tables not neccesarily written to update log
View as plain text  

> 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
Thread
Create tables not neccesarily written to update logBrad Settlemyer22 Mar
  • Create tables not neccesarily written to update logMichael Widenius23 Apr