[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: q re transferring mysql db from redhat to debian

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`)

I don't know how get this with mysqldump.

Best regards,

Henrik Heil, zweipol Coy & Heil GbR

Reply to: