The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql servername-bin files

Discussion in 'General Discussion' started by hostseeker, Feb 7, 2006.

  1. hostseeker

    hostseeker Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    85
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    My server: Redhat enterprise linux P4 with Cpanel

    In my var/lib/mysql directory there are over 1,500 files with the format:

    myservername-bin.1234 where 1234 is the numbers starting at 001 and going up to over 1500

    The dates of the files are from 2 years ago up through today.

    Does anyone know what these files are and how they get there? I am thinking they may be tmp files, but I want to know for sure before I do anything with them.

    Thanks!
     
  2. hostseeker

    hostseeker Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    85
    Likes Received:
    0
    Trophy Points:
    6
    Anyone? I sure would like to recover this disk space if those files can be deleted.
     
  3. visiox

    visiox Well-Known Member

    Joined:
    Jan 19, 2004
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Hi there,

    as i know...

    1) stop service mysql
    2) delete the files
    3) start service mysql

    regards
     
  4. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India

    Hello,

    Did you set replication on your server ?. This files are used for mysql replication. Check your my.cnf file and remove the lines like
    --------------------------------------
    log-bin=mysql-bin
    server-id=1
    -------------------------------------

    Then restart mysql. It will help you ;)
     
Loading...

Share This Page