Re: locating ibdata1 and *.ibd files in different directories.

2005-12-20 Thread Gleb Paharenko
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

Re: locating ibdata1 and *.ibd files in different directories.

2005-12-20 Thread Nathan Gross
On 12/20/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Please, next time answer to the list as well. Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First time I noticed the 'reply to all' option in Gmail. Thanks. As far as I know, you can't specify the location of ibd

Re: locating ibdata1 and *.ibd files in different directories.

2005-12-20 Thread Gleb Paharenko
Hello. symbolic links! Thats a neat solution. Question: when you say symbolic links for databases do you mean links to ibd files, ibdata1 file, either, or something else? I've meant symbolic links for databases. See: http://dev.mysql.com/doc/refman/5.0/en/symbolic-links.html Is

RE: [SPAM] - Re: locating ibdata1 and *.ibd files in different directories. - Bayesian Filter detected spam

2005-12-20 Thread Gordon Bruce
To: mysql@lists.mysql.com Subject: [SPAM] - Re: locating ibdata1 and *.ibd files in different directories. - Bayesian Filter detected spam Hello. symbolic links! Thats a neat solution. Question: when you say symbolic links for databases do you mean links to ibd files, ibdata1 file, either

Re: locating ibdata1 and *.ibd files in different directories.

2005-12-19 Thread Gleb Paharenko
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.

locating ibdata1 and *.ibd files in different directories.

2005-12-18 Thread Nathan Gross
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