Updating the database

johnbanks · 26 November 2017 00:46

Is it possible to do this via SSH rather than via the browser & Administration?
Thx

pb66 · 26 November 2017 10:35

If you are running an emonpi you could try

php /home/pi/emonpi/emoncmsdbupdate.php

This how the emonpi updates the database after updating emoncms

github.com

openenergymonitor/emonpi/blob/master/emoncmsupdate#L312

    
      
          #!/bin/bash
          # REDIRECT FOR UPDATE TO NEW UPDATE PATH LOCATIONS
          # KEEP THIS FILE HERE FOR ALL UPDATED FROM OCT17 and OCT18 IMAGES
          DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
          usrdir=${DIR/\/emonpi/}
          $usrdir/emonpi/service-runner-update.sh all custom

here’s the script content

https://github.com/openenergymonitor/emonpi/blob/master/emoncmsdbupdate.php

CrisPastore · 26 December 2017 13:42

That worked.
Thanks a lot!
BR
Cris