That's ok! It is only marginally slower than wee-database for making the 'big' initial transfer.
Because it was so slow (for both) I actually installed mysql locally, and used wee-database --transfer to make the initial transfer. Note: I could not get wee-database to work using "localhost" as the hostname. It worked fine as soon as I used my local IP address instead. Not sure what was going on there but it stumped me for awhile. Anyway, it was made the transfer in just a few minutes, then I dumped the database with mysqldump, transferred to my remote server, again, much faster over sftp :)... and then imported it into the database on the remote server. That took care of the speed issue. Then your wee_dbbackup script worked just fine dandy and speed is was not an issue of course with just a couple records. I do like your suggestion in the notes on setting up a 'read-only' user on the main weewx SQLite database. How do I do that? Cheers! Chris On Saturday, January 6, 2018 at 10:43:11 PM UTC-8, ln77 wrote: > > 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 <[email protected] <javascript:>> > wrote: > > 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 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 mysql destination can be whatever you want; in particular, “weewx” >>> would work fine if you’ve got another weewx installation reading from that >>> db. >>> >>> -Les >>> >>> > -- > 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] <javascript:>. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
