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 wrote:
> 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.000001
> my-bin.000002
>
> The usual option is present:
>
> [mysqld]
> log-bin = /usr/local/mysql/logs/my-bin
>
> **or**
>
> [mysqld]
> log-bin = ../logs/my-bin
>
>
> I do have the new tables 'mysql.general_log' and 'mysql.slow_log' which
> contain correct information.
>
>
> Does any member have any advise on what may be going wrong?
>
> Regards,
>
> Ben
>
>
--
Ben Clewett
+44(0)1923 460000
Project Manager
Road Tech Computer Systems Ltd
http://www.roadrunner.uk.com
