Re: Mass deletion of records
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66149
interpreted = N
texte = I never found a solution, except to make bi-daily backups. I use this: [listfiles path=databases/] [showif [isfile]=T] [COPYFILE from=databases/[filename]&to=db_daily_archives/[listwords words=[filename]&delimiters=.][showif [index]=1][word]_[date %A_%p][/showif][showif [index]=2].[word][/showif][/listwords]] [/showif] [/listfiles] It copies all .db & .hdr files to an archive folder with the day and AM or PM. So you get a morning and evening backup of each file in your DB folder. Each week the script overwrites the files with the new ones. Example.db would be saves as: Example_Monday_AM.db Example_Monday_PM.db Example_Tuesday_AM.db .....etc Just write a trigger to run the script 2 times a day and change the path to your DB directory. Brian -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Stuart Tremain Sent: Monday, January 30, 2006 10:16 PM To: WebDNA Talk Subject: Mass deletion of records I have had a mass deletion of records from a db that has ben stable for a number of years, no work has been done to any of the system that would delete records. There is not even a [Delete] in the site. I noted in the archives other people having this 'mystery' deletion. Has anyone come up with an answer ? http://search.smithmicro.com/TalkListArchive/SubjectResults.tpl? command=search&db=webdna-talk.db&wsSubjectdata=%20Re%3A%20WebDNA% 20deletes%20major%20DB%20data%20big%20time&words=records% 20deleted&group1data=records%20deleted&group1comp=wa&max=50 Stuart Tremain idfk web developments, sydney, australia ------------------------------------------------------------- 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I never found a solution, except to make bi-daily backups. I use this: [listfiles path=databases/] [showif [isfile]=T] [COPYFILE from=databases/[filename]&to=db_daily_archives/[listwords words=[filename]&delimiters=.][showif [index]=1][word]_[date %A_%p][/showif][showif [index]=2].[word][/showif][/listwords]] [/showif] [/listfiles] It copies all .db & .hdr files to an archive folder with the day and AM or PM. So you get a morning and evening backup of each file in your DB folder. Each week the script overwrites the files with the new ones. Example.db would be saves as: Example_Monday_AM.db Example_Monday_PM.db Example_Tuesday_AM.db .....etc Just write a trigger to run the script 2 times a day and change the path to your DB directory. Brian -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Stuart Tremain Sent: Monday, January 30, 2006 10:16 PM To: WebDNA Talk Subject: Mass deletion of records I have had a mass deletion of records from a db that has ben stable for a number of years, no work has been done to any of the system that would delete records. There is not even a [delete] in the site. I noted in the archives other people having this 'mystery' deletion. Has anyone come up with an answer ? http://search.smithmicro.com/TalkListArchive/SubjectResults.tpl? command=search&db=webdna-talk.db&wsSubjectdata=%20Re%3A%20WebDNA% 20deletes%20major%20DB%20data%20big%20time&words=records% 20deleted&group1data=records%20deleted&group1comp=wa&max=50 Stuart Tremain idfk web developments, sydney, australia ------------------------------------------------------------- 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
"Brian Boegershausen"
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:
PCS Frames (1997)
RE: Recursion & WebDNA (1999)
Search Engines (2002)
Weird cart problem (webcat 2.x) (2000)
syntax question, not in online refernce (1997)
Snake Bites (1997)
RE: Formulas.db + Users.db (1997)
No Wanna Duppys (1998)
Universal root for WC errors? (1997)
New random discoveries? (2005)
Docs error: encrypting templates... (2000)
Seattle based Webcatters? (2000)
WebCommerce Security Alert! (1996)
[searchString] (1997)
Re:Help name our technology! (1997)
Forms Search Questions (1997)
autocommit problem (1998)
autosensing lanague selection (1997)
How to verify email address (1997)
Redirect frame targets (1998)