Step 1 :
- Clean admin, moderator, and change logs
- Execute SQL Commands via phpMyadmin :
Code:
TRUNCATE `xf_admin_log`;
TRUNCATE `xf_change_log`;
TRUNCATE `xf_moderator_log`;
- Unfortunately pruning conversations might cause problems, there is specific plugins for that called "Conversation Tools" , and still not sure how to clean expired user upgrades logs.