Re: how to backup mySQL database?

2001-03-26 Thread Christopher L. Everett
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) " > > can you help? > try: mysqldump --opt database -u -p > backup

Re: how to backup mySQL database?

2001-03-12 Thread Tõnu Samuel
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) " > > can you help? Please read the manual and list archive! > Befor

Re: how to backup mySQL database?

2001-03-09 Thread Steve Ruby
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) " > > can you help? > > with best regards, > Keneth Read the manual,

Antwort: Re: Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-03-01 Thread alexander . skwar
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! -

Antwort: RE: Antwort: RE: how to backup mySQL database?

2001-03-01 Thread alexander . skwar
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 > recre

RE: how to backup mySQL database?

2001-02-28 Thread Quentin Bennett
:21 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: how to backup mySQL database? This is the way i do it: - write a script that will run mysqldump on the database of choice and then pipe the result though gzip (this is only to reduce the size) - the script also copies the new backup

Re: how to backup mySQL database?

2001-02-28 Thread Dan Adams
This is the way i do it: - write a script that will run mysqldump on the database of choice and then pipe the result though gzip (this is only to reduce the size) - the script also copies the new backup over the old one where every you may be backing it up - run this script with cron every nigh

Re: Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[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

Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
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 the next available value (if Au

RE: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Fabio Ottolini
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 P

Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[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 jus

Re: how to backup mySQL database?

2001-02-28 Thread Steve Ruby
ccp.sql mysqldump: Got error: 1045: > Access denied for user: 'accp@localhost' (Using pass word: NO) " > > can you help? > > with best regards, > Keneth > - Original Message - > From: "Fábio Ottolini" <[EMAIL PROTECTED]> > To: <[EM

Antwort: Re: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
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

Antwort: RE: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
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 th

Re: how to backup mySQL database?

2001-02-28 Thread Keneth
sage - From: "Fábio Ottolini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 4:26 AM Subject: RE: how to backup mySQL database? > Try using mysqldump. > > BR, > > Fábio Ottolini > > -Original Message- > From: Keneth [

RE: how to backup mySQL database?

2001-02-28 Thread Fábio Ottolini
Try using mysqldump. BR, Fábio Ottolini -Original Message- From: Keneth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 28, 2003 5:06 AM To: [EMAIL PROTECTED] Subject: how to backup mySQL database? Anyone know how to backup mySQL database? with best regards, TOM