Interesting, David - I have never had a failure in the original database, even when blown out of R:Base because of "interesting" characters in the data set. I do, however, always make copies of things to the point that network administrators beat me over the head about the extra space I take up. Suspenders and Belt, I guess.
"Dennis McGrath" <[EMAIL PROTECTED]> wrote: >I also advise anyone planning on doing a reload to shut down their computer >completely first. �Then power up fresh and do the reload. �Eliminates a lot >of unpredictable behavior. > >--Dennis McGrath > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of David M. Blocker >Sent: Thursday, December 12, 2002 6:35 AM >To: [EMAIL PROTECTED] >Subject: Re: Unload all/Reload/ Pack > > >Albert > >Sorry to say from past experience that a power failure during a RELOAD CAN >damage the original database as well. It happened to a client of mine who >ignored my advice to backup first. > >From then on, I learned to set up AUTOMATED routines for clients for reload >that do this: > >AUTOCHK database >IF OK > � �Back up to local drive > � �If it works > � � � �GO on > � �Else > � � � �Error message and STOP > � �endif >ELSE > �error message and STOP >ENDIF > >RELOAD >IF error var shows problems > � �STOP and restore from backup >ELSE > � �Go on >ENDIF > >Check reloaded database >IF OK > � �Go on >ELSE > � �Error message and restore from backup >ENDIF > >Delete original database >Rename reloaded to original name >End > >David Blocker > >----- Original Message ----- >From: "Albert Berry" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, December 11, 2002 6:46 PM >Subject: RE: Unload all/Reload/ Pack > > >Gunnar, PACK is dangerous. Anything that interrupts the process will destroy >the database. PACK removes empty space from the database and rebuilds the >indexes. > >RELOAD writes out to a new database, so if it is interrupted you still have >the original. When RELOAD writes the new database, it goes table by table. >This is a similar effect in your database to a defragmentation of your hard >drive. > >UNLOAD creates a text file that will rebuild your database as if you typed >everything in again. Remember to rename the original database before you RUN >the ascii file, or you will double any data that does not have a primary key >on it. This database is even more compact than the RELOADed version. > >If UNLOAD/RUN does not return all the data, you have one or more rows of >data that has interesting characters in it. When the process hits these >characters, the process aborts, leaving you with an incomplete database. > >The solution to the aborted RUN is to compare the row counts before and >after. I do this even for the system tables, because that I way I see broken >keys, missing indexes, etc. > >I highly recommend that you get a database cleaned up to the point that it >will pass through the UNLOAD/RUN sequence, as the bad data rows will cause >abnormal termination and further corruption of your database. > > > > > > > > "Gunnar Ekblad" <[EMAIL PROTECTED]> wrote: > >>Has someone a guidence? >>1. If I do a pack I understand I take a chance on no power breakdown. >>2. If I do a reload I should not have the risk of power breakdown but >>have the same result as 1 obove. >>3. If I do unload all then delete the database base an load it back, >>that should be the same as 2 obove.!? >>4. If 2 and 3 and that does not give the same result what am I doing >>wrong? >>5. I am mostly on DOS 1.862 (or Windows corresponding version) >>Background: >>1. I am doing conversion work from Glorious 2.11 to Dos version of today >>waiting for the future win 7.0 to go Windows when happy days will >>arrive. >>Other minory ? that I can not answer! >>1. Has someone an Idea where I can look for answers? >>2. Has anyone an Idea what to look out four? >>Not to worry! >>1. Some 20 % of my application is running on 1.862 but I would be happy >>to understand above subject before I Move remaining 80% from 2.11 >> >>??? From the Swedish Dinosaur of 2.11 world ??? >>Gunnar >> >> >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> > > >-- >Albert Berry >Full Time Consultant to >PSD Solutions >350 West Hubbard, Suite 210 >Chicago, IL 60610 >312-828-9253 Ext. 32 > > >__________________________________________________________________ >The NEW Netscape 7.0 browser is now available. Upgrade now! >http://channels.netscape.com/ns/browsers/download.jsp > >Get your own FREE, personal Netscape Mail account today at >http://webmail.netscape.com/ >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
