I'd like to request that selected parts of the user table be included in the dumps for statisticical purposes, namely the user_id, user_name and user_options fields. It would be useful to have this data to collect statistics on what parts of the preferences are actually being used, and being able to compare this with the user_id (and user_name) field would enable checking for what settings regular editors have and how many change their default settings and so on.
And before people get all up in arms about this then no, this does not include your email or the hash of your password (those are in user_email and user_password respectively).
Ævar Arnfjörð Bjarmason wrote in gmane.science.linguistics.wikipedia.technical:
I'd like to request that selected parts of the user table be included in the dumps for statisticical purposes, namely the user_id, user_name and user_options fields.
does mysqldump have support for dumping only certain columns?
And before people get all up in arms about this then no, this does not include your email or the hash of your password (those are in user_email and user_password respectively).
i have no particular opinion, but i suspect some people would object to preferences being included in dumps.
kate.
If it's for purely statistical purposes, what do you need the user_id and user_name for?
-- Austin
I found a way to export just that column which I think people will find acceptable, and will still be useful for any statistic work:
$ mysql -u user --password=pass -D db -s -e "SELECT concat(user_options,'==',user_options) FROM user" > user_options.dump
It would be great if someone with mysql access could do that and give me the resulting file
wikitech-l@lists.wikimedia.org