Reducing The Size Of MyPHP Database (ES Stream Trash)

Hi Stackideas

This is kind of related to this here:

http://stackideas.com/forums/reducing-the-size-of-myphp-database-eb-blog-revisions

They have given me until Friday to get this under control.


finalbug_NOT-REAL-NAME fbug_easyblog_revisions 363.59
finalbug_NOT-REAL-NAME fbug_social_stream_item 102.53
finalbug_NOT-REAL-NAME fbug_social_mailer 96.76
finalbug_NOT-REAL-NAME fbug_finder_terms 55.44
finalbug_NOT-REAL-NAME fbug_social_notifications 24.36
finalbug_NOT-REAL-NAME fbug_finder_links 16.17
finalbug_NOT-REAL-NAME fbug_finder_links_terms8 9.08
finalbug_NOT-REAL-NAME fbug_finder_links_terms0 7.09
finalbug_NOT-REAL-NAME fbug_finder_links_termse 7.08
finalbug_NOT-REAL-NAME fbug_finder_links_terms4 5.14
finalbug_NOT-REAL-NAME fbug_social_points_history 4.43
finalbug_NOT-REAL-NAME fbug_social_privacy_items 4.21
finalbug_NOT-REAL-NAME fbug_social_stream 3.88
finalbug_NOT-REAL-NAME fbug_admintools_filescache 3.52
finalbug_NOT-REAL-NAME fbug_easyblog_post 3.44
finalbug_NOT-REAL-NAME fbug_social_fields_data 3.12


In short my data base is getting huge and I would like to shrink it.

It is 95% trash any way ;-)

When I go to the ES Back end there is a menu down at the bottom left for “Stream”

I can go in there and seem to have literaly thousands of items that I could trash.

I have tried selecting about 500 items and trashing them.

Thing is that when I set the “Select State” filter to “Trashed” I still see these items.

Which makes me think that they are in a trash can but not thrown away?

I have 100MB of Stream items and I have no problem throwing every thing apart from lets say the last 100 items out!

Please advise

thanks

Paul

Do I need to do something like this?

http://stackideas.com/forums/db-query-to-delete-stream-items-for-specific-user