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`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
I don't know how get this with mysqldump.
Henrik Heil, zweipol Coy & Heil GbR