Re: Informix data extraction

------------7F6B5C615E4B1 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Steven, I recently did what you are doing on an HP-UX machine with Online 5.0. I found the easiest way to do this is dbexport. This will export all the data and the SQL to recreate the database. In a directory were you have lots of disk space on the Xenix machine type dbexport <database name> Hit enter and wait. It creates a diectory call <database name>.exp with and SQL file and a bunch of data files, for each database. Then to reload the database use dbimport. The syntax is the same dbimport <database name> This wiil create the database and all table and reload them. -- _________________________________________________ Bryan Sapot bsapot@gundaker.com Network Systems Engineer webmaster@gundaker.com Gundaker Realtors http://www.gundaker.com ------------7F6B5C615E4B1 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii <HTML><BODY> <DT>Steven,</DT> <DT>I recently did what you are doing on an HP-UX machine with Online 5.0. I found the easiest way to do this is dbexport. This will export all the data and the SQL to recreate the database.</DT> <DT>&nbsp;</DT> <DT>In a directory were you have lots of disk space on the Xenix machine type dbexport &lt;database name&gt;</DT> <DT>&nbsp;</DT> <DT>Hit enter and wait.</DT> <DT>It creates a diectory call &lt;database name&gt;.exp with and SQL file and a bunch of data files, for each database.</DT> <DT>&nbsp;</DT> <DT>Then to reload the database use dbimport. The syntax is the same dbimport &lt;database name&gt;</DT> <DT>&nbsp;</DT> <DT>This wiil create the database and all table and reload them.<BR> --&nbsp;<BR> _________________________________________________<BR> Bryan Sapot&nbsp;&nbsp; bsapot@gundaker.com<BR> Network Systems Engineer webmaster@gundaker.com<BR> Gundaker Realtors&nbsp; http://www.gundaker.com<BR>; &nbsp;</DT> </BODY> </HTML> ------------7F6B5C615E4B1--