https://media01.nerdia.net/uploads/nerdia-logo-340x156.png 0 0 Stefan Helander https://media01.nerdia.net/uploads/nerdia-logo-340x156.png Stefan Helander2019-01-18 10:14:182019-01-18 19:42:35Akeeba restore error – 1118 – Row size too large (>8126) [solution]
Akeeba restore error – 1118 – Row size too large (>8126) [solution]
When restoring an Akeeba backup of a WordPress site the restore process was interrupted with the error message saying 1118 – Row size too large (>8126).
- Use SSH to log in to your database server
- Edit /etc/mysql/my.cnf or if you use a config file under /etc/mysql/conf.d, edit that one
- Under the [mysqld] section add:
innodb_strict_mode = 0
- Restart mysql:
service mysql restart
Edit: After you successfully restored the site, remove the lines and restart MySQL. I didn’t do this and later tried to move another site from this server to another using Akeeba. When the site was installed on the new server, I just got an error message saying “Error Establishing a Database Connection”. To resolve it, I had to go back to the above server, remove the lines from mysql config, restart MySQL, make a new backup of the site using Akeeba and successfully restore it on the new server.