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]