[Toolserver-l] all about a pure sql script

[Merlijn van Deen]

The u_<username> database is all yours; you are able to do everything with
it (except dropping it, maybe ;)). Replace <username> with your toolserver
username, obviously.

--valhallasw

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