[rt-users] When importing database from mysqldump, cannot creat table Attributes

[Schultz, Eric]

On a machine with the MySQL client/server installed, I ran perror on
your error code:

bl-devel: ~ % perror 121
Error code 121:  Remote I/O error
121 = Duplicate key on write or update
bl-devel: ~ % 

Hope this helps.

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Chris Mason (Lists)
> Sent: Monday, January 30, 2006 4:25 AM
> To: rt-users at lists.bestpractical.com
> Subject: [rt-users] When importing database from 
> mysqldump,cannot creat table Attributes
> 
> mysql> CREATE TABLE `Attributes` (
>     ->   `id` int(11) NOT NULL auto_increment,
>     ->   `Name` varchar(255) default NULL,
>     ->   `Description` varchar(255) default NULL,
>     ->   `Content` text,
>     ->   `ContentType` varchar(16) default NULL,
>     ->   `ObjectType` varchar(64) default NULL,
>     ->   `ObjectId` int(11) default NULL,
>     ->   `Creator` int(11) NOT NULL default '0',
>     ->   `Created` datetime default NULL,
>     ->   `LastUpdatedBy` int(11) NOT NULL default '0',
>     ->   `LastUpdated` datetime default NULL,
>     ->   PRIMARY KEY  (`id`),
>     ->   KEY `Attributes1` (`Name`),
>     ->   KEY `Attributes2` (`ObjectType`,`ObjectId`)
>     -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> ERROR 1005 (HY000): Can't create table './rt3/Attributes.frm' 
> (errno: 121)
> 
> I am not sure what is causing this, any ideas?
> 
> -- 
> Chris Mason