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