Can someone please tell me what the problem is below. All I am trying to
do is pipe a backup created with mysqldump into mysql and it gives me
this error:
ERROR 1071 at line 1291: Specified key was too long. Max key length is
500
Here is the query where the error is:
CREATE TABLE list (
list_id mediumint(8) unsigned NOT NULL auto_increment,
name varchar(255) DEFAULT '' NOT NULL,
description varchar(255),
email varchar(100) DEFAULT '' NOT NULL,
message_count mediumint(8) unsigned DEFAULT '0' NOT NULL,
category_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
type tinyint(3) unsigned DEFAULT '0' NOT NULL,
day_count smallint(5) unsigned DEFAULT '0' NOT NULL,
num_days mediumint(8) unsigned DEFAULT '0' NOT NULL,
day_ave smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (list_id),
KEY type (type),
KEY category_id (category_id),
KEY name (name,description)
)
Thanks you in advance.
- Dan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
