Mentioned in SAL (#wikimedia-operations) [2017-05-23T07:07:02Z] <marostegui> Rename gather_list gather_list_flag gather_list_item on db1078 db1094 and db1089 - T166097

I have renamed the tables on a few hosts and will leave them like that for a few days to make sure no errors appear.
They have been renamed to:

T166097_gather_list
T166097_gather_list_flag
T166097_gather_list_item

The hosts where they have been renamed:

testwiki, test2wiki, enwikivoyage -> s3 -> db1078

hewiki -> s7 -> db1094

enwiki -> s1 -> db1089

To revert these changes on those hosts:

rename table T166097_gather_list to gather_list;
rename table T166097_gather_list_flag to gather_list_flag;
rename table T166097_gather_list_item to gather_list_item;

I have backuped those tables on:

dbstore1001:/srv/tmp/T166097

In T166097#3285459, @Marostegui wrote:

I have backuped those tables on:

dbstore1001:/srv/tmp/T166097

Thanks.

Would it be possible to get access to those backups? I'd be interested in the public aspects of those database tables.
What permissions do I need?

Not the backups, but maybe public dumps could be generated? But that requires someone compromising to sanitize them.

If it is a one-time access, regular access requests workflow would be needed, with the same restrictions that other private data are. I do not know if that is private, but I am going to assume by default they are unless otherwise proven.

Mentioned in SAL (#wikimedia-operations) [2017-05-29T09:01:40Z] <marostegui> Drop gather tables from: testwiki, test2wiki, enwikivoyage, hewiki, enwiki - T166097