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:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Tuesday, February 15, 2005 5:33 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Ung Yi Sent: Monday, February 14, 2005 1:45 PM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of John E. Vincent Sent: Saturday, February 12, 2005 11:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: My SQL John Monahan wrote: > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.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
