In a message dated 2/11/2004 2:26:09 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
I read this over and over.. I am curious why replication is such high
finance?? I run it here. The Production system is a high finance machine and the
replicated box is a old clunker basically.. It doesn't t
In a message dated 2/11/2004 4:44:00 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
Hi,
I do just this at the moment - I have a cron job that runs MySQL dump, gzips
the output, and will then ftp the important files to a machine that get's
backed-up to a tape drive. I also time the dump, and
whole thing simply uses the MS scheduler in windows.
Might be a help
Paul
> -Original Message-
> From: Michael McTernan [mailto:[EMAIL PROTECTED]
> Sent: 11 February 2004 21:41
> To: David Brodbeck; Michael Collins
> Cc: [EMAIL PROTECTED]
> Subject: RE: best-practices bac
[mailto:[EMAIL PROTECTED]
> Sent: 11 February 2004 19:27
> To: 'Michael McTernan'; Michael Collins
> Cc: [EMAIL PROTECTED]
> Subject: RE: best-practices backups
>
>
> > > -Original Message-
> > > From: Michael Collins [mailto:[EMAIL PROTECTED]
> -Original Message-
> From: Madscientist [mailto:[EMAIL PROTECTED]
> We use this mechanism, but we do our mysqldumps from a slave
> so the time doesn't matter.
Excellent idea.
> Interesting side effect: A GZIP of the data files is _huge_.
> A GZIP of the
> mysqldump is _tiny_. For
From: "David Brodbeck" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 9:27 PM
> > > -Original Message-
> > > From: Michael Collins [mailto:[EMAIL PROTECTED]
>
> > > Is there any "best-practices" wisdom on what is the most preferable
> > > method of backing up moderately (~10-20,000
> > -Original Message-
> > From: Michael Collins [mailto:[EMAIL PROTECTED]
> > Is there any "best-practices" wisdom on what is the most preferable
> > method of backing up moderately (~10-20,000 record) MySQL 4
> > databases? A mysql dump to store records as text, the
> format provided
>
> > Is there any "best-practices" wisdom on what is the most preferable
> > method of backing up moderately (~10-20,000 record) MySQL 4
> > databases? A mysql dump to store records as text, the
> format provided
> > by the BACKUP sql command, or some other method? I am not asking
> > about replic
s' :(
Thanks,
Mike
> -Original Message-
> From: Michael Collins [mailto:[EMAIL PROTECTED]
> Sent: 05 February 2004 22:56
> To: [EMAIL PROTECTED]
> Subject: best-practices backups
>
>
> Is there any "best-practices" wisdom on what is the most preferable
&g
For databases I usually just make a backup for each day of the month.
After all, disk space is cheap. So if a month has 31 days, I have 31
backups. That gives you about 30 days to discover any corruption that
may have occurred in a database. A crashed database is obvious, but
corruption usually
Is there any "best-practices" wisdom on what is the most preferable
method of backing up moderately (~10-20,000 record) MySQL 4
databases? A mysql dump to store records as text, the format provided
by the BACKUP sql command, or some other method? I am not asking
about replication, rotating back
11 matches
Mail list logo
