Robert,<br><br>this looks good but where can I read about this?<br><br>Mashiah<br><br><div><span class="gmail_quote">2007/6/16, Robert Leverington <<a href="mailto:lcarsdata@googlemail.com">lcarsdata@googlemail.com</a>>:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On the toolserver you are given your own database, this may be of help.<br><br>On 16/06/07, Mashiah Davidson <
<a href="mailto:mashiah.davidson@gmail.com">mashiah.davidson@gmail.com</a>> wrote:<br>> I have created a pure sql script<br>> (<a href="http://ru.wikipedia.org/wiki/%D0%A3%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA:Mashiah_Davidson/toolserver">
http://ru.wikipedia.org/wiki/%D0%A3%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA:Mashiah_Davidson/toolserver</a><br>> ) for orphaned articles collection according to Russian wikipedia rules.<br>><br>> This script cannot be run as is on the toolserver because it creates some
<br>> new temporary tables during execution, so my primary goal is to understand<br>> how can I adapt this script to run on the toolserver. May be it is a way to<br>> create my own little database and grant me writing rights on it or maybe
<br>> there is some other ways to work it out without rewriting it in perl or<br>> python and working with hashes instead of sql tables.<br>><br>> One more thing, I am ok with running the script on my local machine but I
<br>> need an sql dump of some tables for this. Maybe there is a way to create a<br>> little dump for tables I need on the toolserver on a daily basis instead of<br>> waiting during two-three weeks when the dump of ruwiki will be available
<br>> again. I tried to dump a table on the toolserver without any success because<br>> this requires table locking and I again have no rights for this. Is there a<br>> way to create an sql dump without locking a table? I tried
<br>> '--skip-lock-table' option but got the following message:<br>><br>> mysqldump: Couldn't execute 'show create table `...`': SHOW VIEW command<br>> denied to user '...' for table '...' (1142)
<br>><br>> Please advise.<br>><br>> Mashiah Davidson<br>><br>> _______________________________________________<br>> Toolserver-l mailing list<br>> <a href="mailto:Toolserver-l@lists.wikimedia.org">
Toolserver-l@lists.wikimedia.org</a><br>> <a href="http://lists.wikimedia.org/mailman/listinfo/toolserver-l">http://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>><br>><br><br><br>--<br>Robert<br><a href="http://roberthl.wikitest.co.uk/">
http://roberthl.wikitest.co.uk/</a><br><br>_______________________________________________<br>Toolserver-l mailing list<br><a href="mailto:Toolserver-l@lists.wikimedia.org">Toolserver-l@lists.wikimedia.org</a><br><a href="http://lists.wikimedia.org/mailman/listinfo/toolserver-l">
http://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br></blockquote></div><br>