Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    86
    Likes Received:
    0
    Trophy Points:
    306
    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:
    86
    Likes Received:
    0
    Trophy Points:
    306
    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:
    156
    Hi there,

    as i know...

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

    regards
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    166
    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 ;)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice