connecting RMySQL to and external server
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