[R] RMySql problem

[Noah Silverman]

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.
>