[R] RMySQL with Windows 7

[Christian Oswald]

I understand, but in my case the R-Library is in my user-folder.
But I have investigate the files needed by RMySQL and found that the gcc
searchs for libmysql.lib in MYSQL_HOME\lib\opt but it is only in lib.
Copying it in lib/opt solved the problem.

Thanks,
Christian




Am 06.02.2014 14:52, schrieb Duncan Murdoch:
> On 06/02/2014 1:39 PM, Christian Oswald wrote:
>> Hello,
>>
>> how can I install it on a wrong place?
>>
>>   "install.packages("RMySQL",type=source) don't work correct?
>
> Many Windows users have R installed in "c:\Program Files", and normal
> users are not allowed to write there.  The .libPaths() function will
> tell you what libraries you are using; R will try to install to the
> first of those.
>
> Duncan Murdoch
>>
>> Christian
>>
>>
>>
>> Am 06.02.2014 09:28, schrieb Duncan Murdoch:
>> > On 06/02/2014 8:43 AM, Christian Oswald wrote:
>> >> Hello,
>> >>
>> >> I also don't found a solution for this problem. RMySQL works very
>> well
>> >> under Linux but not under Windows. You can try RODBC.
>> >
>> > RMySQL works fine for me in Windows.
>> >
>> > The most common problem people have installing packages in Windows is
>> > that they try to install them to places where they don't have write
>> > permission.
>> >
>> > Duncan Murdoch
>> >
>> >>
>> >> Christian
>> >>
>> >>
>> >> Am 05.02.2014 14:37, schrieb Peretz, Eliran:
>> >> >
>> >> > Hi ,
>> >> >
>> >> > I read your post and followed your instructions but still couldn't
>> >> install RMySQL by getting the message: "installation of package
>> >> â??RMySQLâ?? had non-zero exit status"
>> >> > Can you please walk me through the process from the installation
>> >> part (version, etc) to all the paths that need to be created and
>> so on.
>> >> >
>> >> > Appreciate any support you can offer.
>> >> >
>> >> > Best,
>> >> >
>> >> > Eliran.
>> >> >     [[alternative HTML version deleted]]
>> >> >
>> >> >
>> >> >
>> >> > ______________________________________________
>> >> > 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.
>> >>
>> >>
>> >>     [[alternative HTML version deleted]]
>> >>
>> >>
>> >>
>> >> ______________________________________________
>> >> 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.
>> >
>> >
>>
>
>