List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:April 23 2000 1:30am
Subject:Create tables not neccesarily written to update log
View as plain text  
Hi!

Sorry for the delay; Because of a bug in my procmail filter, I didn't
notice the following mail until now :(

>>>>> "Settlemyer," == Settlemyer, Brad <bsettlemyer@stripped>
> writes:

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

I have now fixed this for 3.23.15

Regards,
Monty
Thread
Create tables not neccesarily written to update logBrad Settlemyer22 Mar
  • Create tables not neccesarily written to update logMichael Widenius23 Apr