I have a fantastic site on a temporary server that uses MariaDB and it works great. I can use AkeebaBackup to copy it to another site on the same server without any issue.
But, I cannot copy it to a new server that uses a MySQL8 database.

I get the error:  ErrNo #1118
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.
What can I do to make this work on my new server using MySQL80

I have tried converting mediumtext to blob with most of the rest being text fields. I tried changing the collation and other remedies I have found in other forum topics, but nothing seems to work.
The issue is only with the #__comprofiler table.
If I load the new site without the #__comprofiler table, it loads fine, but of course the site doesn't function.

How can I get this to work?