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.

Backing up MySQL databases on regular schedule

Discussion in 'General Discussion' started by GoWilkes, Nov 12, 2010.

  1. GoWilkes

    GoWilkes Well-Known Member

    Joined:
    Sep 26, 2006
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    My semi-managed server is running RedHat Enterprise 4 i686. It has a large, virtually unused partition on the hard drive (230GB) named /backup.

    Is there an easy way to have cPanel or WHM copy all of my MySQL databases to /backup each night?
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    In WHM > Backup > Configure Backup area, you can select to enable "Backup SQL Databases (at least "Per Account" is needed to use the restore feature)" option to backup the databases and select /backup as the location for those to save.
     
  3. GoWilkes

    GoWilkes Well-Known Member

    Joined:
    Sep 26, 2006
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I tried that, and I see a new folder called /cpbackup/ now, with /daily/, /weekly/, and /monthly/ subfolders.

    I get an email report saying that the backup was successful, but when I look at these folders, all I see is cpbackupstatus.cfg, about 25 bytes in size.

    The database it's supposed to be backing up is around 150MB. Where exactly are these files located after the backup?
     
Loading...

Share This Page