From 3652b5f03c8fef235a8f51d038a160ff014a6b50 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Franti=C5=A1ek=20Dvo=C5=99=C3=A1k?= Date: Fri, 19 Jun 2009 09:48:18 +0000 Subject: [PATCH] Default dbname for migration of L&B proxy. --- org.glite.lb.server/config/glite-lb-migrate_db2version20 | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/org.glite.lb.server/config/glite-lb-migrate_db2version20 b/org.glite.lb.server/config/glite-lb-migrate_db2version20 index f59d647..a547fbf 100644 --- a/org.glite.lb.server/config/glite-lb-migrate_db2version20 +++ b/org.glite.lb.server/config/glite-lb-migrate_db2version20 @@ -25,9 +25,6 @@ EOF SERVER="" PROXY="" -#default DB name (may be overriden by -d option) -DB_NAME="lbserver20" - while getopts "spd:h" OPTION do case "$OPTION" in @@ -59,6 +56,16 @@ if [ "$SERVER" -a "$PROXY" ]; then fi +# default DB name (for server or proxy, overriden by -d option) +if [ -z "$DB_NAME" ]; then + if [ "$SERVER" ]; then + DB_NAME="lbserver20" + else + DB_NAME="lbproxy" + fi +fi + + # convert for transactions (if needed and very old DB) for table in jobs users events short_fields long_fields states status_tags server_state acls notif_registrations notif_jobs; do echo "SHOW CREATE TABLE $table;" | mysql -u lbserver $DB_NAME | grep -i ENGINE | grep -i InnoDB >/dev/null -- 1.8.2.3