MySQL Forums
Forum List  »  Backup

Re: Error 1062 while restoring backup
Posted by: Subin S
Date: January 20, 2013 11:21PM

Thanks Rick.

Attachments table:

| Attachments | CREATE TABLE `Attachments` (
`id` int(11) NOT NULL auto_increment,
`TransactionId` int(11) NOT NULL,
`Parent` int(11) NOT NULL default '0',
`MessageId` varchar(160) character set ascii default NULL,
`Subject` varchar(255) default NULL,
`Filename` varchar(255) default NULL,
`ContentType` varchar(80) character set ascii default NULL,
`ContentEncoding` varchar(80) character set ascii default NULL,
`Content` longblob,
`Headers` longtext,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Attachments2` (`TransactionId`),
KEY `Attachments3` (`Parent`,`TransactionId`)
) ENGINE=InnoDB AUTO_INCREMENT=871313 DEFAULT CHARSET=utf8 |

Tickets table:

| Tickets | CREATE TABLE `Tickets` (
`id` int(11) NOT NULL auto_increment,
`EffectiveId` int(11) NOT NULL default '0',
`Queue` int(11) NOT NULL default '0',
`Type` varchar(16) character set ascii default NULL,
`IssueStatement` int(11) NOT NULL default '0',
`Resolution` int(11) NOT NULL default '0',
`Owner` int(11) NOT NULL default '0',
`Subject` varchar(200) default '[no subject]',
`InitialPriority` int(11) NOT NULL default '0',
`FinalPriority` int(11) NOT NULL default '0',
`Priority` int(11) NOT NULL default '0',
`TimeEstimated` int(11) NOT NULL default '0',
`TimeWorked` int(11) NOT NULL default '0',
`Status` varchar(10) character set ascii default NULL,
`TimeLeft` int(11) NOT NULL default '0',
`Told` datetime default NULL,
`Starts` datetime default NULL,
`Started` datetime default NULL,
`Due` datetime default NULL,
`Resolved` datetime default NULL,
`LastUpdatedBy` int(11) NOT NULL default '0',
`LastUpdated` datetime default NULL,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
`Disabled` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Tickets1` (`Queue`,`Status`),
KEY `Tickets2` (`Owner`),
KEY `Tickets6` (`EffectiveId`,`Type`)
) ENGINE=InnoDB AUTO_INCREMENT=276429 DEFAULT CHARSET=utf8 |

Transactions table:

| Transactions | CREATE TABLE `Transactions` (
`id` int(11) NOT NULL auto_increment,
`ObjectType` varchar(64) character set ascii NOT NULL,
`ObjectId` int(11) NOT NULL default '0',
`TimeTaken` int(11) NOT NULL default '0',
`Type` varchar(20) character set ascii default NULL,
`Field` varchar(40) character set ascii default NULL,
`OldValue` varchar(255) default NULL,
`NewValue` varchar(255) default NULL,
`ReferenceType` varchar(255) character set ascii default NULL,
`OldReference` int(11) default NULL,
`NewReference` int(11) default NULL,
`Data` varchar(255) default NULL,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Transactions1` (`ObjectType`,`ObjectId`)
) ENGINE=InnoDB AUTO_INCREMENT=2277059 DEFAULT CHARSET=utf8 |



Edited 1 time(s). Last edit at 01/20/2013 11:24PM by Subin S.

Options: ReplyQuote


Subject
Views
Written By
Posted
7955
January 19, 2013 09:39PM
2525
January 20, 2013 10:24PM
Re: Error 1062 while restoring backup
2719
January 20, 2013 11:21PM
2094
January 23, 2013 03:30AM


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.