Path: utzoo!attcan!uunet!cs.utexas.edu!mailrus!iuvax!rutgers!aramis.rutgers.edu!paul.rutgers.edu!yes.rutgers.edu!emuleomo From: emuleomo@yes.rutgers.edu (Emuleomo) Newsgroups: comp.databases Subject: Duplicating Informix SQL Database Keywords: Informix SQL SCO Xenix Message-ID: Date: 22 Sep 89 15:17:58 GMT Organization: Rutgers Univ., New Brunswick, N.J. Lines: 17 Can anybody please tell me how I can *completely* duplicate an entire Informix Sql database.??? I tried copying the contents of the ".dbs" directory to another directory and the changing DBPATH so that I pick up the copy. That seemed to work fine, until I DROPPED the copy, and LO and BEHOLD, it dropped some tables in the original database!. However, the entire 'copy' database was dropped as expected! Any help will be GREATLY appreciated! Thanx --Emuleomo O.O. (emuleomo@yes.rutgers.edu) -- ** Writing error-free code MUST be magic! Why else is it sooo difficult to do?