[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: q re transferring mysql db from redhat to debian

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 sanders <cas@taz.net.au>

The next time you vote, remember that "Regime change begins at home"

Reply to: