Steps for how to move Mysql database from default drive to other Drive!!!

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