MySQL on FC15 gives me error when importing table

[gogi88]

Hi,

I have a problem with one particular table which works fine on FC14.

On a box with FC14:

Linux lassbox-11 2.6.35.10-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 2.6.38.8-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!

Gogi

[mschwendt]

Are you sure the attached files are valid? The 3rd and 4th columns already are not wide enough to hold the values found in the include file:

create table traces(TC int,timestamp char(20),p_rto char(16),v_rto char(5), …

1 1313756918.664242000 tcp.analysis.rto_frame ip.dsfield …

And with the column names being 'p+v' pairs apparently, it seems to me one 'v' column is missing in the include file between p_rto and v_rto, too.

[markkuk]

The default storage engine has changed from MyISAM to InnoDB, and the default row size limits have changed accordingly. Add "ENGINE = MYISAM" to your CREATE TABLE statement to use the same engine as before.

[gogi88]

Thank you markkuk! It works perfectly as earlier

Mschwendt, the "v" column was actually empty and there were 2 TAB's in a row after the "p" column (p_rto) instead of TAB value TAB.

Gogi