On Thursday 19 Aug 2010 15:23:41 barry newman wrote:
>  I need to be able to start my mysql server after my backup is
> complete , but I am also using a script to send email with various
> stats. Can I chain commands in this field ? I tried calling a script
> but it looses the variable substitutions for my email ($type, $client
> , etc). Was thinking converting this to an array in the code but if
> there is a quick fix I am all ears! Thanks

Barry,

I assume that what you are doing is stopping mysql, running the backup, and 
starting it again. If so, a better idea would be to call mysqldump, and then 
archive the dump. This way you can leave MySQL running and keep services up.

I archive both my running mysql and the daily dumps. In most of my casual uses 
cases, I've found I could restore the MySQL instance without problems. In 
those that managed to capture the DB in an unstable state, I just restored the 
dump.

Regards,
Tyler

-- 
"The map is not the territory."
   -- Alfred Korzybski

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/