It won't take you long at all. I have done more complex transfers from sqlite3 to mysql and I haven't been trained in any IT system - sorry, I was taught Fortran IV, but I don't think that counts.
Mysql has a far richer function and capability set so if you intend doing anything more than what weewx can do already then I would think you will be better off with mysql/Mariadb. If the command line syntax is a bit obscure, the DB Browser for sqlite (http://sqlitebrowser.org/) is a fine multiplatform gui. Export the table definitions to file, check over and import into mysql. then export data, check over and then import. For the other database I converted, I needed to edit around several incompatibilities between the sql syntax, but a few cycles of import, crash, edit fixed that. The weewx db is so simple I don't expect there will be any compatibility problems. Cameron. On Tuesday, 22 January 2019 00:13:01 UTC+10, Cycle London wrote: > > Apologies - by 'the GUI' I mean the weewx web frontend. > > I reckon it's about time I moved to MySQL. That involves raising a > change - which in my case, means asking my wife if she has anything planned > the weekend after next. :-) > > > -- 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.
