[Toolserver-l] all about a pure sql script

[Mashiah Davidson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20070616/434952fb/attachment.htm