Akeeba Backup for Joomla!

Monday, 18 May 2015 09:57 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:

Monday, 18 May 2015 10:35 CDT

tampe125

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!

Monday, 18 May 2015 10:47 CDT

user31500

Hi Davide

so what should i ask my host to do?

Monday, 18 May 2015 10:51 CDT

tampe125

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!

Monday, 18 May 2015 10:56 CDT

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?

Tuesday, 19 May 2015 01:49 CDT

tampe125

There could be two possible causes for such error:

Too many queries in a limited amount of time.
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