HI Albert
I thought of that but was looking for a little quicker way, they are in a
bind and I have that other office to deal with, What a Monday LOL
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
