I have datadir=C:/MySQLData in my my.ini file.
I have an external harddisk that contains a huge mysql database.
Is there any way I can dynamically add another location to datadir ? (Say like F:\somefolder\)
Or atleast the new location temporarily instead of the one mentioned in the config file ?
I know that you can do this under UNIX but under windows I am not sure. I believe that all you would have to do is install the disk under your current windows installation and then mount the drive under Control Panel-> Admin Tools-> Computer Management --> Disk Management and install it there. This assumes that you are using 2K or XP.
Once the drive is installed and has a drive letter you should be able at that point to modify your my.conf file as you indicated to draw the db.