Hello.
>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: > Hi; > 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 > *innodb_data_home_dir*. > Please help. > Thanks; > -nat > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]