MySQL Forums
Forum List  »  InnoDB

Chaning database dir to another hard drive
Posted by: ovidiu craciun
Date: October 27, 2010 01:47PM


I have mysql installed on windows in c:\ drive
I just installed a much faster hard drive d:\ and I want to move all the mysql databases to this a new directory d:\newmysqldata

I've been searching the net for the best way to do it and I am a bit confused.
I undestand I have to copy the current mysql\data directory to the new directory; what I am not clear about is if I should copy the whole content or skip ib_logfile* file?
Also, since I copy only the mysql/data folder why do I have to change in the coonfig file the basedir setting? from what I understand the basedir is the installation dir which I am not going to change... right?

CAn someone please shed some light on how should I proceed on windows platform with this move before I go ahead and experiment with the life server?

Thank you,

Options: ReplyQuote

Written By
Chaning database dir to another hard drive
October 27, 2010 01:47PM

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.