Re: Copying an informix database with "cp"

Quoting Michael Segel... > > Dave, > > >From my news site, I cannot send out any news, so please relate the > following: > Done... BTW, comp.databases.informix is a bi-directional link with the Informix Mailing List. You can send mail to "informix-list@rmy.emory.edu" and it will be posted to c.d.i for you. > Theoretically, you can in SE copy the database using the cp command. > Yes you can, but it's rather yucky to clean up. > However, It is never recommended to do so. I would go as far to say > that only an idiot or someone who does not care about security or > database integrity will do so. > Please don't people idiots, I copy databases all the time :-) This is what I do and I have yet to have a problem: 1) I run my "dbrepair" utility on the database. This removes all absolute pathnames from systables (except for the log file if applicable). 2) As "root" I cd to the directory that has the database in it and type: find . -print | cpio -pvumd /new/path/name (this keeps the file perms) 3) As "informix" I manually delete the logfile entry from systables if applicable. 4) As the database owner, I execute a START DATABASE statement if needed. > Really, it is far easier and painless to do a DBSCHEMA, then create the > tables, and unload and load the data a table at a time. > Maybe, but that takes more time. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com