Chad Adlawan wrote:
I tried mysqldump and it actually recorded the original
AUTO_INCREMENTed id's. PhpMyAdmin also records this data whether you
check the "Add AUTO_INCREMENT value" checkbox or not.
I don't mean the inserted values but the next id that will be inserted.

This is what phpmayadmin does with checked "Add AUTO_INCREMENT value"

CREATE TABLE `testtab` (
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
              ^^^^^^^^^^^^^^^^

I don't know how get this with mysqldump.

Best regards,
Henrik

--
Henrik Heil, zweipol Coy & Heil GbR
http://www.zweipol.net/


-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]



Reply via email to