I tried googling and searching this forum but found no solutions, so I hope it's ok for me to ask here.
Short story: is it possible to disable mysql backups without disabling backups entirely?
Long story: I find the cp-based mysql backups to be relatively unhelpful. First, it backs up into one massive file, which makes it really difficult to get a few rows when you have to deal with a 2gb file. Second, even though the backup is done nightly, there's only one. I was under the impression that there would be one per day (so a total of 7). And finally, my website becomes completely inaccessible when the db is being backed up which I'm sure you can agree is totally unacceptable.
So, all of this to say that I'm now using my own mysql backup script which addresses all of the above issues. However, because I've chosen to use cp's backups for the rest of my site files, it also backs up the db. I don't understand how a panel with as much customization as cp has, overlooked the ability to disable mysql in backups.
I could comment out lines 294-314 (give or take) in /scripts/cpbackup but I understand that cp would either have a conflict with that or the changes would be over-written on the next update.
Is it possible to disable mysql backups without disabling backups entirely?
Thank you for any suggestions