In answer to my own question:
Why don't the binary logs write?
The '%-bin.index' file left over from previous version (4.1.9) had to be
deleted after the conversion to 5.1.6.
By deleting this file, the binary logs started to recreate.
I hope this is useful to somebody :)
Ben
Ben Clewett
Dear MySQL,
I have just upgraded 4.1.9 to 5.1.6, by compiling source code. I have
lost my binary logs.
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
eg: my-bin.01
my-bin.02
The usual option is present:
[mysqld]
log-bin = /usr/local/mysql/logs/my-bin
**or**
[mysqld]
l