FYI.

If you're using a newer version of mysql ( which you should be ) , you
dont need to run a for loop to create a list of databases that need to be
dumped, you can just use use the "-A" flag which will dump all the
databases for you.

Cheers.

-- Steve





On Fri, 15 Mar 2002, Timothy J. Arnold wrote:

> Cheers for this..
> 
> If they did make a agent it would be another veritas cash cow.. Why
> isn't there one?? :)
> 
> Tim.
> 
> > -----Original Message-----
> > From: Marcelo Bartsch [mailto:mbartsch AT NETGLOBALIS DOT NET] 
> > Sent: 15 March 2002 13:37
> > To: Timothy J. Arnold
> > Cc: Veritas BU
> > Subject: Re: [Veritas-bu] MySQL
> > 
> > 
> > On Fri, 2002-03-15 at 09:06, Timothy J. Arnold wrote:
> > Timothy,
> >     What i do is to exec mysqldump everyday before the 
> > backup start, is not
> > the best solution, but it works for not to big databases, i use
> > something like this:
> > 
> > -----SCRIPT-----
> > #!/bin/bash 
> > NFSSERVER=192.168.5.2
> > NFSPATH=/remotedb
> > 
> > for d in `ls -l /var/lib/mysql|grep ^d |awk '{print $9}'|grep -v
> > lost+found`; do
> >     echo "Backing Up $d"
> >     mysqldump --opt $d | gzip -c -f > /dbs/$d.sql.gz
> > done
> > -----SCRIPT-----
> > i run this from cron every night. "It Works For Me"(tm).
> > 
> > i wish veritas create a MySQL and/or PostgreSQL Agent too. 
> > 
> > Regards!
> > 
> > 
> > > Hi all,
> > > 
> > > Has anyone ever tried to backup MySQL using NetBackup? I 
> > guess I could
> > > perform a cold backup by shutting down the server, copying the data
> > > files to another disk and bringing MySQL up. Is this the 
> > best method?
> > > 
> > > Cheers,
> > > 
> > > Tim.
> > > 
> > > _______________________________________________
> > > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> > -- 
> >    Marcelo Bartsch
> > mbartsch AT netglobalis DOT net
> >   www.netglobalis.net
> > 
> > PGP Fingerprint : 
> > 877E 3A56 F523 B44A 3260  8F83 8916 E158 6100 F721
> > 
> > 
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> 



Todays root password is brought to you by /dev/random

.-------------------------------------.
| Steve Mickeler * Network Operations |
+-------------------------------------+
|     Neptune Internet Services       |
`-------------------------------------'

1024D/ACB58D4F = 0227 164B D680 9E13 9168  AE28 843F 57D7 ACB5 8D4F