Re: "Too many rows" in create stmt

[Ingo Strüwing]

The search feature of our online manual is very bad. But noone cares to improve it. So can you please help me and say where you found the mention of the limit in the manual?

I cannot do much here without knowing the table definition. But you might not want to post it in the public. Even the readers of this forum might not like to see a post of this size. So can you please email the table definition to [e-mail]?

One possible problem might result from the character set support that we introduced in 4.1. The default charset is normally UTF-8. When a table is created without an explicit charset name, the default is taken. In the case of UTF-8, every chacter takes three bytes to store. But the meximum row size did not change from 4.0 to 4.1. It is still 64K (plus blobs). So if you have many char or varchar columns, it could happen that a valid table definition from 4.0 exceeds the row size limit in 4.1. The error message does not express this very clearly, but that's MySQL style. ;) To verify the above you can either change the default charset of your database, or add an explicit "DEFAULT CHARSET = latin1" to your CREATE TABLE statement in the dump.