I want to clear everyones mailbox, if I empty this ow_mailbox_message from the database will it clear the messages. This table has grown to over 100MB, my goal is to empty the old data to make the DB faster
If someone could confirm this that would be great
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
ow_mailbox_message | Forum
Team
Abbey
Jun 25 '15
Is there a way to clear old data but not all data? like say anything over 3 months old?
Hadi Kamell
Jun 25 '15
every message have an ID (this id is set by the date). just find a message from that date and find it at database and read its ID and then..
you can delete fields that are after this ID number.
you can delete fields that are after this ID number.
The Forum post is edited by Hadi Kamell Jun 25 '15
Team Taissa
Jun 30 '15
Abbey, in this case you will need to develop your own plugin because there is no such default functionality.
If you are not familiar with the plugin development, it would be better for you to find a developer who can help you. You can do it here: http://www.oxwall.org/market/specialists
Also you can make a suggestion on uservoice: http://oxwall.uservoice.com/forums/13756-ideas-for-oxwall
If you are not familiar with the plugin development, it would be better for you to find a developer who can help you. You can do it here: http://www.oxwall.org/market/specialists
Also you can make a suggestion on uservoice: http://oxwall.uservoice.com/forums/13756-ideas-for-oxwall
Hadi Kamell
Jul 1 '15
I was hoping for something less manual than doing 500 at a time
you can make an easy query by excel !
Abbey
Jul 4 '15
I was hoping for something less manual than doing 500 at a time
you can make an easy query by excel !
I'm not that clever
