I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
confused on how to relocate the datadir.
my basedir was F:/MySQL and datadir was F:/MySQL/data
It works fine and I'm trying to relocate the datadir:
(0) stop mysql service
(1) copy F:/MySQL/data to F:/DBData/MySQL/data
(2) modify F:/MySQL/my.ini change the line
datadir="F:/MySQL/Data/"
into
datadir="F:/DBData/MySQL/Data/"
(3) restart the service and it says access permission denied even I used
cmd window with win admin privileges.
I've doe such on XP 32bit mysql many times without any problem. So what
wrong above?
Thanks a lot