Just as a safety net I'd like to publish copies of the databases
powering my MediaWiki installations, so that if I lose all my data and
backups, I might still be able to get something back (as well as
reassuring my users that their contributions won't be lost forever!)
I don't want to publish the raw database dump because it contains
people's e-mail addresses and password hashes, but I'm thinking that
perhaps if I take a copy of the database and erase the values in those
tables, I might be able to export and publish the 'anonymised' copy.
I'd rather not omit the user table entirely, because if I do ever need
to restore the wiki from this copy I'll need it to associate the right
account with each edit.
Does anyone know which fields contain sensitive data that I should
remove? I can see these obvious candidates:
Are there any others that are potentially confidential and should not
be made public?