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!

Two WHM Backup log files taking up 160G

Discussion in 'General Discussion' started by tntramsey, Sep 27, 2013.

  1. tntramsey

    tntramsey Registered

    Joined:
    Sep 27, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I have been running backups of a dedicated server for a while now and I have extrememly large .log files. I am surprised at how large they accumulate to and wondering if it is ok to just delete them.

    ./backup/cpbackup/daily/dirs/_var_lib_mysql_/servername.log: 90G
    ./backup/cpbackup/weekly/dirs/_var_lib_mysql_/servername.log: 90G


    Anyone have any advice?

    Thanks,
    Tim
     
    #1 tntramsey, Sep 27, 2013
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Those are backups of your MySQL error log. You are welcome to remove that file if you do not require a backup for it.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Sep 27, 2013
  3. tntramsey

    tntramsey Registered

    Joined:
    Sep 27, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you for your reply. Will the backups automatically create a new file if I delete it?
     
    #3 tntramsey, Sep 27, 2013
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you referring to the MySQL error log itself, or the backed up version of the file?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Sep 27, 2013
  5. tntramsey

    tntramsey Registered

    Joined:
    Sep 27, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    For informational purposes - both, but I assume that the error log itself will automatically populate.

    If I remove the backup, will it cease to backup mysql error log? What do most people/companies do about this, because as we can see I have 180G of space taken up with two backup files.

    I really appreciate your input!
     
    #5 tntramsey, Sep 27, 2013
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Check your /etc/my.cnf file to see if you are logging slow queries. That could be what's making your MySQL error log use so much space. Beyond that, you could add your MySQL error log to your logrotate configuration if you have logrotate installed. This would prevent it from ever reaching a large size, and negate the need to delete it or exclude it from your backups. Also, you can configure MySQL to store the log in another directory outside of /var/lib/mysql so that it's not included when the entire MySQL directory is backed up.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Sep 27, 2013
  7. tntramsey

    tntramsey Registered

    Joined:
    Sep 27, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    So is "error_log" the box that I should check to rotate the mysql log file? So from reading, it looks like it will compress it and store it in "/usr/local/cpanel/logs/archive/" after it reaches the threshold, and I would be responsible for going in and deleting from there?

    Any input would be appreciated.

    Thanks!
     
    #7 tntramsey, Sep 27, 2013
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    No, the log rotation files you see in Web Host Manager are not associated with MySQL. You would need to configure LogRotate manually to ensure your MySQL error log is rotated.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Oct 2, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - Backup files taking
  1. webnix

    counter files not included in backup

    webnix, Dec 6, 2018 at 8:51 AM, in forum: Data Protection
    Replies:
    1
    Views:
    50
    cPanelLauren
    Dec 7, 2018 at 9:35 AM
  2. srikanthnavaneetam

    cpbackup_transporter not uploading the files remotely

    srikanthnavaneetam, Jul 24, 2018, in forum: Data Protection
    Replies:
    13
    Views:
    295
    srikanthnavaneetam
    Jul 25, 2018
  3. Ade Adesokan

    SOLVED Restoration of deleted files and backup

    Ade Adesokan, Jun 26, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    346
    Ade Adesokan
    Jun 27, 2018
  4. srjonet

    Where are backup files placed after transfer?

    srjonet, Jun 5, 2018, in forum: Data Protection
    Replies:
    7
    Views:
    277
    cPanelMichael
    Jun 13, 2018
  5. Elizabeta

    SOLVED Backups via FTP on destination server are compressed files

    Elizabeta, Jun 5, 2018, in forum: Data Protection
    Replies:
    4
    Views:
    225
    Elizabeta
    Jun 7, 2018

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.
    Accept Learn More...
    Dismiss Notice