--=-J9l8ONv82KQPPkiH2cpJ
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Fri, 2002-03-15 at 10:13, Steve Mickeler wrote:
yes -A is good, but is a pain to recover just one database.

just my 0.02 USD :)

>=20
> FYI.
>=20
> 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.
>=20
> Cheers.
>=20
> -- Steve
>=20
>=20
>=20
>=20
>=20
> On Fri, 15 Mar 2002, Timothy J. Arnold wrote:
>=20
> > Cheers for this..
> >=20
> > If they did make a agent it would be another veritas cash cow.. Why
> > isn't there one?? :)
> >=20
> > Tim.
> >=20
> > > -----Original Message-----
> > > From: Marcelo Bartsch [mailto:mbartsch AT NETGLOBALIS DOT NET]=20
> > > Sent: 15 March 2002 13:37
> > > To: Timothy J. Arnold
> > > Cc: Veritas BU
> > > Subject: Re: [Veritas-bu] MySQL
> > >=20
> > >=20
> > > On Fri, 2002-03-15 at 09:06, Timothy J. Arnold wrote:
> > > Timothy,
> > >   What i do is to exec mysqldump everyday before the=20
> > > backup start, is not
> > > the best solution, but it works for not to big databases, i use
> > > something like this:
> > >=20
> > > -----SCRIPT-----
> > > #!/bin/bash=20
> > > NFSSERVER=3D192.168.5.2
> > > NFSPATH=3D/remotedb
> > >=20
> > > 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).
> > >=20
> > > i wish veritas create a MySQL and/or PostgreSQL Agent too.=20
> > >=20
> > > Regards!
> > >=20
> > >=20
> > > > Hi all,
> > > >=20
> > > > Has anyone ever tried to backup MySQL using NetBackup? I=20
> > > 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=20
> > > best method?
> > > >=20
> > > > Cheers,
> > > >=20
> > > > Tim.
> > > >=20
> > > > _______________________________________________
> > > > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > > > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> > > --=20
> > >    Marcelo Bartsch
> > > mbartsch AT netglobalis DOT net
> > >   www.netglobalis.net
> > >=20
> > > PGP Fingerprint :=20
> > > 877E 3A56 F523 B44A 3260  8F83 8916 E158 6100 F721
> > >=20
> > >=20
> >=20
> > _______________________________________________
> > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >=20
>=20
>=20
>=20
> Todays root password is brought to you by /dev/random
>=20
> .-------------------------------------.
> | Steve Mickeler * Network Operations |
> +-------------------------------------+
> |     Neptune Internet Services       |
> `-------------------------------------'
>=20
> 1024D/ACB58D4F =3D 0227 164B D680 9E13 9168  AE28 843F 57D7 ACB5 8D4F
>=20
>=20
>=20
--=20
   Marcelo Bartsch
mbartsch AT netglobalis DOT net
  www.netglobalis.net

PGP Fingerprint :=20
877E 3A56 F523 B44A 3260  8F83 8916 E158 6100 F721

--=-J9l8ONv82KQPPkiH2cpJ
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA8kgnGiRbhWGEA9yERAo7NAJ9+TBGY4wq03gvtWscsX1/KNz253QCeKU6c
MwnDLFQEZ8bE9+Ul9HnI3DM=
=fwS8
-----END PGP SIGNATURE-----

--=-J9l8ONv82KQPPkiH2cpJ--