7.2.7  
Download Now
 
 

Sawmill Discussion Forum

Subject: "Archive old Sawmill data."     Previous Topic | Next Topic
Printer-friendly copy     Email this topic to a friend    
Conferences Support Topic #3191
Reading Topic #3191
premeau
Member since Oct-30-06
Oct-30-06, 08:06 AM (PDT)
Click to EMail premeau Click to send private message to premeau Click to add this user to your buddy list  
"Archive old Sawmill data."
 
   Is there away to archive old, already analyzed data?

We've already dumped the log files, but would like to have the historical data saved for "look back" purposes.

I'm thinking we should be able to do it, if there were a way to create a new profile, and have it source it's data from another profile. Then archive the "new" profile, and purge the database.

Is this possible?

Steve.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
dgilmoreadmin
Member since Nov-18-04
1705 posts
Oct-30-06, 02:50 PM (PDT)
Click to EMail dgilmore Click to send private message to dgilmore Click to view user profileClick to add this user to your buddy list Click to send message via AOL IM  
1. "RE: Archive old Sawmill data."
In response to message #0
 
Currently there's nothing that will directly automate this process however, we've come up with a somewhat clever solution that will provide a method.

In general you'd need to copy the existing database and profile, rename them, and then expire the original database to remove the data past a certain point.

If you'd like a detailed answer, let me know and I can post something here in the forum that describes the process. The only issue here would be that you'd use up a 'second' profile to keep the archived data live. If you wanted to truly archive it and restore it you could move it out of the database and profile directory, and possibly restore it by moving it back in.

David
Sawmill Product Support Team
support@flowerfire.com


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
Steven Premeau
unregistered user
Oct-30-06, 03:55 PM (PDT)
 
2. "RE: Archive old Sawmill data."
In response to message #1
 
   Okay, I think I know how to do this .. but is there a way to remove the new data from the copy, so that the data sets don't overlap?


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
dgilmoreadmin
Member since Nov-18-04
1705 posts
Oct-30-06, 04:31 PM (PDT)
Click to EMail dgilmore Click to send private message to dgilmore Click to view user profileClick to add this user to your buddy list Click to send message via AOL IM  
3. "RE: Archive old Sawmill data."
In response to message #2
 
Yes, you can set up an 'expire' in the old database to remove database data using an arbitrary filter (e.g. below, the last 30 days) which can be formed like:

-f "(date_time >= (now() - 30*24*60*60))"

David
Sawmill Product Support Team
support@flowerfire.com


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
Steven Premeau
unregistered user
Nov-03-06, 08:20 PM (PDT)
 
4. "RE: Archive old Sawmill data."
In response to message #3
 
   Would I be correct in assuming that the time is kept in Unix timestamp format (seconds since 1/1/70)?


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
dgilmoreadmin
Member since Nov-18-04
1705 posts
Nov-06-06, 04:17 PM (PDT)
Click to EMail dgilmore Click to send private message to dgilmore Click to view user profileClick to add this user to your buddy list Click to send message via AOL IM  
5. "RE: Archive old Sawmill data."
In response to message #4
 
Yes, correct, unix time.

David
Sawmill Product Support Team
support@flowerfire.com


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top

Conferences | Topics | Previous Topic | Next Topic
 
 
Home    Lite    Professional    Enterprise    Samples    FAQ    Downloads    Purchase    Manual    Support    Contact Us
Copyright © 2006 by Flowerfire. Privacy Policy