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:

    
  1. Re: Lost Records in Database (Christer Olsson 2001)
  2. Re: Lost Records in Database (Christer Olsson 2001)
  3. Re: Lost Records in Database (Clint Davis 2001)
  4. Re: Lost Records in Database (Nitai @ ComputerOil 2001)
  5. Re: Lost Records in Database (Christer Olsson 2001)
  6. Re: Lost Records in Database (John Peacock 2001)
  7. Re: Lost Records in Database (Clint Davis 2001)
  8. Re: Lost Records in Database (Bob McPeak 2001)
  9. Lost Records in Database (Clint Davis 2001)
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:

One more time (1997) Jimmy (1998) Country & Ship-to address & other fields ? (1997) Problems with [Math] (1998) [WebDNA] Authentication across domains (2009) [url] (1997) WebMerchant 1.6 and SHTML (1997) syntax question, not in online refernce (1997) WebDNA color code chart - oops (2002) CSV import suggestions (2007) Sort Issue? (2000) Server crash (1997) Weird bug, or is there something amiss? (1997) shipcost (1997) My URL, Your URL (2002) Multiple prices (1997) consolidating orders (2000) WebMerchant problem (1998) WebCatalog2 Feature Feedback (1996) Re:listfiles-looking for slick solution (1997)