Bug #5118 | auto_increment not set in backup-file | ||
---|---|---|---|
Submitted: | 20 Aug 2004 3:30 | Modified: | 28 May 2009 22:00 |
Reporter: | Jochen Ulbricht | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Administrator | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[20 Aug 2004 3:30]
Jochen Ulbricht
[20 Aug 2004 23:10]
Matthew Lord
Dear User, Thank you for your bug report! I think this is a feature request as mysqldump does not mark the current auto_increment value either and how it's handled is really up to the table handler. The innodb table handler, for example, may reuse the deleted id value. Best Regards
[28 May 2009 11:31]
Susanne Ebrecht
Many thanks for writing a feature request. The behaviour for auto_increment of all our backup tools is an expected behaviour. When you want to have same values as before please use replication for backup and not a single backup tool.
[28 May 2009 22:00]
Jochen Ulbricht
After 5 years I do not even user this "single tools". I wrote my own while I was waiting ;) best regards