Site Restoration

#35769 ErrNo #1118 Row size too large (8126)

Posted in ‘Site restoration’
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

PHP version
CMS Type
CMS Version
Backup Tool Version
Kickstart version

Latest post by on Sunday, 10 October 2021 20:17 CDT


I have backed up my site and i am trying to restore to the new server, the extraction goes ok but I get this error creating the database tables.


<h2>Database error processing line 109</h2> <p>Database server error reply:</p> <tt>ErrNo #1118</tt> <pre>Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Can you please advise what this is referring to and how I can resolve it?

Akeeba Staff


this usually happens when you have a row with so many data that exceeds the limit inside MySQL configuration. Sadly there's no workaround for that, because it simply doesn't fit.

During database restoration, please remove the check from the option Stop on CREATE error and Stop on other errors. In this way ANGIE will continue restoration, once it completes you can review the query that failed and check if that's something critical or you can continue without.

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!

System Task
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.

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!