Clean the table mainwp_stream_meta in bulk from MainWP panel

Support
1

Hi,
I see i can clean the tables for child reports on each website.
But is it possible to clean them from the central MainWP panel?

2

Hi @sierinkwp

Unfortunately, this is not possible with MainWP out-of-the-box.

However, you are most likely able to trigger the reset of the Database on the Child Site using our Bulk Settings Manager extension.
image

The documentation for the extension is available here: Bulk Settings Manager - MainWP Documentation

There you will also find examples with complete step-by-step instructions. Test on staging site first, if possible.

1 Like
3

I would vote for this being a really helpful feature to add to the MainWP panel!

4

is it possible to post a key which will clean these database tables? So we can import in the bulk settings manager?
I am fiddling with this for half a day now…
Would be nice to just have a setting to clean these tables.

5

This key should be able to reset the database:

-----BEGIN BULK SETTINGS MANAGER KEY-----
N2NhNDcwOTk2MmY1MGQ0NWQ4NWI0ZDhkODY3Y2ZlZWRlYzFkMzU2NXxmaWVsZF90eXBlPXNldHRpbmdzX2ZpZWxkJnNldHRpbmdzX2ZpZWxkX25hbWU9Y2xlYXIrREImc2V0dGluZ3NfZmllbGRfdXJsPXdwLWFkbWluJTJGYWRtaW4tYWpheC5waHAmZmllbGRfdHlwZT10ZXh0X2ZpZWxkJnRleHRfZmllbGRfZGVzY3JpcHRpb249d3BfbWFpbndwX3N0cmVhbV9yZXNldCZ0ZXh0X2ZpZWxkX25hbWU9YWN0aW9uJnRleHRfZmllbGRfdmFsdWU9d3BfbWFpbndwX3N0cmVhbV9yZXNldCZ0ZXh0X2ZpZWxkX3R5cGU9Z2V0JmZpZWxkX3R5cGU9bm9uY2VfZmllbGQmbm9uY2VfZmllbGRfbmFtZT1zdHJlYW1fbm9uY2VfcmVzZXQmbm9uY2VfZmllbGRfYXJnPXdwX21haW53cF9zdHJlYW1fbm9uY2VfcmVzZXQ=
-----END BULK SETTINGS MANAGER KEY-----

And the instructions for making a key are here: Create a Single Key - MainWP Documentation

Please let us know if that works.

6

I created the key, and ran it on all sites. Then did a sync. But according to the mainwp dashboard/reports extension the databases are not empty.

7

The label of the column “Reports DB size” on the Pro Reports > Dashboard page is not completely accurate. It shows the value of the entire DB and not just the tables related to Pro Reports.

We will have that renamed in the next version of Pro Reports.

To verify that the BSM key worked and that the Reports database was actually cleared, you’d have to check directly on the WP Admin of the child site on Settings > MainWP Child > CHILD REPORTS page.

8

I’ll check but most tables are >300mb

9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.