Hello.
Please, next time answer to the list as well. As far as I know, you can't specify the location of ibd files, they're stored in the database directory, however, you can use symbolic links for databases to have them in another place. >all databases? So the question is if I can locate the ibdata1 file >somewhere else. Have you tried just to change the value of innodb_home_dir to the new location, and move there ibdata1 file? >ibd files. BUT, the ibdata1 file is still 7 gig and being If you want do decrease the size of ibdata1 file, you should dump all your InnoDB tables, stop the server, remove all existing tablespace files, configure a new tablespace, restart the server, import the dump files. In such a way you'll move all your tables which are in ibdata1 tablespace to may ibd files in databases. See: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html >I don't understand. I want some ibd files in a different dir. Not in a >dir below the home dir. Actually what is the 'home' dir? The root of >all databases? So the question is if I can locate the ibdata1 file >somewhere else. >Reason being that *after* my ibdata1 file was about 7Gig, I changed to >a per file tablespace, and mysql copied all the data into individual >ibd files. BUT, the ibdata1 file is still 7 gig and being >searched/seeked/written to. I want to move this file to another >partition (Linux) in order to split the disk load and free up some >disk space. >Thank you much; 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]
