Support

Akeeba Backup for Joomla!

#33027 takes forever to backup #_banner_tracks table

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Thursday, 11 June 2020 17:17 CDT

Tuesday, 12 May 2020 04:00 CDT

frankazoid
here is a process, it took already about 20 minutes.

#_banner_tracks
1016231 / 1296657

phpmyadmin backs up that table in seconds, why akeeba takes so long?

Tuesday, 12 May 2020 04:32 CDT

tampe125
Hello,

I suspect there's something wrong in the configuration of your profile.
Can you please double check that the settings of the Database engine are as the ones attached?

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!

Tuesday, 12 May 2020 05:58 CDT

frankazoid
pretty much the same. attached

Tuesday, 12 May 2020 06:58 CDT

tampe125
"pretty much" is not "the same" :)
The problem is caused by the number of queries for each batch. Please increase it to 1000 and try again, that will speed up your backup process.

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!

Tuesday, 12 May 2020 09:45 CDT

frankazoid
updated to 1000 and got blocked on the hosting with message

1226:User 'user' has exceeded the 'max_connections_per_hour' resource (current value: 1)


yeah, i'm in a progress of changing hosting, this one creates more issues than it solves. I'm still amazed they have php 5.4 default and you can only set 7.1 as 'newest' in their opinion
Edited by frankazoid on 2020-05-12 09:47 CDT

Tuesday, 12 May 2020 09:59 CDT

tampe125
Oh boy!
Well, you will have to slow down your backup process...
Please use the following timing settings:

Minimum execution time: 5 seconds
Maximum execution time: 3 seconds

Yes, minimum is greater than maximum, that's not a typo. In this way the backup will go slower and you should work 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!

Thursday, 11 June 2020 17:17 CDT

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-06-11 17:17 CDT

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!