Re: unloading all data, how to do it?

On Wed, 13 Oct 2004 11:25:11 -0400, Konrad Mathieu wrote: > I am a newbee to Informix, how would I dump a complete database with all > tables, column names etc to something sql which can be ported to e.g. MySQL? For the life of me I cannot imagine why one would want to do THAT! However: If you just want the schema: dbschema -d mydatabasename -ss mydatabasename.sql To get the data also: dbexport -d mydatabasename -o . -ss Which will create a subdirectory in '.' named mydatabasename.exp containing a schema enhanced with the names and description of the unload files and a bunch of delimited data unload files. You'll have to edit the schema file to alter Informix-isms into MySQL-isms and I do not know how you'll reload the data, but there it is. Art S. Kagel