On Tue, 27 Jul 2004 17:56:18 +0200, Henrik Heil <[EMAIL PROTECTED]> wrote:
> My bad -- this is indeed a problem using mysqldump. I just checked the
> manpage and it seems that you cannot tell mysqldump to add
> AUTO_INCREMENT=... to the CREATE TABLE statement (please correct me if
> you know a way)
Chad Adlawan wrote:
I tried mysqldump and it actually recorded the original
AUTO_INCREMENTed id's. PhpMyAdmin also records this data whether you
check the "Add AUTO_INCREMENT value" checkbox or not.
I don't mean the inserted values but the next id that will be inserted.
This is what phpmayadmin doe
On Wed, Jul 28, 2004 at 11:39:40AM +1000, Kevin Littlejohn wrote:
> >that's bizarreand 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?
>
> Two answers:
>
> 1) Why are you rely
Craig Sanders wrote:
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
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
the reason why i don't want to do the database transfer using data
generated by mysqldump is because i want all the auto-generated
record_ids to stay the same in the new system.
The record_ids will stay the same with mysqldump.
What makes you think they will not?
I have seen problems with this.
On July 27, 2004 03:58 am, Henrik Heil wrote:
> > the reason why i don't want to do the database transfer using data
> > generated by mysqldump is because i want all the auto-generated
> > record_ids to stay the same in the new system.
>
> The record_ids will stay the same with mysqldump.
> What m
--- Henrik Heil <[EMAIL PROTECTED]> wrote:
>
> The record_ids will stay the same with mysqldump.
> What makes you think they will not?
Something must have made me think the auto-incremented
ids will be re-generated. My bad.
>
> you could set up replication to keep the databases
> in sync unti
Shannon R. wrote:
the reason why i don't want to do the database transfer using data
generated by mysqldump is because i want all the auto-generated record_ids
to stay the same in the new system.
The record_ids will stay the same with mysqldump.
What makes you think they will not?
If you cannot hav
On Jul 26, 2004, at 7:56 PM, Brian Nelson wrote:
Jeremy Zawodny <[EMAIL PROTECTED]> writes:
On Jul 26, 2004, at 6:21 PM, Shannon R. wrote:
hello list!
i'll be moving from a RedHat server to a Debian server very soon.
despite the different linux distributions, is it ok to transfer my
entire
mysql da
Jeremy Zawodny <[EMAIL PROTECTED]> writes:
> On Jul 26, 2004, at 6:21 PM, Shannon R. wrote:
>
>> hello list!
>>
>>
>> i'll be moving from a RedHat server to a Debian server very soon.
>> despite the different linux distributions, is it ok to transfer my
>> entire
>> mysql database by just copying
On Jul 26, 2004, at 6:21 PM, Shannon R. wrote:
hello list!
i'll be moving from a RedHat server to a Debian server very soon.
despite the different linux distributions, is it ok to transfer my
entire
mysql database by just copying everything in /var/lib/mysql of the
RedHat
system to the Debian sy
hello list! i'll be moving from a RedHat server to a Debian server very soon. despite the different linux distributions, is it ok to transfer my entire mysql database by just copying everything in /var/lib/mysql of the RedHat system to the Debian system? has anyone tried this before? the reason wh
13 matches
Mail list logo
