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 backup question

Discussion in 'Data Protection' started by Lor, Jun 12, 2014.

  1. Lor

    Lor Well-Known Member

    Joined:
    Apr 29, 2005
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    First, I'm sorry, I tried to find clear answer using CPanel manual, but ... :(

    I want turn off backup(new and legacy) for one account.

    Is it possible do not backup files and mysql basas for selected account?

    If I select "Backup SQL Databases per account only" it's mean backup will not created for selected account if backup turned off for the account?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can enable or disable backups for a particular account via:

    "WHM Home » Backup » Backup User Selection"

    Database backups are enabled globally in "WHM Home » Backup » Backup Configuration". It's not possible to exclude database backups on particular accounts. Are you attempting to exclude a particular database from a backup, or is this a global option you are looking to implement on several accounts?

    Thank you.
     
  3. Lor

    Lor Well-Known Member

    Joined:
    Apr 29, 2005
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Yes, I want to exclude from backup huge database for particular account. I have turned off backup for the account, but yes, i worry about the huge database created on the account.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You may want to disable backups for the account in WHM and instead backup the account manually with the skipacctdb flag. EX:

    Code:
    /usr/local/cpanel/scripts/pkgacct --skipacctdb $username
    You could then backup other databases associated with the account through the use of the "mysqldump" utility. You could setup a cron job if you prefer it to occur on a regular basis.

    Thank you.
     
Loading...

Share This Page