Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / November 2004

Tip: Looking for answers? Try searching our database.

unloading all data, how to do it?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Konrad Mathieu - 13 Oct 2004 16:25 GMT
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?

Thanks and cheers,
Konrad
Art S. Kagel - 13 Oct 2004 16:54 GMT
> 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
Thomas Ronayne - 13 Oct 2004 16:57 GMT
dbschema -d dbname dbname.sql

That will put a complete schema in the file dbname.sql -- you will have
to edit it for use with MySQL, particularly if you have views, stored
procedures and triggers, but also some basic syntax (MySQL will let you
know what you need to change).

>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?
[quoted text clipped - 3 lines]
>
>  
Konrad Mathieu - 22 Nov 2004 09:17 GMT
Thanks Thomas,
Thanks Art!
This should get me there.

Cheers,
Konrad

> dbschema -d dbname dbname.sql
>
[quoted text clipped - 9 lines]
>>Thanks and cheers,
>>Konrad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.