---
From: "McKeever Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 04, 2004 8:39 PM
Subject: Re: Backing Up a Database
>
>
> On Fri, 4 Jun 2004 18:16 , Lou Olsten <[EMAIL PROTECTED]> sent:
>
> >For the time I've been te
On Fri, 4 Jun 2004 18:16 , Lou Olsten <[EMAIL PROTECTED]> sent:
>For the time I've been testing, I've used the procedures outlined in the help to take
>my backups, which entails doing a FLUSH TABLES WITH
READ LOCK in my MySQL monitor, then going to a shell prompt and executing the
mysqldump u
g purposes, you may also just call /etc/cron.daily/logrotate by hand from
the commandline.
Felix
-Ursprüngliche Nachricht-
Von: Alexander Shaw [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Februar 2002 01:15
An: MySQL List; Felix Richter
Betreff: RE: **Backing Up A Database**
Hi Felix
y are working correctly?
Alex
-Original Message-
From: Felix Richter [mailto:[EMAIL PROTECTED]]
Sent: 18 February 2002 15:26
To: David yahoo; mySQL List
Subject: Re: **Backing Up A Database**
- create a file in /etc/logrotate.d, filename does not matter, take
this as a template, fi
- create a file in /etc/logrotate.d, filename does not matter, take this as a
template, fill in connection parameters in mysqldump call (""):
/home/backup/sqlback/mybackup.sql {
daily
nomissingok
nocreate
compress
rotate 14
errors [EMAIL PROTECTED]
prerotate
How did u do exactly ?
It's not documented.
Does it take a long.
Do u have to flush and lock tables before, that can be critical for 24/24
server.
what conf for logrotate ?
a+.
>I personally issue "mysqldump"s via cron and maintain the files using
"logrotate" (Redhat Linux), which >automatic
Please see
http://www.mysql.com/doc/B/a/Backup.html
I personally issue "mysqldump"s via cron and maintain the files using "logrotate"
(Redhat Linux), which automatically zips and rotates them.
-
Before posting, please check:
