Points to keep in mind (misskeys)

1. change any referece of "TSQLCMD" to "MYSQLCMD"
2. If you need to add the --port=#, you need to add it to the TEST command and 
not to the HOSTNAME

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, October 03, 2011 10:02 AM
To: U2 Users List
Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

This is what I do....

   HOSTNAME="" ; * example: http://servername  (assumes port 3306) otherwise 
add --port=port#touse
*
   TEST="mysql --connect_timeout=15 --user=":USERNAME:" --password=":PASSWORD:" 
-h ":HOSTNAME:" > /tmp/output":USRNO:" <<EOF"
*
   WRITE TEST ON F.TMP,"TSQLCMD":USRNO
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to