Hi,
It looks like you are potentially dealing with two separate issues.
1) Access - Mysql has very find grained permissions as to who can access
what and from where. You need to make sure that your username in mysql
is allowed to access the database/tables from your location.
2) Corruption - You may have a corrrupted table. Just use the SQL
command, "check table xyz" to find out.
-N
On 10/23/09 1:29 PM, Robert Schneider wrote:> Hi there,
>
> I have been using RMySql for some time now without any problems until 2
weeks ago... Since then, I am only able to access some tables from within the
network where the db is located. When outside, I can't. I can access some of
the tables, but not all of them. This is true wether I use RMySql or any other
means (such as MySql admin). The reason I suspect RMySql is that R crashed twice
while carrying out a query on 2 different tables. It is these tables which I
can't access outside of the network.
>
> Any help would be much appreciated... be it with MySql or R !
>
> Thanks.
>
> Rob
>
> p.s. To make things really clear, hear is an excutive resume:
>
> - I can access most of the db tables from outside the network
> - I can only access the tables which were being queried during an R crash
from within the network.
>
> _________________________________________________________________
>
> 3! Buy it now!
>
> [[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.
>