have you tried comparing rows from the database and the reloaded
version? It might give you a clue as to where to look.
Albert
On 12/09/2011 2:22 PM, MDRD wrote:
PS: When I tested their DB on my computer I let is run over 30
minutes, their tech let his run over 1 hour.
Marc
-----Original Message----- From: Albert Berry
Sent: Monday, September 12, 2011 3:10 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Strange Unload all problem
It may appear to be stuck, but be building the indexes and constraints.
Give it a few minutes to allow the indexing to complete - messages don't
show. I know when this is happening on my laptop because I can see the
drive light working.
An alternative that works faster than the UNLOAD ALL for large databases
is to
1. UNLOAD STRUCTURE to a file e.g. database.str
2. UNLOAD DATA to another file e.g. database.dat
3. Open database.str in the editor and find the point where the tables
have all been created, and the indexing starts.It is usually ALTER
TABLE somethingorother ADD PRIMARY KEY
4. Cut everything from here to the end of the file and put them in
another file e.g. database.ind
5. OUTPUT database.log
6. RUN database.str
7. RUN database.dat
8. RUN database.ind
9. OUTPUT screen
Working this way, R:Base will load the data without indexing.
If you get error messages running database.ind, you may have duplicate
data in one of the tables. Check the database.log file to see what
broke. Do 5 and 6 again, then do select pk_column,count(*) from
errortable group by pk_column having count(*) > 1 to find the duplicates
and fix the errors. When you have completed this, you will have a nice
clean database.
Albert
user sent me there files that he can not Unload ALl,
I ran Autocheck No errors, I Reloaded the DB fine with no errors and
it only took a few minutes but if I Unload ALL then run the file it
gets stuck after the loading the data for the last table.
I am not sure what to look for? Any suggestions?
Marc
