[Veritas-bu] AUTOMATE MYSQL DUMP BACKUP

Subject:	[Veritas-bu] AUTOMATE MYSQL DUMP BACKUP
From:	Anurag Sharma <sharma.anurag AT hotmail DOT com>
To:	veritas-bu <veritas-bu AT mailman.eng.auburn DOT edu>, veritas-bu2 <veritas-bu-bounces AT mailman.eng.auburn DOT edu>
Date:	Tue, 20 May 2014 01:27:04 +0530

Hi All,

Here's my situation.

MASTER/MEDIA : Solaris 10

Client : Linux/Solaris

There is a backup script created by mysql admin lets call it backup.sh which can do on demand mysql dump on a directory

/mysql_backup/yyyymmdd. It mean every time you run the script it will create a folder with that date.

I have been told to backup these dump files as standard backup.

I need following accomplished.

1. Need to call backup.sh to perform mysql dump and crate dump in /mysql_backup/yyyyymmdd
2. Run netbackup backup to backup the dump.
3. Once the netbackup backup is successful delete the dump from disk.

What would be the best way to do it via netbackup ? Do I have to use bpstart and bpend scripts on each client ?

Please guide.

Anurag Sharma

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu