On Wed, Sep 28, 2011 at 3:27 AM, K. Mueller melvin_mm@gmx.de wrote:
Platonides <Platonides <at> gmail.com> writes:
Do doing things the slow way: mysql> SELECT COUNT(*) FROM revision; | 416988781 |
Thanks, this is quite close to the result from September 1st ( 412,482,641 ). I assume that the contents of the "revision" table go into the pages-meta-history dumps..? And I reckon that there is no safe method to verify the result, though.
The pages-meta-history dump (with text) is produced from the pages-meta-history _stub_ dump, which is basically just a thin XML shell around a big query to the database on the 'page' and 'revision' tables.
In theory, anything missing from the stub dump should be something that's not properly recorded at all -- for instance a revision that is not attached to a live page. This isn't supposed to happen but there probably are a few stray ones in the database. :)
-- brion