I replied off-list by mistake, no need for anybody else to follow up. On Saturday, 26 January 2019 02:40:20 UTC+10, Cycle London wrote: > > 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.
