Re: Re: Migrate from Informix to Mysql

You could use dbexport wich generates the schema and unload the tables automatically. J. -----Original Message----- From: Thomas Ronayne <trona@REMOVETHISameritech.net> To: informix-list@iiug.org Date: Thu, 16 Jun 2005 12:59:33 GMT Subject: Re: Migrate from Informix to Mysql 1. Get a schema; e.g., dbschema dbname dbname.sql 2. Unload all the tables; e.g., echo "unload to table.unl select * from table" | dbaccess dbname 3. Start MySQL, create the data base, grant permissions, all that stuff, then exit MySQL. 4. mysql < dbname.sql 5. Fix all the stuff in the schema file that it chokes on, repeat (4) until you get a data base. 6. Load the .unl files with mysqlimport. Depending on your data base, this may be (a) trivial or (b) a real pain in the butt -- good luck! Hint: if your Informix data base is ANSI, you'll have an easier time (think about converting it to ANSI). Cyrille wrote: >I would like to know how to migrate a informix databas to Mysql. >I wish to know if someone knows any way to do this. >I don't want to use a commercial solution. > >Thanx. > > > Jean Sagi jeansagi@myrealbox.com jeansagi@gmail.com sending to informix-list