Re: Lost Records in Database
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39519
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Bob McPeak
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:
Encrypt Decrypt URL UnURL Weirdness (2001)
Associative lookup style? (1997)
multiple product databases (1997)
protect tag on NT (1997)
[WebDNA] paypal FINALLY!!!! (2009)
WebDNA Windows 5.0 sendmail bug (2003)
WebMerchant Error (1998)
FRIDAY (2002)
Need help... (1997)
SMSI FTP - calander system (2002)
WebDNA equivalent for $REQUEST_URI (2004)
Part Html part WebDNA (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
It just Does't add up!!! (1997)
WebCatalog Use Question (1997)
Netscape v. IE (1997)
Passing WebCat data to SSL server (1997)
more on quicktime test stuff (1997)
PIXO (1997)
formula??? (2000)