On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote:
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
On 28.02.2001 19:51:13 Gerald L. Clark wrote:
In the dump, the autoincrement columns will have their actual values,
not 0.
Yes, correct - and if the actual value is 0, it will contain just this. And
inserting a row with the col set to 0, will change the column value.
TRY IT!
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
On 28.04.2003 10:55:50 Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
You did not specify the username and password on
[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.
o 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 PROTEC
[EMAIL PROTECTED] wrote:
On 28.02.2001 16:03:57 Gerald L. Clark wrote:
But the dump who't have it set to zero, so it will reload with its
proper value.
No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
(AutoCol) VALUES (0)" means that AutoCol should be set to