Hi Cameron, Thanks for the tips. I tried to respond direcrly to the address whence your mail originated, but it bounced.
On Fri, 25 Jan 2019 at 23:17, Cameron D <cgoo...@davidsoncj.id.au> wrote: > 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 a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
