RE: Backups mechanism

2003-01-09 Thread Fernando Grijalba
]] 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

Re: Backups mechanism

2003-01-08 Thread Jon Bertsch
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

Re: Backups mechanism

2003-01-08 Thread Aaron Clausen
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

Re: Backups mechanism

2003-01-08 Thread ed
> 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

Re: re[2]: Backups mechanism

2003-01-07 Thread Stefan Hinz, iConnect \(Berlin\)
n" <[EMAIL PROTECTED]>; "'Jonas Widarsson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 7:49 PM Subject: re[2]: Backups mechanism Hi, I agree with the post... I feel there should be an inbuilt backup routine. (maybe

Re: Backups mechanism

2003-01-07 Thread David T-G
-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

Re: Backups mechanism

2003-01-07 Thread Aaron Clausen
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

Re: Backups mechanism

2003-01-07 Thread Lefevre, Steven
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

re[2]: Backups mechanism

2003-01-07 Thread Richard Morton
t;> -Original Message- >> From: Jonas Widarsson [mailto:[EMAIL PROTECTED]] >> Sent: 07 January 2003 15:07 >> To: [EMAIL PROTECTED] >> Subject: Backups mechanism >> Hello world! >> Every attempt I have made to find a decent way of backing up a

RE: Backups mechanism

2003-01-07 Thread Simon Green
-Original Message- From: Jonas Widarsson [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 15:07 To: [EMAIL PROTECTED] Subject: Backups mechanism 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

Backups mechanism

2003-01-07 Thread Jonas Widarsson
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 professional users. (Windows and Linux) I have pleasant e