I have a problem with one particular table which works fine on FC14.
On a box with FC14:
Linux lassbox-11 184.108.40.206-74.fc14.i686.PAE #1 SMP Thu Dec 23 16:10:47 UTC 2010 i686 i686 i386 GNU/Linux
mysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i386) using readline 5.1
The attached script test.sql (which imports the file traces.sql.1.1) works fine but on the box with FC15:
Linux lassbox-16 220.127.116.11-35.fc15.i686.PAE #1 SMP Wed Jul 6 14:29:06 UTC 2011 i686 i686 i386 GNU/Linux
mysql Ver 14.14 Distrib 5.5.14, for Linux (i686) using readline 5.1
I get the following line after script tries to import the file:
ERROR 1118 (42000) at line 7: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs
I tried reducing the sizes but somehow failed to find the size which doesn't create the error and am confused by FC14 box which "chews" it without problems.
Could someone help me find probably some MySQL settings which affect this?
Thank you in advance!