User:Tegnosis/Clearing Watchlists

When we need to clear a wiki editors watchlist to prevent their email from filling up with change notificaitons, use the folllowing proceedure:

Steps

 * 1) Log onto the wiki server
 * 2) Find the pods:
 * 3) Log into the database pod (for example  )
 * 4) Log into MySQL:
 * 5) For all the language wikis (i.e. de, en, es, fr, it, pt, ru, & sv) perform the following steps:
 * Note: To get the list of users in the right format, see the regex below
 * 1) For all the language wikis (i.e. de, en, es, fr, it, pt, ru, & sv) perform the following steps:
 * Note: To get the list of users in the right format, see the regex below
 * Note: To get the list of users in the right format, see the regex below
 * Note: To get the list of users in the right format, see the regex below
 * Note: To get the list of users in the right format, see the regex below

Regex
The list of users is usually from a spreadsheet, to get them into the right format for MySQL ('Name_1', 'Name_2', etc.), use the following Regex: And this to make sure there aren't any weird characters (deal with them as needed):
 * Find:
 * Replace: