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]]
______________________________________________
[email protected] 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.
______________________________________________
[email protected] 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.
