On Tue, Jul 27, 2004 at 09:00:58AM -0400, Fraser Campbell wrote: > On July 27, 2004 03:58 am, Henrik Heil wrote: > > The record_ids will stay the same with mysqldump. > > What makes you think they will not? > > I have seen problems with this. The existing auto-incremented fields were > just fine but new ones were a little bit off. In a normal mysqldb if you > have a single record with id 1 and delete it then add another record the new > record will get id 2 (not filling in the missing 1). I've seen a case that > after a mysqldump and restore the new records did not honour have that > behaviour, "missing" ids were reused. I'm sure that I did something wrong > with the dump but in that case it was not important so I didn't research it > further.
that's bizarre....and could easily lead to a hopelessly corrupted database when other tables refer to that id field. how are you supposed to restore a mysql db from backup then? craig -- craig sanders <[EMAIL PROTECTED]> The next time you vote, remember that "Regime change begins at home" -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
