MySQL Forums
Forum List  »  InnoDB

Re: Chaning database dir to another hard drive
Posted by: Rick James
Date: October 28, 2010 10:10PM

Simplest would be to move the entire directory, and change any my.ini settings as needed. I see about 5 that all point to the same directory (or subdirectories thereof).

If, on the other hand, you need to split the things between drives, it may get a bit tricky. The obvious split would be between
innodb_data_home_dir and datadir

http://dev.mysql.com/doc/refman/5.0/en/installation-layouts.html
has some discussion.

Whether you have innodb_file_per_table ON may be significant.

Alas symbolic links are not useful in Windows, and their equivalent (Junctions) is a bit tricky to set up. (In *nix, I would simply move whatever I felt like, and leave a symlink behind.)

One could debate whether to make some 'intelligent' split of the files (eg logs here; data there. or data here, indexes there), but that rarely makes much performance difference.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Chaning database dir to another hard drive
1236
October 28, 2010 10:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.