I have installed the ICE in the 64 bit machine, in that, i stoped the mysql service, then i have changed the data dir in the config file
/etc/my-ib.cnf, again i tried to start the mysql service, but its not start. If i changed to the default data dir, again its work.  Why?
how to change the data dir in the infobright?

# The MySQL server
[mysqld]
basedir = /usr/local/infobright
#datadir = /usr/local/infobright/data   #—Default Data Dir
datadir = /mysql/infobright/data       #—New Data Dir

This config not working, doesnt start the mysql service.

Thanks.
S.Ashokkumar.

[light edits, and Thanks! Mahib]

write2ashokkumar,

Assuming you don’t wish to reinstall with the new data directory path, the easiest method is to do this without editing any files is to:

1. stop the server

2. create the new directory

3. Move the contents of the current data directory, /usr/local/infobright/data, to the new directory, /mysql/infobright/data

[Verify this syntax with a test fold before proceeding.]

4. Create a symbolic link from the new directory back to the old name

5. Restart the server

I will follow this up with the correct edits if you choose to follow the course of changing the configuration files.  Bear in mind that the contents of the data directory, the databases themselves, must be moved to the new location in either case.

write2ashokkumar,

I have reviewed all configuration files and have confirmed that the only edit you need to make is the one you have mentioned.  (I would ask you to consider if you want to move the CacheFolder, as defined in the /usr/local/infobright/data/brighthouse.ini file, as well.)

The step that appears to be missing is Step 3 above.  You must copy the existing contents of the installation data directory to the location where you want it to reside.

Perhaps, this is actually easier than the previous method. 

Hi Ashok

There is a postconfig.sh script in the /usr/local/infobright/ folder. You can run it (using root access) to move data, cache folders.

cd /usr/local/infobright/
postconfig.sh

This is basically implementation of David’s steps.

cheers

Correction: The postconfig script only goes with rpm/deb/solaris pkg based installer but not with the tar based installed. Probably we should include this.

thanks David for pointing this out.