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 Casey Landreth, Feb 10, 2015.

  1. Casey Landreth

    Joined:
    Feb 10, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mesa, Arizona, United States
    cPanel Access Level:
    Root Administrator
    I'm trying to setup a backup plan for my MySQL DB's that will be included in my Godaddy backup plan. I set the Backup in cPanel on all accounts and Legacy is turned off. When I force run the backup with /usr/local/cpanel/bin/backup --force and then go into /backup/THE DATE/accounts/ there is nothing in there. Am I doing this wrong or looking in the wrong area?

    Any help would be great.

    I'm running CENTOS 6.4 x86_64 standard WHM 11.48.0 (build 11)
     
  2. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    In WHM>>>>Backup user selection, check that the account/domain is showing "ON"
     
  3. Casey Landreth

    Joined:
    Feb 10, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mesa, Arizona, United States
    cPanel Access Level:
    Root Administrator
    They are all marked as ON under backup, the legacy is marked as OFF.
     
  4. Casey Landreth

    Joined:
    Feb 10, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mesa, Arizona, United States
    cPanel Access Level:
    Root Administrator
    Found the issue, under Files in the Back Config it wasn't checked so it wouldn't create the MySQL backup. Thanks for your help.
     
  5. Casey Landreth

    Joined:
    Feb 10, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mesa, Arizona, United States
    cPanel Access Level:
    Root Administrator
    Is there a way to back just the MySQL and not all the site files? Or do I have to create a cron job for each of these?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,786
    Likes Received:
    665
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You could disable "Backup Accounts" and select "Entire MySQL Directory" under the databases section of the backup configuration page. Note that this will require some additional actions when restoring a database, as it backups up the entire MySQL data directory.

    Thank you.
     
  7. Casey Landreth

    Joined:
    Feb 10, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mesa, Arizona, United States
    cPanel Access Level:
    Root Administrator
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,786
    Likes Received:
    665
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page