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 files, they're > stored in the > database directory, however, you can use symbolic links for databases to have > them in another place. 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? > >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? And leave the original subdirs(databases) in the original place? I can try. This means though, that the absolute db paths are coded into the ibdata 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 Is mysql smart enough not to use my indices when importing until after the import, or should I de-activate my indices until after the import? Also, is there a formula of what I can expect the size of the dumped files to be? Thank you much! -nat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
