neatgadgets
2010-Jul-19 04:09 UTC
[R] Can RMySQL run on Windows using a remote MySQL server?
Can RMySQL run on Windows using a remote MySQL server? -- View this message in context: http://r.789695.n4.nabble.com/Can-RMySQL-run-on-Windows-using-a-remote-MySQL-server-tp2293533p2293533.html Sent from the R help mailing list archive at Nabble.com.
Steven McKinney
2010-Jul-19 22:16 UTC
[R] Can RMySQL run on Windows using a remote MySQL server?
I have done this from my previous computer, a Windows PC running Windows XP (32 bit). So in theory it can be done. I had installed the MySQL Workbench application as well which no doubt set up the MySQL dll's needed. My new computer is running Windows 7 64-bit for which RMySQL is not yet built. What OS are you running? Steven McKinney Statistician Molecular Oncology and Breast Cancer Program British Columbia Cancer Research Centre ________________________________________ From: r-help-bounces at r-project.org [r-help-bounces at r-project.org] On Behalf Of neatgadgets [neatgadgets at gmail.com] Sent: July 18, 2010 9:09 PM To: r-help at r-project.org Subject: [R] Can RMySQL run on Windows using a remote MySQL server? Can RMySQL run on Windows using a remote MySQL server? -- View this message in context: http://r.789695.n4.nabble.com/Can-RMySQL-run-on-Windows-using-a-remote-MySQL-server-tp2293533p2293533.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at 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.
Steven McKinney
2010-Jul-20 21:29 UTC
[R] Can RMySQL run on Windows using a remote MySQL server?
So the answer is yes. Install the MySQL Workbench application on your XP box and work out the URL, account name and password, and port connection issues to the reomte MySQL database. You should then have a MySQL driver available. Set up a User DSN or System DSN to the remote database using ODBC Data Source Administrator widget in Windows administrative tools. Install RMySQL, configure and enjoy. Good luck! Steven McKinney ________________________________________ From: r-help-bounces at r-project.org [r-help-bounces at r-project.org] On Behalf Of neatgadgets [neatgadgets at gmail.com] Sent: July 19, 2010 3:26 PM To: r-help at r-project.org Subject: Re: [R] Can RMySQL run on Windows using a remote MySQL server? I'm using Windows XP. -- View this message in context: http://r.789695.n4.nabble.com/Can-RMySQL-run-on-Windows-using-a-remote-MySQL-server-tp2293533p2294705.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at 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.
Change of user, was neatgadgets but that seems to not work very well. I managed to get it working by copying the 2 dll files into the R bin folder. So I am up and running now. Thanks for your help. -- View this message in context: http://r.789695.n4.nabble.com/Can-RMySQL-run-on-Windows-using-a-remote-MySQL-server-tp2293533p2296597.html Sent from the R help mailing list archive at Nabble.com.