List:General Discussion« Previous MessageNext Message »
From:Kevin P. O'Brien Date:March 11 1999 2:00pm
Subject:Re: AUTO_INCREMENT Limits to 256 records
View as plain text  
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


Thread
AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsMicheal Mc Evoy11 Mar
  • one query for two identical tablesTao Liang3 Mar
    • RE: one query for two identical tablesNicolas Prade3 Mar
  • group by conditionsTao Liang5 Mar
    • Re: group by conditionssinisa6 Mar
      • accessing db while updating itTao Liang26 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsRobert Hazeltine11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • select count distinctChinaConnect11 Mar
    • Re: select count distinctChris12 Mar
    • Re: select count distinctScott Liu13 Mar
      • Re: select count distinctMichael Widenius15 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsChristian Mack12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp13 Mar
Re: Bad handshake problem with java and MySQL 3.22.32Carlos Proal15 Feb