On 16/06/07, Mashiah Davidson <[EMAIL PROTECTED]> wrote: > Robert, > > this looks good but where can I read about this? > > 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 > >
You can't really read about having a database - you just have one :P Anyway, http://meta.wikimedia.org/wiki/Toolserver may be of help. Sorry for top posting by the way, I will try not to let it happen again. -- Robert http://roberthl.wikitest.co.uk/ _______________________________________________ Toolserver-l mailing list [email protected] http://lists.wikimedia.org/mailman/listinfo/toolserver-l
