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
--
craig sanders <cas@taz.net.au>
The next time you vote, remember that "Regime change begins at home"
Reply to: