SQL syntax or access violation error while running joomla xmlImport.php file
Error: SQLSTATE: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BL OB prefix of 768 bytes is stored inline.
Steps to restore an innodb database
Set up a temporary mysql “sandbox” instance using the innodb files and the fil ebased backups of the database and create a mysql dump of the database.
Optimize database using phpMyAdmin
Over a time as your website add contents to it’s database, the files/tables will become fragmented resulting in slower performance. Optimizing the database will essentially defragment the files, and is something you should perform regularily if you do have a busy website.