Chaning database dir to another hard drive
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
Subject
Views
Written By
Posted
Chaning database dir to another hard drive
3798
October 27, 2010 01:47PM
1238
October 28, 2010 10:10PM
1242
October 28, 2010 11:20PM
1012
October 28, 2010 11:39PM
1345
October 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.