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.