#!/bin/bash major=$1 minor=$2 service=$3 wikidb=$4 wikidbusr=$5 srcdb=${wikidb} srcdbusr=${wikidbusr} tgtdb=${wikidb}_${major}_${minor}_${service} echo "Dumping database ${srcdb} to ${tgtdb} as user ${srcdbusr}" echo "Press enter to continue or C-c to cancel" read foo echo "Dumping $srcdb" mysqldump -u ${srcdbusr} -p ${srcdb} > ${tgtdb}.dump