MySQL Forums
Forum List  »  MyISAM

ERROR 1117 "too many columns" in create stmt
Posted by: Stefan Röschinger
Date: August 17, 2005 06:26AM

I want to restore a sql dump from a server version 4.0.18 to a 4.1.12-standard.
One table contains around 1350 columns, half of them are blobs, text.
The create table statements replies error 1117 "too many columns" ?!

Source database is german_latin_1, dump file was converted with iconv to utf8
and restored to utf8 database;

Max number of columns per table should be 3398 ?!

I've searched for hours now, if it's a configuration issue, a bug
or any restrictions I haven't heard of.

Please do not discuss the table design, no way to change this ;)

Thanks for any help, Stefan.

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1117 "too many columns" in create stmt
6855
August 17, 2005 06:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.