X-Git-Url: https://gerrit.simantics.org/r/gitweb?a=blobdiff_plain;f=releng%2Fdoc%2Fdump-mysql-db.sh;fp=releng%2Fdoc%2Fdump-mysql-db.sh;h=271eb42c10603223b06a313a5db5d245eb4cb793;hb=70d2af523cf495a41ad1ef5a40ec56c7362e59e2;hp=0000000000000000000000000000000000000000;hpb=c6133d637f50045f7827056b604587ab13a2dae9;p=simantics%2Fplatform.git diff --git a/releng/doc/dump-mysql-db.sh b/releng/doc/dump-mysql-db.sh new file mode 100755 index 000000000..271eb42c1 --- /dev/null +++ b/releng/doc/dump-mysql-db.sh @@ -0,0 +1,18 @@ +#!/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