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@lists.sourceforge.net List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/