...@listserver.u2ug.org] On Behalf Of Manu Fernandes
Sent: Saturday, October 01, 2011 4:55 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?
Hi group,
I'm looking for your experiences...
From Universe/linux, I'll execute a mySQL sql phrase.
mySQL
] 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
2011 09:55
To: u2-users@listserver.u2ug.org
Subject: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?
Hi group,
I'm looking for your experiences...
From Universe/linux, I'll execute a mySQL sql phrase.
mySQL is installed on a remote server.
- What is the mysql-client to be installed
The easy answer is to pretend you're doing this from a web page,
where the MP in LAMP is MySQL and PHP. From there you have a
world full of answers rather than something U2-specific. Note
that most shared hosts don't have a MySQL DBMS on the same system
as the HTTP servers. They almost Always
To followup to what Tony said, we do this with PHP by creating a
JSON-formatted extract out of Unidata, then ftp it to the other
system, then use Apache to kick off a job to post the file into MySQL
and PostgreSQL. Works like a champ for small to medium data sets.
For large datasets we do
Hi group,
I'm looking for your experiences...
From Universe/linux, I'll execute a mySQL sql phrase.
mySQL is installed on a remote server.
- What is the mysql-client to be installed beside Universe ?
- How to execute a sql-phrase from UV/BASIC ? and capture the result !?
Thanks for any
I believe you'll need an ODBC driver for MySQL. You would then use the
syntax described in UniVerse's Basic Calling Interface (BCI) documentation.
On Sat, Oct 1, 2011 at 4:55 AM, Manu Fernandes e...@infodata.lu wrote:
Hi group,
I'm looking for your experiences...
From Universe/linux,
