From: Jason Etheridge <jason@equinoxinitiative.org>
Date: Fri, 10 Apr 2020 15:22:43 +0000 (-0400)
Subject: kmig-sql: kthere IS a way to pass session variables from the command-line and still... 
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=20422519a122ca4ef85089be65fc9aea0ec80246

kmig-sql: kthere IS a way to pass session variables from the command-line and still get a shell
---

diff --git a/kmig.d/bin/kmig-sql b/kmig.d/bin/kmig-sql
index 535aa83..161dacd 100755
--- a/kmig.d/bin/kmig-sql
+++ b/kmig.d/bin/kmig-sql
@@ -6,9 +6,7 @@
 
 kmig-sql 
 
-A wrapper around the mysql client.  For the Postgres/EG version of this, we
-were injecting the mig schema as a session variable, but it doesn't look like
-we can do this through the command line for mysql.
+A wrapper around the mysql client.
 
 =head1 SYNOPSIS
 
@@ -38,6 +36,7 @@ my @MYARGV = (
     ,'--port=' . $MYSQL_TCP_PORT
     ,'--user=' . $MYSQL_USER
     ,'--password=' . $MYSQL_PW
+    ,"--init-command=set \@migschema = \"$MIGSCHEMA\";"
     ,$MYSQL_DATABASE
 );