Right, I don't think I'd have issues deleting them in phpMyAdmin. However, isn't it more complex than just deleting the old posts? Like my first post said... I think I'd be leaving remnants unless I also deleted from the search index table (I think there's two or three of these?), the polls, attachments, posts table, threads table, etc.
Well, the limits in phpMyAdmin may be why the others used shell scripts to access the database. If I can only delete 10,000 at a time, I have to do 200 batches... and that would be 200 times the number of tables. So, a script would be a lot better than sitting here all day waiting and clicking another batch. I could probably do way more than 10,000 though.
|
11-25-2010, 05:25 AM
Threaded Mode