mysqldump "spits" not only table structures but data also. When you use
mysql to import data it will first attempt to create the table and then load
its values. If your table's got AUTO_INCREMENT set it will work fine after
recreating the database. Anyway... Give it a try! :)
BR,
Fabio Ottolini
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald L. Clark
Sent: Wednesday, February 28, 2001 12:04 PM
To: [EMAIL PROTECTED]
Cc: Fabio Ottolini; [EMAIL PROTECTED]
Subject: Re: Antwort: RE: how to backup mySQL database?
[EMAIL PROTECTED] wrote:
>
> On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
>
> > Try using mysqldump.
>
> This won't work always! For instance, I have a table that has a
auto_increment
> INT column in it. Storing a row with this column set to 0 (zero), will
add this
> row just fine. But now the row will not have this column set to 0, but to
the
> value it would get when normally auto incrementing it.
> How to circumvent this?
>
But the dump who't have it set to zero, so it will reload with its
proper value.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
