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:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Monday, February 27, 2006 3:57 PM To: ADSM-L@VM.MARIST.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
