We have a 1TB infobright database running GNU/Linux and need to move to a new GNU/Linux server.  What is the best way to move the existing environment to the new server?  I’m new to Infobright/MySQL but am an experienced Oracle and Teradata DBA.  Here’s output from show variables:

| version                     | 5.1.14-log                             |
| version_comment           | build number (revision)=IB_3.1-1_r3718_3855(ice)    |
| version_compile_machine     | x86_64                               |
| version_compile_os         | unknown-linux-gnu                         |

If you have the same exact installation file to redo the same version, then your process would be to shutdown the mysql service, copy the datadir directory to the new server, install infobright setting the datadir to the new location.

I would suggest looking into upgrading though becuase there are alot of new features that increase performance, but since your version is prior to 3.3, there would be a bit of a process for characcter set migration unless you were able to export and then import.

Are you interested in upgrading to a newer version of ICE?

Thank you for this info.  At this point I don’t plan on upgrading.  We use this database as an historical repository for data archived from certain portions of our data warehouse because the storage is much cheaper and rarely accessed.

I would really honestly suggest upgrading just because there are alot of performance gains in the 4.x versions as well as new features like Reject File and Rough Query and better performance on Querying due to CHARSET migrations.

This feature is really cool:  It is so helpful when importing data and dealing with Row level issues
http://www.infobright.org/wiki/Reject_File/

Just a really good suggestion and if you would like, i’d be happy to assist you guys in doing the upgrading.