If you are running MySQL on Windows:

There is no TSM special agent for MySQL. 
The MySQL tables back up just fine as flat files, unless they are in use at the 
time of the backup.
So you can always try shutting down MySQL before runing an ordinary TSM backup.

If that isn't a good idea for your environment, look in the /bin directory for 
either mysqldump.exe or mysqlhotcopy.pl.

mysqlhotcopy.pl is perl (it requires some minor tweaking to run with 
windows-style filenames).
It figures out the list of tables in your DB and locks them briefly in a polite 
MySQL way while it copies the tables to another directory where TSM can back 
them up unmolested.  

To restore your MySQL tables, you just restore the 3 flat files that make up a 
table, so it's pretty simple.

Wanda Prather
"* I/O, I/O, It's all about I/O *"  -(me)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Dennis Melburn W IT743
Sent: Monday, February 27, 2006 3:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Backing up a MySQL database


Can this be done with the standard TSM 5.3.X client, or do I need a
special app for this?
 
 
Mel Dennis