MySql change data path of each database

Question

Is it possible to change the location/path/directory/folder of a specific database? I hope the answer is not "no".

I know that there is a "datadir" setting in

"X:\Program Files\MySQL\MySQL Server x.x\my.ini"

file in which I can change the path for all databases. However, I want some specific databases to be specific location.

Example, I want “sales” database to be in “C:\sales\db\” folder and “hr” database to be in “C:\hr\db” folder. (Please don’t suggest of placing them in “C:\db\sales” and “C:\db\hr” folder respectively).

If it helps: I’m running MySql 5.1 under Windows XP SP3. I’m used to MS SQL Server’s ability to place database files on (restore to or attach from) user-specify location. I’m new to MySql. Thanx in advance.

Ricardo Uzcategui · Accepted Answer · 2011-11-25 18:22:15Z

2

I found this answer using symbolic link... Maybe this help to you..

http://dev.mysql.com/doc/refman/5.0/en/symbolic-links.html

answered Nov 25, 2011 at 18:22

Ricardo Uzcategui

362 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySql change data path of each database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related