mysqldump

List overview All Threads
Download

newer

older

Re: [Toolserver-l] Toolserver-l...

downtime today (04 Oct): zedler,...

Mauro Girotto

6 Oct 2008 6 Oct '08

8:30 a.m.

Hi, I need to make a dump of "page" table (enwiki db) but I'm having a problem. I use the mysqldump utility: mysqldump --skip-lock-tables -u <user> -p -h sql-s1 enwiki_p page > dump.sql dump.sql contains only the table structure, no data. Where do I go wrong? Thanks! Mauro

Show replies by date

DaB.

6 Oct 6 Oct

12:39 p.m.

Hello, Am Monday 06 October 2008 17:30:24 schrieb Mauro Girotto:

...

I need to make a dump of "page" table (enwiki db)

don't do this. It need too many resources in any way. If you need a file for grep, so a downloaded dump, if you need live-data, use mysql. Sincerly, DaB. -- wp-blog.de

Mauro Girotto

1:15 p.m.

2008/10/6 DaB. <WP(a)daniel.baur4.info>fo>:

...

don't do this. It need too many resources in any way. If you need a file for grep, so a downloaded dump, if you need live-data, use mysql.

I need to make a query between itwiki_p (sql-s2) and enwiki_p (sql-s1). Is it possible? I think I need to download an ufficial dump and make query on my pc. Mauro

Mashiah Davidson

1:54 p.m.

It is possible, but with some glue. I do that in my Golem using just bash and sql scripting. You can see the self-documented source here: https://fisheye.toolserver.org/browse/golem/isolated Start with handle.* Mashiah 2008/10/7 Mauro Girotto <mauro742(a)gmail.com>

...

2008/10/6 DaB. <WP(a)daniel.baur4.info>fo>:

don't do this. It need too many resources in any way. If you need a file

for

grep, so a downloaded dump, if you need live-data, use mysql.

I need to make a query between itwiki_p (sql-s2) and enwiki_p (sql-s1). Is it possible? I think I need to download an ufficial dump and make query on my pc. Mauro _______________________________________________ Toolserver-l mailing list Toolserver-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/toolserver-l

Aryeh Gregor

4:52 p.m.

On Mon, Oct 6, 2008 at 4:15 PM, Mauro Girotto <mauro742(a)gmail.com> wrote:

...

I need to make a query between itwiki_p (sql-s2) and enwiki_p (sql-s1). Is it possible? I think I need to download an ufficial dump and make query on my pc.

Why can't you just run the query across databases? What query are you trying to run?

Daniel Schwen

5:54 p.m.

...

> I need to make a query between itwiki_p (sql-s2) and enwiki_p > (sql-s1). Is it possible? I think I need to download an ufficial dump

...

Why can't you just run the query across databases? What query are you trying to run?

Cross-database queries I know, but cross-server queries are new to me. Is that even possible? -- [[en:User:Dschwen]] [[de:Benutzer:Dschwen]] [[commons:User:Dschwen]]

Aryeh Gregor

6:03 p.m.

On Mon, Oct 6, 2008 at 8:54 PM, Daniel Schwen <lists(a)schwen.de> wrote:

...

Cross-database queries I know, but cross-server queries are new to me. Is that even possible?

Ah, I see. The databases are on different servers. I don't know how you'd be able to do that, no, not without a lot of manual work.

Bryan A. P. Pendleton

6:51 p.m.

I'm just a lurker here, so I don't know if the toolserver machine is running a recent enough MySQL, but there is a table type called the "federated" table, see http://dev.mysql.com/doc/refman/5.0/en/federated-use.html For the most part, this makes it possible to use a remote table that you have access to in SQL commands in the same way one might normally use a local one. -- Bryan A. P. Pendleton On Mon, Oct 6, 2008 at 9:03 PM, Aryeh Gregor <Simetrical+wikilist@gmail.com<Simetrical%2Bwikilist@gmail.com>

...

wrote:

> On Mon, Oct 6, 2008 at 8:54 PM, Daniel Schwen <lists(a)schwen.de

...

wrote:

> > Cross-database queries I know, but cross-server queries are new to me. Is > that > > even possible? > > Ah, I see. The databases are on different servers. I don't know how > you'd be able to do that, no, not without a lot of manual work. > > _______________________________________________ > Toolserver-l mailing list > Toolserver-l(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/toolserver-l >

River Tarnell

7:25 p.m.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bryan A. P. Pendleton:

...

For the most part, this makes it possible to use a remote table that you have access to in SQL commands in the same way one might normally use a local one.

except that it's _much_ slower than local databases. too slow for the sort of queries (joins, for example) that people would want to use it for. - river.

...PGP SIGNATURE...

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (SunOS) iEYEARECAAYFAkjqyJkACgkQIXd7fCuc5vKHXQCbBQGOFZy+0JPpKckoiDBLPIs7 UoAAn05lsFOyNXLwNnZu45MGP7AT0snM =JczS -----END PGP SIGNATURE-----

Mauro Girotto

7 Oct 7 Oct

1:44 a.m.

2008/10/7 River Tarnell <river(a)wikimedia.org>rg>:

...

except that it's _much_ slower than local databases. too slow for the sort of queries (joins, for example) that people would want to use it for.

I decide to make the query local using the ufficial dump. Thanks for your support! Mauro

Mauro Girotto

1:39 a.m.

2008/10/7 Aryeh Gregor <Simetrical+wikilist(a)gmail.com>om>:

...

Why can't you just run the query across databases? What query are you trying to run?

I want to view the pages with the same title in itwiki and enwiki without interlink it -> en

River Tarnell

6 Oct 6 Oct

4:40 p.m.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mauro Girotto:

...

I need to make a dump of "page" table (enwiki db) but I'm having a problem. I use the mysqldump utility: mysqldump --skip-lock-tables -u <user> -p -h sql-s1 enwiki_p page > dump.sql

...

dump.sql contains only the table structure, no data. Where do I go wrong?

enwiki_p.page is not a table, but a view. mysqldump (correctly) dumps the view definition only. if you wanted the data, you would have to dump the page table (enwiki.page), but for privacy reasons, these tables are not visible to users. - river.

...PGP SIGNATURE...

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (SunOS) iEYEARECAAYFAkjqofUACgkQIXd7fCuc5vLieQCeJO2kt06FnIUPEyzgNA1O8DhF qu0An0tC5y1VD3SzI8IY2m8Dn5NdqLQC =z3FE -----END PGP SIGNATURE-----

5704

days inactive

5705

days old

toolserver-l@lists.wikimedia.org

Manage subscription

11 comments

7 participants

tags (0)

participants (7)

Aryeh Gregor
Bryan A. P. Pendleton
DaB.
Daniel Schwen
Mashiah Davidson
Mauro Girotto
River Tarnell