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 cannot be written back to do space constraints and WC4.0. I had a spare drive inserted into the machine and I wrote the db files to the second drive on the hour on each day of the week. Ie day of the week is Sunday or 01 every hour I wrote the databases to the structure as follows:F:Backups/01/01 F: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 a snapshot back for a week. You will be able to see when the problem occurred and 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[loop start=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 to 4.5, and its still a beta version, Windows EXE version 4.5.0b1, you could try that one and see if the problem goes away. I never upgraded, because if it ain't broke and you don't NEED a new one. . . . Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting 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:

    
  1. Re: Disappearing data (Timur Ruban 2002)
  2. Re: Disappearing data (Timur Ruban 2002)
  3. Re: Disappearing data (Kenneth Grome 2002)
  4. Re: Disappearing data (Donovan Brooke 2002)
  5. Re: Disappearing data [OT] (Donovan Brooke 2002)
  6. Re: Disappearing data (Bob Minor 2002)
  7. Re: Disappearing data (Dan Strong 2002)
  8. Re: Disappearing data (Kenneth Grome 2002)
  9. Re: Disappearing data (Timur Ruban 2002)
  10. Re: Disappearing data (Dan Strong 2002)
  11. Re: Disappearing data [OT] (Rob Marquardt 2002)
  12. Re: Disappearing data (Sal D'anna 2002)
  13. Re: Disappearing data (Donovan Brooke 2002)
  14. Re: Disappearing data (Timur Ruban 2002)
  15. Re: Disappearing data (marc malacarme 2002)
  16. Disappearing data (Timur Ruban 2002)
  17. Re: Disappearing Databases (Larry Hewitt 2000)
  18. Re: Disappearing Databases (Kenneth Grome 2000)
  19. Re: Disappearing Databases (Larry Hewitt 2000)
  20. Re: Disappearing Databases (Kenneth Grome 2000)
  21. Re: Disappearing Databases (Paul Uttermohlen 2000)
  22. Re: Disappearing Databases (Kenneth Grome 2000)
  23. Disappearing Databases (Alex Cheparev 2000)
  24. Re: Disappearing Database (Ross Markbreiter 1998)
  25. Disappearing Database (Angel Bennett 1998)
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 cannot be written back to do space constraints and WC4.0. I had a spare drive inserted into the machine and I wrote the db files to the second drive on the hour on each day of the week. Ie day of the week is Sunday or 01 every hour I wrote the databases to the structure as follows:F:Backups/01/01 F: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 a snapshot back for a week. You will be able to see when the problem occurred and 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[loop start=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 to 4.5, and its still a beta version, Windows EXE version 4.5.0b1, you could try that one and see if the problem goes away. I never upgraded, because if it ain't broke and you don't NEED a new one. . . . Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting 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)