ADSM-L

Re: [ADSM-L] backup of MySQLDB

2008-02-13 15:36:44
Subject: Re: [ADSM-L] backup of MySQLDB
From: Wanda Prather <wprather AT JASI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 13 Feb 2008 15:06:25 -0500
Read the mysql admin guide; they explain how to do backups.

In 99% of cases, no special agent is necessary because the mysql data bases
are actually comprised of 4 (I think) flat files each.  They back up just
fine as flat files, and you can restore them as flat files.

The only time you will run into a problem is if there is a very large
individual file that is accessed so frequently that TSM always detects it as
changing (make sure your client is at least TSM 5.3.5 or higher, and that is
less likely to happen).

In that case mysql provides a perl script you can implement that will create
copies of the mysql files in another directory, then TSM can back up those
flat files.

W


On 2/13/08, Avy Wong <AWong AT mohegansun DOT com> wrote:
>
> Hello,
>      Is it still hold truth that there is no TSM special agent to backup
> MySQL database. I searched on the Adsm archive, and the comments are
> because it is opensource and there is no money in it, IBM do not support
> it. What is your input on this? and what are the work around? Thanks.
>
>
>
>
> Avy Wong
> Business Continuity Administrator
> Mohegan Sun
> 1 Mohegan Sun Blvd
> Uncasville, CT 06382
> (860)862-8164
> (cell) (860)961-6976
>

<Prev in Thread] Current Thread [Next in Thread>