[Gllug] OT: mysql innodb files

[Magnus Nilsson]

On Tue, 2005-02-08 at 11:11 +0000, Minty wrote:
> in my mysql/4.1.19/data dir, there are a bunch of files named
> 
>   <servername>-bin.000001
> thru
>   <servername>-bin.000022
> 
> They are mostly all of the order 79 bytes, with the exception of two
> that are > 113Mb.  The DB isn't being used much atm, fresh install,
> etc.
> 
> Just wondering if anyone can point me at what their purpose is, so I
> can figure out if they should be of that size.

They're binary logs, used for replication purposes. If you take a look
in your config file (my.cnf) you'll probably have a line starting with
"bin-log". If you're sure that you're not using any kind of replication
you can safely remove that line, stop and restart the server and remove
the <servername>-bin.* files.

//Magnus

-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug