Robert,

I was not too smart asking my previous question.
Now it is obvious for me how to use my own database and fortunately I also have reading rights to other databases when use my own one.

Thank you a lot.

Mashiah

2007/6/16, Robert Leverington <lcarsdata@googlemail.com>:
On the toolserver you are given your own database, this may be of help.

On 16/06/07, Mashiah Davidson <mashiah.davidson@gmail.com> wrote:
> I have created a pure sql script
> (http://ru.wikipedia.org/wiki/%D0%A3%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA:Mashiah_Davidson/toolserver
> ) for orphaned articles collection according to Russian wikipedia rules.
>
> This script cannot be run as is on the toolserver because it creates some
> new temporary tables during execution, so my primary goal is to understand
> how can I adapt this script to run on the toolserver. May be it is a way to
> create my own little database and grant me writing rights on it or maybe
> there is some other ways to work it out without rewriting it in perl or
> python and working with hashes instead of sql tables.
>
> One more thing, I am ok with running the script on my local machine but I
> need an sql dump of some tables for this. Maybe there is a way to create a
> little dump for tables I need on the toolserver on a daily basis instead of
> waiting during two-three weeks when the dump of ruwiki will be available
> again. I tried to dump a table on the toolserver without any success because
> this requires table locking and I again have no rights for this. Is there a
> way to create an sql dump without locking a table? I tried
> '--skip-lock-table' option but got the following message:
>
> mysqldump: Couldn't execute 'show create table `...`': SHOW VIEW command
> denied to user '...' for table '...' (1142)
>
> Please advise.
>
> Mashiah Davidson
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l@lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>
>


--
Robert
http://roberthl.wikitest.co.uk/

_______________________________________________
Toolserver-l mailing list
Toolserver-l@lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/toolserver-l