Need to change iexpress/mysql home directory

[Rgomes]

Hi All,

I need to change iexpress/mysql home directory from /opt/iexpress/mysql to 'external_mount_point'. How can I do this?

TIA.
Richard

[Arunvijai_4]

Don't change mysql home directory to anyother than iexpress/mysql because while building MySQL, it was specified. If you want to go for anyother than the default, you have to rebuild the source under /opt/iexpress/mysql/src

-Arun

[Mark Nieuwboer]

Hi Richard,

First make a tar file of the home directory.
cd /opt/iexpress
tar xvf /tmp/mysgl.tar mysql.
umount iexpress/mysql
mount the new directory.
cd
cp /tmp/myscq.tar
tar cvf mysql.tar
then throug sam or with usermod change the home directory of the user that use /opt/iexpress/mysql.
usermod -d
after this you also have to put the new mount piont in /etc/fstab to make sure it mount with a reboot.

grtz. Mark

[Rgomes]

Hi Mark,

Will this do? Will your steps also move existing databases? Actually I need to move mysql itself and its databases into another location safely.

Thanks.
Regards,
Richard

[Steven E. Protter]

Shalom Richard,

Steps:

1)Bring down the database.
2)modify my.cnf for the new location.
3)move or copy the files from the new to the old location.
4) Bring up the database.

Tips:
NFS must have full rights to the owners of the files.

Storing the database files on a Samba mount is possible, but I'd stay away from Linux Samba using regular user based authentication.

Good Luck,

SEP