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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
