Support

Akeeba Backup for Joomla!

#22641 Akeeba Kickstart

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 tampe125 on Tuesday, 19 May 2015 01:49 CDT

user31500
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:

I keep getting problems restoring to a new hosting domain

this is the error

Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 141
Database server error reply:

ErrNo #0
Raw query text:

tampe125
Akeeba Staff
Hello Abdul,

as far as you know, does your host apply any query limit in a specific amount of time?
Restoring the database requires a lot of queries in short period of time, sometimes hosts could block them.

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!

user31500
Hi Davide

so what should i ask my host to do?

tampe125
Akeeba Staff
Please ask your host if they are applying any limit to the number of queries you can do in any amount of time.

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!

user31500
HI Davide i don't think this is the case

i tried to connect it to a new database on my old hosting company and i still get the same error.

Basically i made a backup of the website on a local machine and now i am trying to restore the backup to the new host.

could this be causing an issue?

tampe125
Akeeba Staff
There could be two possible causes for such error:
  1. Too many queries in a limited amount of time.
  2. The data contained in your database is "too long". While creating the backup, we write an INSERT query for each record in the database, which length depends by the data stored in that record. If the record has an huge amount of data, bigger than the amount the database could handle, you'll get that error.
    You can ask your host to increase the max_allowed_packet option inside MySQL.
    This is an hard limit of MySQL configuration, you'll receive the same error even if you'll try to restore your database in "the old way" directly from PhpMyAdmin

We can workaround the first error, while for the second there's no solution, you have to ask your host but I doubt they can change MySQL configuration settings.

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!

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!