Backing up MySQL databases on regular schedule

GoWilkes

Well-Known Member
Sep 26, 2006
613
25
168
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?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
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.
 

GoWilkes

Well-Known Member
Sep 26, 2006
613
25
168
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?