Actually I found this: https://groups.google.com/d/msg/weewx-user/SYn7UIpSqKo/Zs_gAz4C-bcJ And this: https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL
@Tom is it still valid for the new 3.7? PS: I think we are heading out of the original context. This will be my last post in the thread. Will wait for your answers but I will continue in a different new/existing thread. Thank you for you great help. On Wednesday, March 15, 2017 at 1:30:02 AM UTC+2, Theophanis Kontogiannis wrote: > > Thank you. > > Anything more specific on point 5 (schema matching between SQLite / MySQL > - special converting software needed)? :) > > Seriously, should I look for conversion between SQLite and MySQL? > > > > > >> the first part is trivial. >> >> 1) create a mount point >> >> sudo mkdir /var/weewx >> >> 2) create a tmpfs by adding an entry to fstab: >> >> echo "weewx /var/weewx tmpfs=100M,noexec,nosuid,nodev 0 0" | sudo tee -a >> /etc/fstab >> >> 3) mount the filesystem >> >> sudo mount -a >> >> 4) modify weewx.conf to put the weewx database on the tmpfs >> >> [DatabaseTypes] >> [[SQLite]] >> driver = weedb.sqlite >> SQLITE_ROOT = /var/weewx >> >> the second part will take a bit more work. you'll have to find/write >> something that periodically queries the sqlite database and inserts the >> results into the database on the RAID filesystem. >> >> m >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
