]]
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
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 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. Works fine
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
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
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: Backups mechanism
What we have done it right a small script
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
-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