Re: [weewx-user] merge two data base

[salinois]

hello Vince,

dis you see this message ?

thank

Patrick

Le 24/10/2023 à 20:27, salinois a écrit :


hello,

I successfully completed this ordercat old.dump.txt | sqlite3 
weewx.new.sdb without the double quotes


but after changing the rights on the file"sudo chmod 777 weewx.new.sdb";

I restarted weewx, and the old years appear in report *but no data in 
it*!!!


did I do something wrong?

Patrick

Le 24/10/2023 à 17:29, salinois a écrit :


hello Vince,

this command doesn't work !!

*"cat old.dump.txt | sqlite3 weewx.new.sdb"*

I try to find the good command

thanks

patrick*
*

Le 24/10/2023 à 01:08, vince a écrit :

"cat old.dump.txt | sqlite3 weewx.new.sdb"


--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/1782598b-6080-4fb3-9302-5d77969b548c%40gmail.com.

Re: [weewx-user] merge two data base

[salinois]

hello,

I successfully completed this ordercat old.dump.txt | sqlite3 
weewx.new.sdb without the double quotes


but after changing the rights on the file"sudo chmod 777 weewx.new.sdb";

I restarted weewx, and the old years appear in report *but no data in it*!!!

did I do something wrong?

Patrick

Le 24/10/2023 à 17:29, salinois a écrit :


hello Vince,

this command doesn't work !!

*"cat old.dump.txt | sqlite3 weewx.new.sdb"*

I try to find the good command

thanks

patrick*
*

Le 24/10/2023 à 01:08, vince a écrit :

"cat old.dump.txt | sqlite3 weewx.new.sdb"


--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/f4b7944e-5966-4648-be29-8c44b2ddbd97%40gmail.com.

Re: [weewx-user] merge two data base

[salinois]

hello Vince,

this command doesn't work !!

*"cat old.dump.txt | sqlite3 weewx.new.sdb"*

I try to find the good command

thanks

patrick*
*

Le 24/10/2023 à 01:08, vince a écrit :

"cat old.dump.txt | sqlite3 weewx.new.sdb"


--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/0f704f5f-61fe-499e-abe8-d7895d40eda9%40gmail.com.

Re: [weewx-user] merge two data base

[vince]

Try it please.

On Monday, October 23, 2023 at 2:33:35 PM UTC-7 salinois wrote:

> I found this in the mails from Vince;
>
> is it the good methode ?
>
> [I do it manually via dump and restore using sqlite3...
>
>- Stop weewx 
>- Make a copy of your old and new db and work off those copies 
>   - cp weewx.sdb  /var/tmp/weewx.new.sdb 
>   - cp your_old_weewx.sdb /var/tmp/weewx.old.sdb 
>   - cd /var/tmp 
>- Dump your old database's archive table to a file
>- echo ".dump archive" | sqlite3 weewx.old.sdb > old.dump.txt 
>- Restore that into your new database
>- "cat old.dump.txt | sqlite3 weewx.new.sdb" 
>   - (and ignore the 'table already exists' warning) 
>- Rebuild your daily summaries
>- rename your production weewx.sdb file to something else 
>   - copy the weewx.new.sdb built above into place as weewx.sdb in the 
>   directory weewx expects it in 
>   - sudo wee_database --rebuild-daily 
>- Start weewx] 
>
> thanks
>
>
> Patrick
> Le 23/10/2023 à 23:07, sali...@gmail.com a écrit :
>
> hello,
> I put my station into service on a new weewx installation, operation OK. How 
> can I recover the old database to add it to the new one? am I clear 
> enough?
>
> thanks
>
> Patrick
>
> -- 
> 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+...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/weewx-user/d15daeff-4d57-4bdb-a38f-6f9ef5499e3bn%40googlegroups.com
>  
> 
> .
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/4b213132-678d-40a9-84b9-f25add76ea5en%40googlegroups.com.

Re: [weewx-user] merge two data base

[salinois]

I found this in the mails from Vince;

is it the good methode ?

[I do it manually via dump and restore using sqlite3...

 * Stop weewx
 * Make a copy of your old and new db and work off those copies
 o cp weewx.sdb  /var/tmp/weewx.new.sdb
 o cp your_old_weewx.sdb /var/tmp/weewx.old.sdb
 o cd /var/tmp
 * Dump your old database's archive table to a file
 o echo ".dump archive" | sqlite3 weewx.old.sdb > old.dump.txt
 * Restore that into your new database
 o "cat old.dump.txt | sqlite3 weewx.new.sdb"
 o (and ignore the 'table already exists' warning)
 * Rebuild your daily summaries
 o rename your production weewx.sdb file to something else
 o copy the weewx.new.sdb built above into place as weewx.sdb in
   the directory weewx expects it in
 o sudo wee_database --rebuild-daily
 * Start weewx]

thanks


Patrick

Le 23/10/2023 à 23:07, sali...@gmail.com a écrit :

hello,
I put my station into service on a new weewx installation, operation 
OK. How can I recover the old database to add it to the new one? am I 
clear enough?


thanks

Patrick
--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d15daeff-4d57-4bdb-a38f-6f9ef5499e3bn%40googlegroups.com 
.


--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/0561615d-9a41-41f3-bc21-72534c258643%40gmail.com.

[weewx-user] merge two data base

[sali...@gmail.com]

hello,
I put my station into service on a new weewx installation, operation OK. How 
can I recover the old database to add it to the new one? am I clear enough?

thanks

Patrick

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d15daeff-4d57-4bdb-a38f-6f9ef5499e3bn%40googlegroups.com.