List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 25 2002 8:07pm
Subject:Re: What are all the "xxx-bin.nnn" files in .../var?
View as plain text  
These are your binary transaction logs used for replication and
for  restoring to current state from last nights backup tape.


Bill Rausch wrote:

> Hi,
>
> My machine (linux if it matters) is named "naif".  In my 
> /usr/local/mysql/var directory, in addition to what I expect to see, 
> there are a number of files named naif-bin.001, naif-bin.002, ..., 
> naif-bin.009.  Some of these files are quite large, nearly 100 
> megabytes.  What are they?  There is also a small file named 
> naif-bin.index.
>
> Thanks,
>
> Bill
>
> $ sudo ls -l var
> total 191608
> ...
> drwx------    2 mysql    mysql        4096 Apr 19 11:13 mysql
> -rw-rw----    1 mysql    mysql    57755399 Jun  4 16:27 naif-bin.001
> -rw-rw----    1 mysql    mysql    93484844 Jun  5 15:32 naif-bin.002
> -rw-rw----    1 mysql    mysql          73 Jun  5 16:52 naif-bin.003
> -rw-rw----    1 mysql    mysql          73 Jun  5 17:05 naif-bin.004
> -rw-rw----    1 mysql    mysql          86 Jun  5 17:08 naif-bin.005
> -rw-rw----    1 mysql    mysql      827434 Jun  7 15:44 naif-bin.006
> -rw-rw----    1 mysql    mysql        4725 Jun  7 16:11 naif-bin.007
> -rw-rw----    1 mysql    mysql    43766150 Jun 17 13:00 naif-bin.008
> -rw-rw----    1 mysql    mysql       82322 Jun 25 09:02 naif-bin.009
> -rw-rw----    1 mysql    mysql         135 Jun 17 13:04 naif-bin.index
> -rw-r--r--    1 mysql    root         1474 Jun 17 13:04 naif.err
> -rw-rw----    1 mysql    mysql           3 Jun 17 13:04 naif.pid
> drwx------    2 mysql    mysql        4096 Apr 19 11:13 test
>


Thread
What are all the "xxx-bin.nnn" files in .../var?Bill Rausch25 Jun
  • Re: What are all the "xxx-bin.nnn" files in .../var?Gerald Clark25 Jun