all about a pure sql script

List overview All Threads
Download

newer

older

national characters in database...

Returned mail: see transcript for...

Mashiah Davidson

17 Jun 2007 17 Jun '07

3:41 a.m.

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

Attachments:

attachment.htm (text/html — 1.5 KB)

Show replies by thread

Robert Leverington

17 Jun 17 Jun

3:44 a.m.

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/

Mashiah Davidson

4:01 a.m.

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

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

need an sql dump of some tables for this. Maybe there is a way to create

little dump for tables I need on the toolserver on a daily basis instead

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

Robert Leverington

4:31 a.m.

On 16/06/07, Mashiah Davidson <mashiah.davidson(a)gmail.com> wrote:

...

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

> 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

> need an sql dump of some tables for this. Maybe there is a way to create

> little dump for tables I need on the toolserver on a daily basis instead

> 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

_______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org 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/

Mashiah Davidson

4:36 a.m.

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 <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

need an sql dump of some tables for this. Maybe there is a way to create

little dump for tables I need on the toolserver on a daily basis instead

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

Merlijn van Deen

5:03 a.m.

The u_<username> database is all yours; you are able to do everything with it (except dropping it, maybe ;)). Replace <username> with your toolserver username, obviously. --valhallasw

...

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

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

_______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l

6158

days inactive

6158

days old

toolserver-l@lists.wikimedia.org

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

Mashiah Davidson
Merlijn van Deen
Robert Leverington