I currently backup 4 SQL databases with 4 different scripts and at 4 different times all called via cron.
If I were to put all the commands into one single script, would they all play nice and run one after the other and only continue once the previous backup completes, or would they all try to run at once bringing the server to it's knees?
Here is an example of what I would like my single file to look like:
CODE
mysqldump -u USER -pPASS --opt DATABASE1| gzip > /SAVE/PATH1/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE2| gzip > /SAVE/PATH2/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE3| gzip > /SAVE/PATH3/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE4| gzip > /SAVE/PATH4/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE2| gzip > /SAVE/PATH2/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE3| gzip > /SAVE/PATH3/SQL.$(date +%a).gz
mysqldump -u USER -pPASS --opt DATABASE4| gzip > /SAVE/PATH4/SQL.$(date +%a).gz
Would they execute in order one after the other completes?