Mysql – Creating a MySQL db from an Informix database

exportimportinformixmigrationMySQL

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL.

I tried to export it using dbschema and it created the dbase.sql file and several table00123.unl files for the tables.

I tried to import the .sql file into MySQL and it didn't like the syntax of the files that Informix exported.

I just wanted to know the best way to export/dump/output an Informix database that can be imported into MySQL.

Best Answer

You first need to convert that output file nearest to MySQL syntax and convert the data type according to MySQL. You could user perl or sed scripts for first time and then use these techniques for future use. Once you have prepared the files of table creation then generate dynamic insert statements from informix and use them in MySQL for loading data.

Regards, Nawaz

Related Question