No.  Unless something has changed in TSM 5.3 client support, subfile
backups won't process a file larger than 2 GB.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Warren, Matthew (Retail)
Sent: Tuesday, February 15, 2005 5:33 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: My SQL


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