Truncating Database

Development questions: create new plugins, add new features...
Post Reply
Fahd
Posts: 4
Joined: Thu Jul 20, 2017 9:12 am
Company: vision valley

Truncating Database

Post by Fahd » Sun Jan 06, 2019 12:21 pm

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

libelium-dev
Posts: 27967
Joined: Mon Sep 28, 2009 1:06 pm

Re: Truncating Database

Post by libelium-dev » Tue Jan 08, 2019 10:12 am

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

Fahd
Posts: 4
Joined: Thu Jul 20, 2017 9:12 am
Company: vision valley

Re: Truncating Database

Post by Fahd » Wed Jan 09, 2019 7:21 am

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 ?

libelium-dev
Posts: 27967
Joined: Mon Sep 28, 2009 1:06 pm

Re: Truncating Database

Post by libelium-dev » Thu Jan 10, 2019 9:23 am

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

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests