Steps for how to move Mysql database from C: drive to D or any other Drive!!!
Step 1:
Cut the folder of database which you want to move from mysql c: data folder
For e.g. in my case
Database path: C:\Program Files (x86)\MySQL\MySQL Server 5.0\data
Database name: tejash
Step 2:
Paste it where you want to put
E.g. if I want move tejash database and want to put D:\database folder
I have pasted whole tejash folder with all files to D:\database
Note for new database the create blank folder
Step 3:
Create Symbolic Links for Databases on Windows. Just create one file with .sym extension same name as database name and put it into your database folder path and in that file only mention the path of the folder D:\database
In my case I have created a file name tejash.sym and put the file into C:\Program Files (x86)\MySQL\MySQL Server 5.0\data
File content only “D:\database\tejash”
The following precaution you have to take to the use of .sym files for database symbolic linking on Windows:
1) In your database path folder should not be have same name folder (in my case in C:\Program Files (x86)\MySQL\MySQL Server 5.0\data there should not be folder call tejash)
2) If you run mysqld as a service, you cannot use a mapped drive to a remote server as the destination of the symbolic link. As a workaround, you can use the full path (\\servername\path\).
For more reference kindly check http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html
