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.
