[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread Neville Davis
yes unfortunately several times. I have the sql backup on the mac desktop...I have just dropped the db again and created another weewx db from the pi and just started to import about 300Meg of data in archive. Just reported finished this time I will just fire up weewx and see what happens Nev

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread Neville Davis
Just crashed again it's now 11:45 pm so will sleep on it. I had gone through this process during my build with weewx v4.0 had no problems then, don't think I have done anything other than extend the database...??? I can see the tables generated by using Sequel Pro (my tool to move and backup)

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread gjr80
Ok, just to be very specific, you have run the following two commands exactly: $ wee_database —drop-daily $ wee_database —rebuild-daily You use the phrase ‘drop the database’, that is different to dropping and rebuilding the daily summary tables. Gary -- You received this message because yo

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread Neville Davis
Yes these are the exact commandsI use the same as I have used many times before. As the issue happened several times I deleted all databases I had in MySQL, created new dB called weewx and imported my backup. This procedure I used as part of my rebuild of system on other occasions. The backupI

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread gjr80
Ok, could you please run those two wee_database commands again one after each other and post the console output making sure you include the commands entered as well as the output. Gary -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscr

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread Neville Davis
OK here it is Last login: Tue Jun 2 23:32:02 2020 from 192.168.0.54 *pi@raspberrypi*:*~ $* cd /home/weewx/bin *pi@raspberrypi*:*/home/weewx/bin $* ./wee_database /home/weewx/weewx.conf --drop-daily Using configuration file /home/weewx/weewx.conf Using database binding 'wx_binding', which is

[weewx-user] Re: weewx v4.1 sql db will not rebuild daily

2020-06-02 Thread Neville Davis
Well I am operational again...but running on 4.0. Managed to get my backup data installed and rebuilt daily...Going to let it run for a few days, to make sure it’s stable. Going to look at logs to see if anything stands out... Neville On Wednesday, June 3, 2020 at 7:01:10 AM UTC+10, Neville Dav