[Toolserver-l] all about a pure sql script

[Robert Leverington]

On 16/06/07, Mashiah Davidson <mashiah.davidson at gmail.com> wrote:
> Robert,
>
> this looks good but where can I read about this?
>
> 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
> >
>
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>
>

You can't really read about having a database - you just have one :P

Anyway, http://meta.wikimedia.org/wiki/Toolserver may be of help.

Sorry for top posting by the way, I will try not to let it happen again.

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