This is a common question that we’ve encountered in the past during our PoC process.

Question:

Many of our users have existing data within MyISAM tables.  How do they go about moving this data to ICE?

Answer:

The data within the MyISAM table must be exported using a SELECT ....INTO OUTFILE clause.  Data should be delimited by a symbol that you typically don’t find in your data.  I find that the ‘tab’ escape symbol or the ‘pipe’ symbol works quite well.

You must then use the LOAD DATA INFILE…statement to load the data into the INFOBRIGHT table.  Be sure to set the @bh_dataformat to ‘txt_variable’.  This will invoke the high speed Infobright loader.  Details on the syntax that can be used with the Infobright loader may be found here:  http://www.infobright.org/wiki/Data_Loading/