Robert,
this looks good but where can I read about this?
Mashiah
2007/6/16, Robert Leverington <lcarsdata(a)googlemail.com>om>:
On the toolserver you are given your own
database, this may be of help.
On 16/06/07, Mashiah Davidson < mashiah.davidson(a)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%…
> ) 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(a)lists.wikimedia.org
>
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
--
Robert
http://roberthl.wikitest.co.uk/
_______________________________________________
Toolserver-l mailing list
Toolserver-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
_______________________________________________
Toolserver-l mailing list
Toolserver-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
may be of help.
Sorry for top posting by the way, I will try not to let it happen again.
--
Robert