Thread:Project:Support desk/how to empty a too large watchlist ?/reply

Hi!

Can't you use the API to first get a few watched pages and then remove them from your watchlist? Repeat until all pages are gone.

The other option would be to ask someone with direct database access, if he can run a MySQL query, which removes all your watched rows from the DB. This query might look something like

DELETE FROM watchlist WHERE `wl_user` = ;

The user id of your bot seems to be "346772", see here: http://fr.wikipedia.org/w/api.php?action=query&list=allusers&aufrom=HerculeBot&aulimit=1

I think the direct MySQL query will be much faster.