Re: copy database structure and contents

In article <4s7059$5l1@godzilla.zeta.org.au>, Bryan Tonnet <batonnet@zeta.org.au> wrote: > >>See dbexport and dbimport in the appendicies of the SQL manuals > >Even easier, if it's SE, is to just copy the databasename.dbs directory. Be very careful doing this. This will work *if* all systables.dirpath values are non-absolute; i. e., they have only the Unix file basenames without the {dat,idx} suffixes. Otherwise, the original Unix files will be accessed (if possible) when the tables are referenced in the new copy of the database. A disclaimer on this advice is that it was true for older SE versions, and I have not had occasion to verify it in later ones, thankfully. If someone with more knowledge of SE internals knows otherwise, I'd appreciate hearing about it. Thanks, Walt. -- Walt Hultgren Internet: walt@rmy.emory.edu (IP 170.140.97.4) Emory University UUCP: {...,gatech,rutgers,uunet}!emory!rmy!walt 954 Gatewood Road, NE BITNET: walt@EMORY Atlanta, GA 30329 USA Voice: +1 404 727 0648