List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:February 22 2006 2:00pm
Subject:Re: binary log missing in 5.1.6?
View as plain text  
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
Thread
binary log missing in 5.1.6?Ben Clewett22 Feb
  • Re: binary log missing in 5.1.6?Ben Clewett22 Feb