[Toolserver-l] all about a pure sql script

[Mashiah Davidson]

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 at googlemail.com>:
>
> On the toolserver you are given your own database, this may be of help.
>
> On 16/06/07, Mashiah Davidson <mashiah.davidson at 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 at lists.wikimedia.org
> > http://lists.wikimedia.org/mailman/listinfo/toolserver-l
> >
> >
>
>
> --
> Robert
> http://roberthl.wikitest.co.uk/
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20070617/30b547da/attachment.htm