Addshore added a comment.
The following can be used the generate a list of ids to run over once the
tables restored to the point before the drop.
addshore@stat1007:~$ analytics-mysql wikidatawiki -e "select DISTINCT
rc_title from recentchanges where rc_timestamp > 20200406230000 and
rc_namespace = 0 ORDER BY rc_cur_id ASC;" -N -B > T249596-3.list
addshore@stat1007:~$
addshore@stat1007:~$ head T249596-3.list
Q18
Q31
Q2
Q4
Q23
Q49
Q59
Q68
Q82
Q94
addshore@stat1007:~$ wc -l T249596-3.list
330814 T249596-3.list
TASK DETAIL
https://phabricator.wikimedia.org/T249596
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Liuxinyu970226, Addshore, Aklapper, Tarrow, Iflorez, darthmon_wmde,
alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
_jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher,
Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
