Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

2011-10-02 Thread Tony Gravagno
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

Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

2011-10-02 Thread Kevin King
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