From the manual we have that innodb_data_file_path contains paths to
individual data files and their sizes. The full directory path to each
data file is acquired by concatenating innodb_data_home_dir to each path
specified here. Many other ibd files are result of per-file tablespace.
So, you can just change the value of innodb_data_home_dir, and move
files listed in innodb_data_file_path to the directory. I strongly
recommend you to backup your data before any actions.
Nathan Gross wrote:
> Mysql 4x on Linux Fc4.
> In /var/lib/mysql there is an ibdata1 file. Also in this directory I
> also have various database folders, with *.ibd data files. I would
> like to locate the ibdata1 somewhere else, say, /usr/extraData/mysql.
> I am confused as how to set *innodb_data_file_path* as well as
> Please help.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET