Re: Lost Records in Database
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39520
interpreted = N
texte = Unfortunately, this is NOT the orders.db file. I'm currently manually backing up the file every 6 hours, but this may still cause records to be lost.Smith Micro: any ideas???>I've seen this problem. It really hurts, I know first hand. > >If the db happens to be your Orders.db, you can rebuild it using your >completed orders files, otherwise, you may be out of luck. > >If/when you restore the db, set up a cronjob or trigger to make a regular >(hourly) backup and spare yourself the pain. > >You're not the first, and won't be the last person who this has happened to. > >----- Original Message ----- >From: Clint Davis
>To: WebCatalog Talk >Sent: Tuesday, October 23, 2001 9:19 AM >Subject: Lost Records in Database > > >> I have a WebSTAR server that's under a tremendous load right now. >> About once a day, the server crashes and is automatically restarted. >> This server hosts 2 sites that are almost entirely database-driven. >> >> Almost each time the server crashes, one database gets corrupted and >> a large block of records is lost. The database is about 8.5MB and the >> server has 640MB. This single database is the only one with any >> trouble. >> >> Everything seems to be working normally while the server is running. >> It doesn't appear that the database is corrupted. >> >> This is an emergency. Can anyone think of a possible solution? >> -- >> _______________________ >> >> Clint Davis >> Webmaster >> Gray Loon Marketing Group >> 812.422.9999 >> >> cdavis@grayloon.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://search.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://search.smithmicro.com/ -- _______________________Clint Davis Webmaster Gray Loon Marketing Group 812.422.9999cdavis@grayloon.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Unfortunately, this is NOT the orders.db file. I'm currently manually backing up the file every 6 hours, but this may still cause records to be lost.Smith Micro: any ideas???>I've seen this problem. It really hurts, I know first hand. > >If the db happens to be your Orders.db, you can rebuild it using your >completed orders files, otherwise, you may be out of luck. > >If/when you restore the db, set up a cronjob or trigger to make a regular >(hourly) backup and spare yourself the pain. > >You're not the first, and won't be the last person who this has happened to. > >----- Original Message ----- >From: Clint Davis >To: WebCatalog Talk >Sent: Tuesday, October 23, 2001 9:19 AM >Subject: Lost Records in Database > > >> I have a WebSTAR server that's under a tremendous load right now. >> About once a day, the server crashes and is automatically restarted. >> This server hosts 2 sites that are almost entirely database-driven. >> >> Almost each time the server crashes, one database gets corrupted and >> a large block of records is lost. The database is about 8.5MB and the >> server has 640MB. This single database is the only one with any >> trouble. >> >> Everything seems to be working normally while the server is running. >> It doesn't appear that the database is corrupted. >> >> This is an emergency. Can anyone think of a possible solution? >> -- >> _______________________ >> >> Clint Davis >> Webmaster >> Gray Loon Marketing Group >> 812.422.9999 >> >> cdavis@grayloon.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://search.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://search.smithmicro.com/ -- _______________________Clint Davis Webmaster Gray Loon Marketing Group 812.422.9999cdavis@grayloon.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://search.smithmicro.com/
Clint Davis
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:
Cart Template (1997)
Help formatting search results w/ table (1997)
WC2.0 Memory Requirements (1997)
sorted cart? (1998)
WC2b12: Yes, Formulas.db is for real (1997)
Sorting Orders (1997)
Help name our technology! (1997)
Banners (1997)
Separate SSL Server (1997)
Can this be done? (2003)
Cart Numbers (1997)
WebCat2 - [format thousands] (1997)
Listfiles on network with NT (2000)
WebStar Secure on other machine (1997)
Link with [cart] in db field (1999)
File Format Validation (2005)
Expiration of Carts (1997)
WebCat2: Found Items syntax, etc. (1997)
Blank Orders (2005)
Storebuilder, Smith-Micro Tech Support (2000)