Hello

I am using MySQL v4.0.18.  I am using the mysqldump program to do backups.  I was 
wondering how, if at all, does mysqldump preserver the auto_increment value?

When using phpmyadmin, there is an option to preserve the auto_increment value and the 
resulting file has something like:
        ) TYPE=MyISAM COMMENT='Defines assignments' AUTO_INCREMENT=15 ;
in the create table definition.  When I run mysqldump and look at the resulting file, 
I do not see anything like this.  Nor, can I find documentation on what phpmyadmin is 
doing.

Thanks in advance!
Gabe

<><><><><><><><><><><><><><><><><><><><>><><>

"Arise Arise A Rose A Rose"

Gabriel Tucker

609 750 6668 - P
646 268 5681 - F

<><><><><><><><><><><><><><><><><><><><>><><>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to