Could shutting down MySQL then using subfile backups be a way to achieve
it?

_-'-_
  -|-


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ung Yi
Sent: Monday, February 14, 2005 1:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: My SQL

Just thinking out loud.
I would use pre job command to backup the MySQL database to a disk then
have
the TSM backup the dump file.
MySQL comes with a backup command call mysqldump.




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
John
E. Vincent
Sent: Saturday, February 12, 2005 11:00 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: My SQL

John Monahan wrote:
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/11/2005
> 11:26:44 AM:
>
>
>>On Feb 11, 2005, at 11:51 AM, Joe Crnjanski wrote:
>>
>>
>>>Another simple question,
>>>
>>>HOW we can backup My SQL database.
>>>
>>>I have a customer with around 5GB MySQL database. Backup is over the 
>>>internet, so dump file backup is out of question.
>>
>>A not-so-simple answer...which is:
>>"Hmmm... MySQL has an API, and TSM has an API, so an enterprising 
>>customer programmer could..."
>>
>>I'm kind of surprised to not heard of someone producing a "Customer 
>>Data Protection" client for MySQL, given the potential. There might be

>>one out there.
>>
>>     Richard Sims
>
>
>
>
> Well, there just happens to be a new draft redpiece on this topic.
> "Backing Up Linux Databases with the TSM API"
>
> http://www.redbooks.ibm.com/redpieces/abstracts/redp3980.html?Open
>
> ______________________________
> John Monahan
> Senior Consultant Enterprise Solutions Computech Resources, Inc.
> Office: 952-833-0930 ext 109
> Cell: 952-221-6938
> http://www.computechresources.com

Interestingly enough, we've just moved our data warehouse from MySQL to
PostgreSQL and I was investigating something similar. PGSQL will
actually let
you archive log files with a userexit command similar to
DB2 and deal with return codes. I was going to attempt to recompile a
DB2 userexit and use that as a log archiving command. I was just wishing
there was something similar to db2adutl though.

It looks like adsmpipe has that functionality as well.

This is a really good move for IBM because there is a market waiting to
be
exploited by TSM in the opensource database arena as some enterprising
intern
has just documented.


___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be read by 
those to whom they are addressed. If you are not the intended recipient, please 
contact us, delete the message from your computer and destroy any copies. Any 
distribution or copying without our prior permission is prohibited.

Internet communications are not always secure and therefore Powergen Retail 
Limited does not accept legal responsibility for this message. The recipient is 
responsible for verifying its authenticity before acting on the contents. Any 
views or opinions presented are solely those of the author and do not 
necessarily represent those of Powergen Retail Limited. 

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 
8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432