Clean up >400K attachments
Had over 10k at one time, which is no where near the number you're talking. Pre-upgrade, our board was 1806 - had a devil's time cleaning up about 11GB of attachments.
If I remember right, one strategy I used was searching by download count - sorted ascending. Seems to me files without a poster or thread associated would be auto-selected for deletion. I just deleted them, then always seemed to be able to run orphaned attachments. Which could be a number/resource thing.
Since you control the number of results per page - might be worth experimenting. Running the query shouldn't do any harm. Until someone from MyBB weighs in with a better answer.
good luck...
If I remember right, one strategy I used was searching by download count - sorted ascending. Seems to me files without a poster or thread associated would be auto-selected for deletion. I just deleted them, then always seemed to be able to run orphaned attachments. Which could be a number/resource thing.
Since you control the number of results per page - might be worth experimenting. Running the query shouldn't do any harm. Until someone from MyBB weighs in with a better answer.
good luck...