Page 1 of 1

Truncating Database

Posted: Sun Jan 06, 2019 12:21 pm
by Fahd
Hi There
I am using mehslium 3 for one of my project it works fine but after some time like in month its memory got full and it stop syncing data in database so i have to manually remove all content in data base in Capture Tab to make it sending data to our cloud server. Is there any way to clear database of meshlium after some time automatically.

Thank You
Regards Fahd Zafar

Re: Truncating Database

Posted: Tue Jan 08, 2019 10:12 am
by libelium-dev
Hi,

There isn't any predefined way to do that but Meshlium is a computer, you can access by ssh to Meshlium and make a script to clear database after some time automatically.

Regards

Re: Truncating Database

Posted: Wed Jan 09, 2019 7:21 am
by Fahd
Hi
Thank you for replying Can you please let me know how can i achieve this (i.e. How to clear database and which commands to use).
Can I use Cron Schedule to run the script in meshlium ?

Re: Truncating Database

Posted: Thu Jan 10, 2019 9:23 am
by libelium-dev
Hi,

We are sorry but we can't provide support about topics outside of normal use of Meshlium. Anyway, database is a mysql db, you can remove data using sql sentences.

Regards