Support

I'm trying to kickstart a webpage to a new server. Although restoration runs smoothly on my localhost and another hosting provider, on futurehost.pl it ends on an error when restoring database:

ErrNo #0

SQL=REPLACE INTO `int13_overrider` (...)

I wrote to the hosting provider support and they said that Akeeba made a huge single query of over 200,000 characters, which they cannot process due to the server security restrictions. They have tried and manually split the query into two, which helped.

My question is, how to configure Akeeba Backup to create smaller queries in the first place? They said also something about PDO driver, which could help, but I don't know what that even means.

I don't know what the PDO driver is either, but I think we can do this without having to learn a new acronym.

In your Akeeba Configuration screen, click on Configure on the Database Backup Engine line. Now reduce the Max packet size for extended INSERTs setting. That should do the trick, but I can't tell you what the new setting should be. You would have to check with your host for that information.

I changed this value to 124Kb and it worked like a charm. Thank you vary much good man.

You are welcome!