Posted on behalf of The Anome:

I see that the Wikipedia dumps are now being generated using new infrastructure, and the old dumps have fallen into disrepair. Unfortunately, this includes the production of the SQL metadata files that contain the page-to-category mappings needed to drive my bot, so The Anomebot2 is now on indefinite hiatus again until this gets fixed. There is simply no way I can handle the entire XML dumps, with their terabytes of text, and I shouldn't need to anyway if the developers get their act together. I imagine I'm not the only bot operator in this situation.

Can someone on the development team fix this?

The specific SQL files I use are enwiki-[date]-page.sql.gz and enwiki-[date]-categorylinks.sql.gz, as can be found for example here: https://dumps.wikimedia.org/enwiki/20260101/ "

More discussion at https://en.wikipedia.org/wiki/Wikipedia:Bots/Noticeboard#SQL_files_no_longer_being_generated