Re: Disappearing data
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43015
interpreted = N
texte = On 8/29/02 9:28 PM, Kenneth Grome
wrote:> This will not solve the problem if the RAM-cached data gets screwed> up and then WebDNA writes that bad data to disk thereby overwriting> the 'good' data that was stored on disk. The only real solution to> this problem is to duplicate your db files at periodic intervals, and> then preferably to store those duplicates offline or on another> volume.I had this problem in 2 situations. 1- low drive space when they db's cannotbe written back to do space constraints and WC4.0. I had a spare driveinserted into the machine and I wrote the db files to the second drive onthe hour on each day of the week. Ie day of the week is Sunday or 01 everyhour I wrote the databases to the structure as follows:F:Backups/01/01F:Backups/01/02I then played with this until I had a happy medium. You can take even hours,hours divisible by 3 etc.This will help you until you can find the problem and you will have asnapshot back for a week. You will be able to see when the problem occurredand revert to day just prior to the error.Here is my code I just included it, in my hourly functions page.Database Backedup[appendfile action.log][date] [time] [date %H] Begin backup[ipaddress][/appendfile] [math show=f]filecount=0[/math] [text secure=F]dayfolder=[date %a][/text] [math show=f]hour=[date %H][/math][showif [hour]\2][ListFiles path=../databases/][hideif [filename]^(][showif [filename]^.db][filename]
[math show=T]filecount=filecount+1[/math][text secure=F&show=T]backupfile[filecount]=[filename][/text][hideif [filename]^archives][commitdatabase ../databases/[filename][hideif[hour]\2].blah[/hideif]][/hideif] [/showif][/hideif][/Listfiles][dos]cd ..\..\..\Mydomain.com\wwwroot\databases\mkdir F:\backup\[dayfolder]\[date %H]mkdir F:\backup\[dayfolder]\[date %H]\[Date %y-%m-%d][date %H][loop start=1&end=[filecount]]copy[interpret][backupfile[index]][/interpret] F:\backup\[dayfolder]\[date%H]\[interpret][backupfile[index]][/interpret][/loop][/dos][appendfile action.log][date] [time] [date %H][math]{[date]}[/math].[math]{[time]}[/math] backup files[loopstart=1&end=[filecount]] copy [interpret][backupfile[index]][/interpret]F:\backup\[dayfolder]\[date%H]\[interpret][backupfile[index]][/interpret][/loop][/appendfile][/showif]Good luck and I hope you found your problem. My went away when I upgraded to4.5, and its still a beta version, Windows EXE version 4.5.0b1, you couldtry that one and see if the problem goes away. I never upgraded, because ifit ain't broke and you don't NEED a new one. . . . Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 8/29/02 9:28 PM, Kenneth Grome wrote:> This will not solve the problem if the RAM-cached data gets screwed> up and then WebDNA writes that bad data to disk thereby overwriting> the 'good' data that was stored on disk. The only real solution to> this problem is to duplicate your db files at periodic intervals, and> then preferably to store those duplicates offline or on another> volume.I had this problem in 2 situations. 1- low drive space when they db's cannotbe written back to do space constraints and WC4.0. I had a spare driveinserted into the machine and I wrote the db files to the second drive onthe hour on each day of the week. Ie day of the week is Sunday or 01 everyhour I wrote the databases to the structure as follows:F:Backups/01/01F:Backups/01/02I then played with this until I had a happy medium. You can take even hours,hours divisible by 3 etc.This will help you until you can find the problem and you will have asnapshot back for a week. You will be able to see when the problem occurredand revert to day just prior to the error.Here is my code I just included it, in my hourly functions page.Database Backedup[appendfile action.log][date] [time] [date %H] Begin backup[ipaddress][/appendfile] [math show=f]filecount=0[/math] [text secure=F]dayfolder=[date %a][/text] [math show=f]hour=[date %H][/math][showif [hour]\2][ListFiles path=../databases/][hideif [filename]^(][showif [filename]^.db][filename]
[math show=T]filecount=filecount+1[/math][text secure=F&show=T]backupfile[filecount]=[filename][/text][hideif [filename]^archives][commitdatabase ../databases/[filename][hideif[hour]\2].blah[/hideif]][/hideif] [/showif][/hideif][/Listfiles][DOS]cd ..\..\..\Mydomain.com\wwwroot\databases\mkdir F:\backup\[dayfolder]\[date %H]mkdir F:\backup\[dayfolder]\[date %H]\[Date %y-%m-%d][date %H][loop start=1&end=[filecount]]copy[interpret][backupfile[index]][/interpret] F:\backup\[dayfolder]\[date%H]\[interpret][backupfile[index]][/interpret][/loop][/dos][appendfile action.log][date] [time] [date %H][math]{[date]}[/math].[math]{[time]}[/math] backup files[loopstart=1&end=[filecount]] copy [interpret][backupfile[index]][/interpret]F:\backup\[dayfolder]\[date%H]\[interpret][backupfile[index]][/interpret][/loop][/appendfile][/showif]Good luck and I hope you found your problem. My went away when I upgraded to4.5, and its still a beta version, Windows EXE version 4.5.0b1, you couldtry that one and see if the problem goes away. I never upgraded, because ifit ain't broke and you don't NEED a new one. . . . Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Bob Minor
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[subtotal] and others (1997)
Sub Categories (2000)
Caching [include] files ... (1997)
Quickie question on the email templates (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Plaintext Email Attachment (2001)
Any Unix/Linux version to come? (1999)
[WebDNA] Databases not staying open (2010)
A little syntax help (1997)
[WebDNA] Failed to aquire lock on database error (2011)
Price Change (2000)
Execute Applescript (1997)
A new bug? (1999)
[WebDNA] Dealing with age and birth day (2017)
RE: Cookies? (1997)
[UPPERCASE] (1997)
[WebDNA] Greetings to all (2016)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Using the sendmail command on CGate Pro (Unix) (2000)
WCS Newbie question (1997)