Option to disable backing up of databases

shovenose shared this idea ago

Open Discussion

I have a client with many huge MySQL databases that cPanel doesn't handle well. We have a custom backup script that works great, but there is no option to continue to use cPanel to take care of backups for files/email/etc like usual without backing up the databases as well. This should be simple to implement and much apprecaited.

Merged Objects

Techs

Can you add an option to exclude a particular database from cPanel auto backup for an account.

Hi,

I want to exclude a particular database from the cPanel automatic daily backup. I noticed we can exclude file and folders using /home/user/cpbackup-exclude.conf but I am not seeing any option to exclude database.

So if you could add such feature that would be great.

Nuno

Disable MySQL backup

cPanel MySQL backups are not really helpful and I find them very inconvenient:

1) Everything is backed up into a huge file, not helping me if I need to restore a single row or table;

2) It does not rotate backups every day, it replaces the previous backup file;

3) It locks my site completely for a few minutes ( = downtime!! ) while backing up the database.

I created my own script to back up MySQL databases which addresses all the problems I mentioned, but now I would like to disable MySQL Backup on cPanel entirely, without having to disable the other system files backup!

I would disable it myself on the /scripts/cpbackup, but I am sure my changes would be overwritten in the next cPanel updates.

I am sure this has been requested before and this was already planned, but I don't find it in the Feature Requests site in here. You created a new backup system, but it is simply the same thing as before... why is it so hard to allow us to disable MySQL Backups?

A system administrator should be responsible for their actions, so there is no point for cPanel to discard simple requests like this just because you think it's absurd.

I would like to prevent the 5-minute downtime on my site every day without having to disable the whole backup thing. Thank you.

I like this idea 0

Replies (2)

sparek-3 ●

I'm not sure how customized your custom script is.

If you are calling /scripts/pkgacct directly you can skip mysql by passing the --skipmysql parameter to it:

/scripts/pkgacct --skipmysql <user> <backup directory> <backup type>

Not sure if that helps any.

Reply URL

Nathan Stretch ●

Agreed here; we have a custom database backup because neither of the cPanel options work well to take consistent backups of large, busy databases. It seems like an oversight that the backup configuration gives options for backing up accounts only, whole directory, or both, but not neither.

Reply URL