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:
Carts & Refering URLs (1997)
GuestBook example (1997)
can WC render sites out? (1997)
shoppingcart reload qty (1997)
OT - help.. (2003)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
Multiple prices (1997)
[BULK] [WebDNA] Authorize.net SIM, Server Integration Method (2011)
WebCat2 several catalogs? (1997)
Date search - yes or no (1997)
Upgrade to 3.07 problems (2000)
Discounts (2001)
Need Advice for Setting up a Database (1999)
Databases going to sleep (1998)
Where can I find hex equivalents for ASCII characters? (2000)
[movefile] (1999)
A *secret* new webdna tag !!! (1999)
Searching Groups for multiple matches (1998)
Running WebCat from a CD-ROM (1997)
WebCat2: Items xx to xx shown, etc. (1997)