From: Kevin P. O'Brien
Date: March 11 1999 2:00pm
Subject: Re: AUTO_INCREMENT Limits to 256 records
List-Archive: http://lists.mysql.com/mysql/58
Message-Id: <199903112200.OAA05100@ark.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Here is a clip from my dumpfile:


############################################
DROP TABLE Tickets \g
# MySQL dump 5.10
DROP TABLE Tickets \g
# MySQL dump 5.10
#
# Host: localhost    Database: darkbase01
#--------------------------------------------------------
# Server version        3.22.14b-gamma

#
# Table structure for table 'Tickets'
#
CREATE TABLE Tickets (

  TicketNumber BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
  LoginID varchar(8),
  ContactName varchar(36),
  ContactPhone varchar(28),
  OpenCallDate date,
  OpenCallTime varchar(5),
  CloseCallDate date,
  CloseCallTime varchar(5),
  SystemConfigurationID varchar(10),
  Problem longtext,
  Resolved char(1),
  Resolution longtext,
  Comments longtext,
  TechName varchar(10),
  TimeOfCall varchar(5),
  UNIQUE Cdx1 (TicketNumber)
);

#
# Dumping data for table 'Tickets'
#

INSERT INTO Tickets  VALUES   (TicketNumber, 'LoginID','Contact','Contact PH','11-03-1998','08:00','12-03-1998
','11:00','PC','Problem','y','Resolution','Comments','Joe','10:00')\g

###################################################################



On Thu, 11 Mar 1999 22:47:14 +0100, Matthias Pigulla wrote:

>"Kevin P. O'Brien" wrote:
>> ERROR 1062 at line 291: Duplicate entry '256' for key 1
>                ^^^^^^^^^
>
>You aren't piping a bogus dump file into mysql, are you?
>
>Matthias
>-- 
>   w e b f a c t o r y | matthias pigulla
>      www.webfactory.de  mp@stripped
>

The command I am using for the dump is:

     mysql dbname < Tickets.init

I hope someone sees a gaping error that I have missed in all of this.

Thanks,


Kevin P. O'Brien, MCP, CPST <kevino@stripped>
Systems Administration
Irenyx Data Group, Inc.
(Office) 1.250.334.9641 ext.239
(Fax)     1.250.334.2365
(Pager) 1.888.805.3820
(Toll Free) 1.800.275.4260 ext.239


PGP Public Key Fingerprint: 56C4 2F8C 5731 08C1  684D 05DC 05E5 697F