| View previous topic :: View next topic |
| Author |
Message |
Entr04y
Joined: 11 Nov 2005
Posts: 8
|
 Posted: Fri Nov 11, 2005 9:42 pm Post subject: create wlk files from mysql / database tables |
 |
|
I had started my own database and have all the data for the last year in the database, which I just imported into the archive table in the wviewDB. I had to reset my console to use a 5 minute archive (it was set to 30 minutes), and that of course cleared all the archive data. I had been pulling the data every five minutes, so my old data is valid for the new setup. Is there a way to create the wlk files from the data in the archive table?
Thanks! |
|
| Back to top |
|
 |
mteel
Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX
|
| Posted: Sat Nov 12, 2005 1:36 am Post subject: |
|
|
Aha!
This is your crash problem I bet!
How is wview coming up and saying it is finding 30 days of archive records if you just changed from a 30 minute archive interval to a 5 minute archive interval? Did you not heed:
| Quote: | 6.4 (New Installs) Existing Weatherlink Archive Files
If you have existing archive files (*.wlk) that you want to keep/use, copy them to
/var/wview/archive prior to starting wview. It will find them and use them for
historical charts and NOAA reports. But only if they were collected using the same
archive interval that you are going to use for your VP with wview. See the section
Preparing a New Vantage Pro Console for more details. |
If this is the case, you need to move the old 30 minute WLK files out of the way (/var/wview/archive) and start fresh if you want to change your archive interval to 5 minutes...
To answer your other question, no, you cannot backfill WLK files with relational database data. The WLK files are *the* data of record. It could be done I guess, but not any time soon. There is another request to synchronize the database with the WLK files (going the other direction from your request).
Mark |
|
| Back to top |
|
|
mhweather
Joined: 07 Aug 2005
Posts: 54
|
| Posted: Sat Nov 12, 2005 8:31 am Post subject: |
|
|
| Slightly off the topic, but does Wview, when configured for MySQL, also continue to record data in *.WLK files ? |
|
| Back to top |
|
|
mteel
Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX
|
| Posted: Sat Nov 12, 2005 8:36 am Post subject: |
|
|
Yes ... absolutely ... YES!
The WLK files are always created and are the archive of record.
MySQL or PostGreSQL archives are only for convenience and to use externally for reports or other custom apps - they are never used as input to wview, only the WLK files.
Said another way, relational database archives are *output* only, never used as input to wview.
The WLK files are input and output and their central role as the archive of record is not affected by the generation of relational archive records. |
|
| Back to top |
|
|
Entr04y
Joined: 11 Nov 2005
Posts: 8
|
| Posted: Sat Nov 12, 2005 10:24 am Post subject: |
|
|
the steps I took when changing the archive interval were:
shut down wview
change the archive settings on the console using vpinstall
truncate the archive table in mysql
backfill the mysql table with my old data
delete all of the .wlk files in /var/wview/archive
restart wview
I put the .wlk file, which is the only one I have at this point at http://www.froody.org/2005-11.wlk if you want to take a look at it. |
|
| Back to top |
|
|
mteel
Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX
|
| Posted: Sat Nov 12, 2005 3:24 pm Post subject: |
|
|
Yep, that looks right, very odd indeed. Maybe the computed data I added recently doesn't like to run in the first day of archive records - that is a little hard for me to test.
Let me know if you see any other problems. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
