`./lnms migrate` results in SQL query error "Syntax error or access violation: 1118 Row size too large"

Backup your database:
mysqldump -h $host -P $port -u librenms -p$password librenms >backup.sql

It seems this workaround should work from the article.
Worked for @tobzsc

Changing the row format of the table “devices” to DYNAMIC fixed it for me. A successful migration was possible afterwards.

ALTER TABLE devices ROW_FORMAT=DYNAMIC;

Retry update

1 Like

After altering ROW_FORMAT, there was nothing left to migrate according to lnms.