]]
Sent: January 7, 2003 15:49
To: mysql users
Cc: Jonas Widarsson
Subject: Re: Backups mechanism
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonas --
...and then Jonas Widarsson said...
%
% Hello world!
Hi!
% Every attempt I have made to find a decent way of backing up a database
% ends up with
Jonas,
We use mysqlhotcopy as a command line script set to run daily as a cron
job. Seems to work fine. You can add flags that allow you to maintain
previous copies of the db in case you need to go back a version or two. It
took about 10 minutes to set up. We then run TSM backups to storage of
On Tue, 7 Jan 2003 [EMAIL PROTECTED] wrote:
>
> > I use mysqldump to do a total backup of my database. This is done once a
> > day just after midnight. The file is then taken up by our tape backup
> > software. I do hourly backups of our more important databases, also using
> > mysqlbackup. Wo
> I use mysqldump to do a total backup of my database. This is done once a
> day just after midnight. The file is then taken up by our tape backup
> software. I do hourly backups of our more important databases, also using
> mysqlbackup. Works fine and I have used it for restorals on a number
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonas --
...and then Jonas Widarsson said...
%
% Hello world!
Hi!
% Every attempt I have made to find a decent way of backing up a database
% ends up with tons of reading to show hundreds of ways to do database
% backups.
Heh :-) And you expe
On Tue, 7 Jan 2003, Jonas Widarsson wrote:
> Hello world!
> Every attempt I have made to find a decent way of backing up a database
> ends up with tons of reading to show hundreds of ways to do database
> backups.
>
> I want to know which way to do complete backups is most commonly used by
> pro
Can you post this script? (Minus the passwords, etc.)
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Jonas Widarsson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 11:18 AM
Subject: RE: Ba
What we have done it right a small script:
It logs on to the MySQL server.
It then locks the databases and tables we have put in a config file.
Simply copies the data files to a new directory.
Unlocks the tables.
Once this is done (copy if fast) you can tar or zip up the copied files.
Simon
---
