[Toolserver-l] mysqldump

[River Tarnell]

-----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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (SunOS)

iEYEARECAAYFAkjqofUACgkQIXd7fCuc5vLieQCeJO2kt06FnIUPEyzgNA1O8DhF
qu0An0tC5y1VD3SzI8IY2m8Dn5NdqLQC
=z3FE
-----END PGP SIGNATURE-----