Re: mysqldump on tables which use auto_increment

2002-08-27 Thread Gerald Clark
use the -f option to ignore the duplicates. Chris Barnes wrote: >Hi, >I have a database which a few tables which have a few fields set with >auto_increment and i'm having alot of trouble restoring the backup because >the backup recreates the table with the auto_increment field, but when it >trie

RE: mysqldump on tables which use auto_increment

2002-08-27 Thread Chris Barnes
Hi, I have a database which a few tables which have a few fields set with auto_increment and i'm having alot of trouble restoring the backup because the backup recreates the table with the auto_increment field, but when it tries to enter the data back into the table it cant because it is trying to