Hi Cameron, Thanks for this. Just snapshotting my VMs as we speak, and then going to try the flip. One thing ...
*** irst, verify that the MySQLdb python package is installed: python -c "import MySQLdb" If this results in an import error ImportError: No module named MySQLdb then install the MySQLdb package. *** Is that on the weewx VM or on the database VM? Neither actually has it. Both are CentOS. I'll need to install but on which? I actually downloaded the DB Browser for SQL lite. A curious thing happened. Quite interested to see all the fields that are not being used. Soil temperature, etc. I think I might need to invest in some new kit... :-) On Tuesday, 22 January 2019 12:49:57 UTC, Cameron D wrote: > > 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.
