Bug #17388 | Auto Increment setting lost during migration | ||
---|---|---|---|
Submitted: | 14 Feb 2006 16:25 | Modified: | 18 Jun 2006 18:32 |
Reporter: | Craig Williams | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Migration Toolkit | Severity: | S2 (Serious) |
Version: | 1.0.23 rc | OS: | Windows (XP Pro SP2) |
Assigned to: | Michael G. Zinner | CPU Architecture: | Any |
[14 Feb 2006 16:25]
Craig Williams
[20 Feb 2006 13:05]
Valeriy Kravchuk
Thank you for a bug report. MT generated the following SQL script for me while migrating from 4.1.18 to 5.0.18: -- ---------------------------------------------------------------------- -- MySQL Migration Toolkit -- SQL Create Script -- ---------------------------------------------------------------------- SET FOREIGN_KEY_CHECKS = 0; CREATE DATABASE IF NOT EXISTS `test` CHARACTER SET latin1 COLLATE latin1_swedish_ci; -- ------------------------------------- -- Tables DROP TABLE IF EXISTS `test`.`t1`; CREATE TABLE `test`.`t1` ( `c1` INT(11) NOT NULL, `c2` CHAR(20) NULL, PRIMARY KEY (`c1`) ) ENGINE = INNODB; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------------------------------------------------- -- EOF The original table was: C:\Documents and Settings\openxs>mysql -uroot -p -P3306 test Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 4.1.18-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show create table t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `c1` int(11) NOT NULL auto_increment, `c2` char(20) default NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec)
[21 Feb 2006 0:45]
Rod Apeldoorn
I've had similar issues with transfers between MySQL v4->v5 and v5 -> v5. Another serious setting not transfered is the UNSIGNED attribute. Less serious is the lack of table comments.
[18 Jun 2006 18:33]
Michael G. Zinner
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html Additional info: Both the auto_increment issue and the UNSIGNED issue have been fixed.