On Saturday 15 December 2007, you wrote: > Use ssh forwarding to forward local port 3307 to remote port 3306 > specifying the remote account and password. Then if you use local port > 3306 you can access your local version of MySQL and if you > use port 3307 you can access the remote version. There is some > info on the MySQL site. First test it out by running the mysql command > line program accessing the remote data base via port 3307 and once > that works you know its ok and you can try RMySQL or RODBC packages.
Thanks Gabor, it is a little bit of a foreign language for me (at the moment) but I'm sure your hints will be relevant to our sysadmin. I do want to understand this stuff myself, just need more digging in the manuals. Cheers, Adrian -- Adrian Dusa Romanian Social Data Archive 1, Schitu Magureanu Bd 050025 Bucharest sector 5 Romania Tel./Fax: +40 21 3126618 \ +40 21 3120210 / int.101 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.