export and import looses auto_incremement or "extra" field values
Posted 26 July 2006 - 09:51 PM
I export correctly with complete inserts and the other things but this never works. Incidentally I have to export to a lower version to avoid sql errors. Is this the problem?
I would prefer to do it command line but not all hosts allow ssh in to their db.
grrrrrr....Would appreciate some understanding on this thanks.
PS there is no link to a forum on mysqlfreaks.com
Posted 27 July 2006 - 05:47 PM
DROP TABLE IF EXISTS `default_classlistingsdb`; CREATE TABLE `default_classlistingsdb` ( `classlistingsdb_id` int(11) NOT NULL auto_increment, `class_id` int(11) NOT NULL default '0', `listingsdb_id` int(11) NOT NULL default '0', PRIMARY KEY (`classlistingsdb_id`), KEY `idx_classlistingsdb_class_id` (`class_id`), KEY `idx_classlistingsdb_listingsdb_id` (`listingsdb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `default_classlistingsdb` -- INSERT INTO `default_classlistingsdb` VALUES (1, 1, 1); INSERT INTO `default_classlistingsdb` VALUES (2, 2, 2);
I can see the auto increment value above, so it looks like it is being ignored.
For some reason it seems to be working now, but im not crazy and it did this a previous encounter a month ago, and i ended up manually putting in the auto_increment.
Posted 27 July 2006 - 08:00 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users