>>
|
No. 70931
File
136422101512.jpg
- (67.46KB
, 1024x576
, snapshot20090616152049.jpg
)
>>70929
There should be a less destructive way to do this.
The database stores md5 information for each file attached to a post, so it would be possible to query for all posts with matching md5s, delete all the attached files except the originals, and then point all the duplicates to those originals.
Some images here have been posted hundreds if not thousands of times, and each duplicate post of it actually creates two - the thumbnail and the full image. They are the real problem, getting rid of the threads creates more of an issue if it becomes possible later to restore the files. This should be completely possible to implement, but the question is whether anyone is capable of doing it.
Failing working that, you can just download the src folders for each board, which is where the attached files are stored. After doing that you could delete everything from say 2011, and add back files that are needed. This doesn't change the database in any way so it's easy to add back whatever you delete. It's just a matter of taking files in and out of a folder.
|