Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Question: I'm using mwall's realtime Cumulus extension to produce text files from the loop data. Is there anything stopping that extension from outputting to mysql/sqlite bindings instead? Chris -- You received this message because you are subscribed to the Google Groups "weewx-user"

Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Yup, I should’ve mentioned that it’s not particularly fast. But that’s OK, it’s not well tested either. :) Let me know if it works out for you, and if any issues crop up. -Les > On 6 Jan 2018, at 19:23, Chris Alemany wrote: > > initial run is on the go... 11,000 of

Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

initial run is on the go... 11,000 of 1.2 million records already done. Gonna be a minute or 500 :) On Saturday, January 6, 2018 at 7:05:12 PM UTC-8, Chris Alemany wrote: > > Thanks! I'll let you know how it goes! > > On Saturday, January 6, 2018 at 6:51:03 PM UTC-8, ln77 wrote: >> >> Yes, I

Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Thanks! I'll let you know how it goes! On Saturday, January 6, 2018 at 6:51:03 PM UTC-8, ln77 wrote: > > Yes, I forgot to attach the conf file the first time. The attached has > examples for both mysql and sqlite, for both source & destination. For > mysql, the host, user, and password of

Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Yes,  I forgot to attach the conf file the first time.  The attached has examples for both mysql and sqlite, for both source & destination.  For mysql, the host, user, and password of course need to be filled in; likewise for the path(s) to the sqlite database file(s).  The database name for a

Re: [weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

I wrote a little tool for syncing weewx data from one database to another, which I think can address Chris’ cloning request.  It’s weewx-specific — when run, it copies all archive records from the source database that are later than the latest record in the destination database, to the destination

[weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

On Friday, January 5, 2018 at 11:06:27 AM UTC-8, Huw Pearce wrote: > > SQLite-sync - ampliapps.com > https://ampliapps.com/sqlite-sync/ > > > yeccch - requires tomcat and it's binary only cool idea though -- You received this message because you are

[weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Chris, You might like to look at the following: *Sqlite*-*sync* is a framework for synchronizing data between a *Sqlite* database and an MS SQL/*MySQL*/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated

[weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

Yes I for one use to just dump and save but when I decided to use mySql I also decided to use replication, which I set up on a QNAP NAS... it has worked without fault as a realtime backup of the db on my pi. Nev On Tuesday, January 2, 2018 at 9:05:08 AM UTC+10, vince wrote: > > On Monday,

[weewx-user] Re: Simultaneous clone to mySQL for weewx and weewx-WD?

On Monday, January 1, 2018 at 12:56:27 PM UTC-8, Chris Alemany wrote: > > Is it possible to have a concurrent 'clone' of the local database and a > remote database? > > Switching to mysql will get you that kind of functionality, albeit at the added complexity and compute capacity needs that