Robert, I was not too smart asking my previous question. Now it is obvious for me how to use my own database and fortunately I also have reading rights to other databases when use my own one.
Thank you a lot. Mashiah 2007/6/16, Robert Leverington <[EMAIL PROTECTED]>:
On the toolserver you are given your own database, this may be of help. On 16/06/07, Mashiah Davidson <[EMAIL PROTECTED]> 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 > [email protected] > http://lists.wikimedia.org/mailman/listinfo/toolserver-l > > -- Robert http://roberthl.wikitest.co.uk/ _______________________________________________ Toolserver-l mailing list [email protected] http://lists.wikimedia.org/mailman/listinfo/toolserver-l
_______________________________________________ Toolserver-l mailing list [email protected] http://lists.wikimedia.org/mailman/listinfo/toolserver-l
