Re: load from is slow

robertstuart wrote in message <39B5358D.AF813F85@netscapeonline.co.uk>... >Yes - but make sure you point to the correct file in the new db > >If anybody ever ran an alter table against the old table in the old db >then the file names will be out of step - so check the name in systables >(a column called path or pathname). > dirpath....I'll feel so sad knowing this.. PS From someone who once did update systables set dirpath = "xx"; NO WHERE CLAUSE... ALL SYSTEM TABLES ARE NO LONGER ACCESSIBLE... Thinks overnight... create empty db - Note which .dat and .idxs are needed for any empty db i.e. which are the system tables. - add empty tables with correct structure using the dbschema I had kept.before my fatal update - copy system tables into broken .dbs directory. - update systables to make systables point to correct .dat and .idx files - unload a few tables as a test - dbexport complete db - update stats Volia, fixed database - magic!! A recovery method Informix Tech Support would not think of in their wildest mightmares! I'm so good..better service than even Informix Tech Support can provide! Faints...sounds of Alice Cooper in Wayne's World and ... We're not worthy..We're not worthy... <Sounds in the background of projectile vomiting from my work collegures (Harvey!!)?> Don't ask...it's been a bad fortnight... David. > >Richard harnden wrote: >> >> Hi >> >> With SE you can just cp the .dat and .idx files from one database to another. >> >> Just create an identical table/indexes in your target database. >> Find the filenames from systables.dirpath and copy away. >> >> You'll need to make sure that nobody is updating the table during the copy, but that's about it. >> >> Do an update statistics afterwards, cause the new table will still think it's got 0 rows. >> >> >>> "r_hao" <r_hao@hotmail.com> 09/04/00 06:27pm >>> >> Hi, All; >> I have Informix SE 7.2 running on HP-UNIX 10.2. I used 'unload' to move a >> table (16 million records in it) from another database into this new >> database. However, 'load' is very slow. It only loads about 1 million >> records in 5 hours. So the question is what is the best way to move data >> from one database to another. >> >> TIA >> >> Randy