[weewx-user] Re: migrate an sql DB to another machine?

On Thursday, August 30, 2018 at 2:15:25 PM UTC-7, Eric Gammeter wrote: > > Thanks all- I think I misread/misunderstood the size of the original sdb > file- I thought it was big enough to contain all the archived data for the > year- I expected it to have all the 2018 data- but it didn't turn

[weewx-user] Re: migrate an sql DB to another machine?

Thanks all- I think I misread/misunderstood the size of the original sdb file- I thought it was big enough to contain all the archived data for the year- I expected it to have all the 2018 data- but it didn't turn out that way. End of this story. /Eric On Tuesday, August 28, 2018 at

[weewx-user] Re: migrate an sql DB to another machine?

On Thursday, August 30, 2018 at 11:40:18 AM UTC-7, Eric Gammeter wrote: > > > Thank you Vince- I get the following reply: > bash: syntax error near unexpected token `| > > oops - put the semi-colon inside the quotes before the close quote... echo "select

[weewx-user] Re: migrate an sql DB to another machine?

Thank you Vince- I get the following reply: bash: syntax error near unexpected token `| On Tuesday, August 28, 2018 at 11:31:27 AM UTC-4, Eric Gammeter wrote: > > Hi- > > I have been running weewx 3.8.2-1 for a year on my main debian PC- It ran > SQL and created a weewx.sdb file

[weewx-user] Re: migrate an sql DB to another machine?

On Wednesday, August 29, 2018 at 2:18:11 PM UTC-7, Eric Gammeter wrote: > > OK Thanks Pat and Tom!I got the sdb file migrated over from the old PC > onto my RPi PC- it is working and recording new data just fine: HOWEVER > (you knew that was coming didn't you?) I am *not* seeing any of

[weewx-user] Re: migrate an sql DB to another machine?

OK Thanks Pat and Tom!I got the sdb file migrated over from the old PC onto my RPi PC- it is working and recording new data just fine: HOWEVER (you knew that was coming didn't you?) I am *not* seeing any of the weather data for January 2018 thru July 2018. Curious. I have no idea what

Re: [weewx-user] Re: migrate an sql DB to another machine?

I would add that sqlite files are supposed to be portable across all machines , including big- and little-endian, 32- and 64-bit. So, as Pat says, it's just a simple matter of moving your file. -tk On Tue, Aug 28, 2018 at 9:37 AM Pat wrote: > The sdb file

[weewx-user] Re: migrate an sql DB to another machine?

The sdb file is sqlite. If you want to verify, you could install the sqlite3 tool and run this command echo .tables | sqlite3 weewx.sdb weewx only supports sqlite and mysql. Double check to make sure which database you are using by checking weewx.conf, [DataBindings] [[wx_binding]] database.

[weewx-user] Re: migrate an sql DB to another machine?

The sqlite sdb file can be moved just like any normal file. Stop weewx first, then copy the file to the new machine, and start weewx on the new machine after its copied. It should work right away. Check the logs to make sure. Always smart to keep a backup copy of the database just in case