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 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? mysqldump from 5.0.17 distribution sets FOREIGN_KEY_CHECKS to 0; for your version you can check this by yourself. > Also, is there a formula of what I can expect the size of the dumped > files to be? For a pity, I don't know any formula, even approximate. Nathan Gross wrote: > 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 s= > > tored 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 somew= > > here 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 > -- 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]
