Akeeba Backup for Joomla!

Monday, 12 October 2020 01:11 CDT

winstonahsam

Please look at the bottom of this page (under Support Policy Summary) for our support policy summary, containing important information regarding our working hours and our support policy. Thank you!

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:

akeeba cannot complete backup from Cron Command Line execute, possiblebecuase we have one very large table that wed like to keep for data. Can you best advise how to configure Akeeba to handle this?

Regards,

Edited by on 2020-11-12 20:45 CST

Monday, 12 October 2020 02:26 CDT

tampe125

Hello,

looking at the backup log, you are trying to backup the table #__quiz_response_details , which has more than 3 millions of rows.
Akeeba is correctly working, but such operation takes time, and after 5 minutes your host kills the backup process.

If you really need to backup such table contents, you should get in touch with your host and ask him to increase the time limit or switch to frontend backups and trigger the backup from an external service, working around your host limits.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 12 October 2020 06:33 CDT

winstonahsam

Hi Davide,

Thank you very much for the advice and understanding as to why this is a challenging issue due to the large table in question. My host has suggested for me to onlly take a site backup and do a mysql dump separately because the database is 1.3GB. Is it possible to do a restore if I got a dump of the mysql database? Can i add the sql somewhere in the backup? or is this not possible to restore in this method?

Thanx,

Tuesday, 13 October 2020 02:39 CDT

tampe125

Given the large size of that table and the time limits imposed by your host, I'd suggest to skip the contents of such table using Database Filters. Then perform the dump using mysqldump. It will simply create an SQL file that you can restore using mysqldump in the same way, after you completed the restoration with ANGIE.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 12 November 2020 20:17 CST

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2020-11-12 20:17 CST

Support