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 testing, I've used the procedures outlined in the
help to take my backups, which entails
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
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
Can anyone recommend a software app. I could buy to be able
to dump data and
table structures to a text file. Ideally as mentioned before
I need to run
this on a hourly basis.
Backing up the entire database
and
table structures to a text file. Ideally as mentioned before I need to run
this on a hourly basis.
Rgds,
Neil
From: Gerald R. Jensen [EMAIL PROTECTED]
Reply-To: Gerald R. Jensen [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: backing up mySQL database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil, et al --
...and then Neil Tompkins said...
%
% Hi
Hi!
%
% Thanks for that information. But I think I want to purchase a software
% application, due to my lack of knowledge for mySQL. In addition to this,
% my ISP doesn't allow that
I might be totally off track here, but a simple shell script works fine for
me. /bin/sh, tar, and cron are a powerful team.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday,
You don't have to develop or buy anything. You can use mysqldump in
conjunction with a shell script to do what you want, and automate it with
either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix).
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
PROTECTED], [EMAIL PROTECTED]
Subject: Re: backing up mySQL database ?
Date: Sat, 30 Nov 2002 10:23:22 -0600
You don't have to develop or buy anything. You can use mysqldump in
conjunction with a shell script to do what you want, and automate it with
either the Windows Scheduler (on Win32
:
# Make backups of databases at 4am daily
0 4 * * * /usr/local/bin/mydbbak.sh
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 12:11 PM
Subject: Re: backing up mySQL database ?
I rent my mySQL database from
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 (or anyone),
I'm giving this a go but as a Linux newbie
they 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, fill
Please see
http://www.mysql.com/doc/B/a/Backup.html
I personally issue mysqldumps via cron and maintain the files using logrotate
(Redhat Linux), which automatically zips and rotates them.
-
Before posting, please check:
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 mysqldumps via cron and maintain the files using
logrotate (Redhat Linux), which automatically
- 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
14 matches
Mail list logo