ERROR 1118 (42000) at line 553: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline
Cannot restore from mysqldump file and errors out with message:
ERROR 1118 (42000) at line 553: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline
This is due to Innodb strict mode. Disable it by adding the following line in mysql configuration file (/etc/my.cnf) and restart the MySQL service.
innodb_strict_mode=OFF
Now you will be able to restore the dump file.
Unable to update “Snap Store”: (null): cannot refresh “snap-store”: snap “snap-store” has running apps (ubuntu-software) on ubuntu 22.04 cPanel backup error : mysqldump: Got error: 1049: “Unknown database when selecting the database”