Lost Auto-increment After Copy To Other Database/host

[gaartsen]

I have lost the auto-increment attribute on a couple of occasions after “copy to other database/host”

Anyone else had this problem???

[peterlaursen]

please tell: will you be more happy if I answer 'yes' or 'no' to your question? How will it help you to know if other people experienced this.  I do not understand why you ask this question! 🙂

Please always tell the program version (and please always try latest available version if possible) before reporting an issue.  We cannot fix issues in old versions really!

But this issue has been fixed I believe! I think about 9 months ago!

However if you still experience this with a recent version we would like to know how to reproduce it!  In that case please attach a structure-only dump of a table to reproduce with!

[gaartsen]

Hi, and sorry for my brief explanation.

My colleague and I have experienced the very same issue.

He was working on version 5.25, and I was working on version 5.28. I installed version 5.32, and still experience the same problem.

Below is the export ot the table.

/*

SQLyog Community Edition- MySQL GUI v5.32

Host – 5.0.18 : Database – xxxxxx

*********************************************************************

Server version : 5.0.18

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `originchg` */

CREATE TABLE `originchg` (

`id` int(6) NOT NULL auto_increment,

`cust` char(6) NOT NULL default '',

`mode` char(4) NOT NULL default '',

`ccy` char(3) NOT NULL default '',

`description` char(50) NOT NULL default '',

`int_port` int(6) unsigned zerofill NOT NULL default '000000',

`type` enum('FLAT','PCNT','WGHT','CUBM') NOT NULL default 'FLAT',

`rate` decimal(10,2) NOT NULL default '0.00',

`min` decimal(10,2) NOT NULL default '0.00',

`lcl` decimal(10,2) NOT NULL default '0.00',

`fcl20` decimal(10,2) NOT NULL default '0.00',

`fcl40` decimal(10,2) NOT NULL default '0.00',

`fcl40h` decimal(10,2) NOT NULL default '0.00',

`comment` char(50) NOT NULL default '',

`validity` bigint(20) default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Hopefully this will give you a bit more to work with.

[peterlaursen]

We still cannot reproduce.  Can you tell the Server versions involved?

You say 'couple of occasions'. that means that it happens only sometimes? Can you help in identifying the circumstances?

[Author]

Posts