On 9/13/07, Brion Vibber brion@wikimedia.org wrote:

Yousef Ourabi wrote:

...

I've been looking at the *-page.sql dump from wikipedia, I'm now intersted in looking at the recentchanges table, can anyone point out which of the sql dumps (if any) contains that table?

None, we don't make it available as

a) it's primarily duplicates of other tables' data

b) it contains private data (IP addresses of editors etc)

The only way to get the public information would be to filter stub-meta-history.xml for the most recent edits, right?

Or, I guess you could get it from pages-meta-history.xml also, if that file was ever successfully dumped.