Seperate databse cronjob

[ZoXx]

Hello,

our cronjob made a dataabse backup. 
The cronjob works fine, but databse backup needs round about 45minutes.

11.04.2018 08:44    Cron Job: Backup Complete
11.04.2018 08:44    Cron Job: FTP Backup - Completed Successfully
11.04.2018 08:44    Cron Job: Backup Generation Completed
11.04.2018 08:43    Cron Job: Starting Backup Zip Creation
11.04.2018 08:43    Cron Job: Backup Database Dump Complete
11.04.2018 08:00    Cron Job: Starting Backup Database Dump
11.04.2018 08:00    Cron Job: Starting Backup Generation
11.04.2018 08:00    Cron Job: Completed Daily Automation Tasks
11.04.2018 08:00    Domain Sync Cron: Completed
11.04.2018 08:00    Automated Task: Starting WHMCS Updates
11.04.2018 08:00    Automated Task: Starting Domain Expiry
11.04.2018 08:00    Automated Task: Starting Client Status Update
11.04.2018 08:00    Automated Task: Starting Server Usage Stats
11.04.2018 08:00    Automated Task: Starting Email Marketer Rules
11.04.2018 08:00    Automated Task: Starting Delayed Affiliate Commissions
11.04.2018 08:00    Automated Task: Starting Inactive Tickets
11.04.2018 08:00    Automated Task: Starting Fixed Term Terminations
11.04.2018 08:00    Automated Task: Starting Overdue Terminations
11.04.2018 08:00    Automated Task: Starting Overdue Suspensions
11.04.2018 08:00    Automated Task: Starting Cancellation Requests
11.04.2018 08:00    Automated Task: Starting Domain Renewal Notices
11.04.2018 08:00    Automated Task: Starting Invoice & Overdue Reminders
11.04.2018 08:00    Automated Task: Starting Credit Card Charges
11.04.2018 08:00    Cron Job: Late Invoice Fees added to 0 Invoices
11.04.2018 08:00    Automated Task: Starting Late Fees
11.04.2018 08:00    Automated Task: Starting Invoices
11.04.2018 08:00    Automated Task: Starting Product Pricing Updates
11.04.2018 08:00    Automated Task: Starting Currency Exchange Rates
11.04.2018 08:00    Cron Job: Starting Daily Automation Tasks
11.04.2018 08:00    Domain Sync Cron: Starting
 

Is it normal?
Is it possible to seperate the cronjob databse to another cronjob that will make a backup maybe at 3 o'clock?

[brian!]

4 hours ago, ZoXx said:

Is it normal?

how big is the database?

4 hours ago, ZoXx said:

Is it possible to separate the cronjob databse to another cronjob that will make a backup maybe at 3 o'clock?

https://docs.whmcs.com/Crons#Tasks

so you should be able to use that feature to remove DB backup from the main cron, and then setup an additional later cron that only performs the db backup.

[ZoXx]

42 minutes ago, brian! said:

how big is the database?

round about 200 mb

 

42 minutes ago, brian! said:

https://docs.whmcs.com/Crons#Tasks

so you should be able to use that feature to remove DB backup from the main cron, and then setup an additional later cron that only performs the db backup.

found it. But it is the first time i edit a cron. 
So i have to edit the daily cron and make a new cron with only database backup right?

[brian!]

23 minutes ago, ZoXx said:

round about 200 mb

https://docs.whmcs.com/Backups#Limitations

Quote

As a DB grows, it becomes too big for a PHP script like the WHMCS cron to handle backing up due to the amount of data within it causing various server limits to be exceeded, usually around the 20 MB mark.

Unfortunately being big means that for a PHP script to loop through and save that data into temporary memory in order to generate an FTP or Email backup is not possible - either the memory limits or max execution time limits on the server will be reached and terminate the script.

In this case we recommend switching to the cPanel backup option instead. By off-loading the backup tasks from PHP to the cPanel system processes, it allows much larger backups to be generated without impacting performance of your website.

as your database is currently 10x the usual advisory limit, you may be better off backing up by using cPanel, Jetbackup or a third-party solution from Marketplace.

24 minutes ago, ZoXx said:

So i have to edit the daily cron and make a new cron with only database backup right?

yes - but you might want to look at the above alternatives instead - I suspect you've outgrown the build-in backup methods now!