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%B...) 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
On the toolserver you are given your own database, this may be of help.
On 16/06/07, Mashiah Davidson mashiah.davidson@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%B... ) 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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Robert,
this looks good but where can I read about this?
Mashiah
2007/6/16, Robert Leverington lcarsdata@googlemail.com:
On the toolserver you are given your own database, this may be of help.
On 16/06/07, Mashiah Davidson mashiah.davidson@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%B...
) 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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-- Robert http://roberthl.wikitest.co.uk/
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
On 16/06/07, Mashiah Davidson mashiah.davidson@gmail.com wrote:
Robert,
this looks good but where can I read about this?
Mashiah
2007/6/16, Robert Leverington lcarsdata@googlemail.com:
On the toolserver you are given your own database, this may be of help.
On 16/06/07, Mashiah Davidson < mashiah.davidson@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%B...
) 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@lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-- Robert http://roberthl.wikitest.co.uk/
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Toolserver-l mailing list Toolserver-l@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,
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@googlemail.com:
On the toolserver you are given your own database, this may be of help.
On 16/06/07, Mashiah Davidson mashiah.davidson@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%B...
) 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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-- Robert http://roberthl.wikitest.co.uk/
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
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@googlemail.com:
On the toolserver you are given your own database, this may be of help.
On 16/06/07, Mashiah Davidson mashiah.davidson@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%B...
) 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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
-- Robert http://roberthl.wikitest.co.uk/
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
toolserver-l@lists.wikimedia.org