MySQL Forums :: InnoDB :: Chaning database dir to another hard drive


Advanced Search

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

Hi,

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,
Ovi

Options: ReplyQuote


Subject Views Written By Posted
Chaning database dir to another hard drive 3078 ovidiu craciun 10/27/2010 01:47PM
Re: Chaning database dir to another hard drive 1062 Rick James 10/28/2010 10:10PM
Re: Chaning database dir to another hard drive 999 ovidiu craciun 10/28/2010 11:20PM
Re: Chaning database dir to another hard drive 920 Rick James 10/28/2010 11:39PM
Re: Chaning database dir to another hard drive 1180 ovidiu craciun 10/28/2010 11:48PM


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.