dump and load fails to correctly load magento tables with records of id=0

[SPhu]

core_store table has a record that starts with an id of zero. the export data is correct but on import it assigns the id=0 record to id=74 which is the next increment for a new record.

table definition
CREATE TABLE core_store (
store_id smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store Id',
code varchar(32) DEFAULT NULL COMMENT 'Code',
website_id smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',
group_id smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group Id',
name varchar(255) NOT NULL COMMENT 'Store Name',
sort_order smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Sort Order',
is_active smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Activity',
PRIMARY KEY (store_id),
UNIQUE KEY UNQ_CORE_STORE_CODE (code),
KEY IDX_CORE_STORE_WEBSITE_ID (website_id),
KEY IDX_CORE_STORE_IS_ACTIVE_SORT_ORDER (is_active,sort_order),
KEY IDX_CORE_STORE_GROUP_ID (group_id),
CONSTRAINT FK_CORE_STORE_GROUP_ID_CORE_STORE_GROUP_GROUP_ID FOREIGN KEY (group_id) REFERENCES core_store_group (group_id) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT FK_CORE_STORE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID FOREIGN KEY (website_id) REFERENCES core_website (website_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='Stores';

DATA INSERT
INSERT INTO core_store VALUES (0,'admin',0,0,'Admin',0,1),

[vincentsking]

Thanks!
What version of mysql are you using?
I googled around some and see that older versions did this.
try adding this switch --skip-opt to the mysqldump on line 235

• Vincent