database backup never works

[snake]

When I update WHMCS I really want to just do the backup from the update page, afterall that is why it is there, for convenience.

But I have never been able to get the backup to work, it always times out, and I have to resort to using phpmyadmin, which is the only solution I ever got from whmcs support too.

My database is not big, it is a tiny install, not a lot of data.

Is there any way to get it working, or if it just that useless?

 

[WHMCS Alex]

Hello @snake,

Thanks for your post!

As detailed within the documentation below, typically once your database grows beyond a certain size (around 20MB) it becomes too big for a PHP script to handle.

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

If your database is close to 20MB in size, or larger, this may be why you are experiencing issues.

If you are by chance using cPanel, I would fully recommend using the cPanel backup option in WHMCS: https://docs.whmcs.com/Backups#cPanel_Backup

The reason I recommend this is you can have backups automated via the WHMCS cron, but using WHM/cPanel's backup wizard: https://documentation.cpanel.net/display/80Docs/Backup+Wizard#BackupWizard-FullBackup

If your database is much less than 20MB in size, I would recommend opening up a ticket with us so we can advise further.

[snake]

And yet it works fine from PHPMyAdmin, which is also a php script.